Skip to main content

Import JSON raw data to ElasticSearch using Python in one line of commands

Project description

json-py-es
==========
Alexander Liu
* To import raw JSON data files to ElasticSearch using Python in one line of commands

### Installation

* ```pip install jsonpyes```

> In the past we import data in this way. Too many jobs by hands...
> ![Alt](static/snapshot106.jpg)
>
> Using ElasticSearch Bulk API to import this data, sometimes ES only recognizes data in its API way.
>
> But now let `json-py-es` glue them all.


jsonpyes
--------
![Alt](static/snapshot104.jpg)

#### Instructions:
There are 3 proccesses of importing raw JSON data to ElasticSearch
1. Only validating raw JSON data
2. Without validating ,just import data to ElasticSearch
3. After validating successfully, then import data to ElasticSearch


##### 1. Only validating
* ```python jsonpyes.py --data raw_data.json --check```

* If the json data file is valid:
![Alt](static/snapshot98.jpg)

* If the json data file is invalid:
![Alt](static/snapshot99.jpg)

##### 2. Only importing without validating
* Notice: If the raw JSON data file is invalid, ElasticSearch will not import it.
* ```python jsonpyes.py --data raw_data.json --bulk http://localhost:9200 --import --index myindex2 --type mytype2```
* Or enable multi-threads ```python jsonpyes.py --data raw_data.json --bulk http://localhost:9200 --import --index myindex2 --type mytype2 --thread 8```
![Alt](static/snapshot102.jpg)

** jsonpyes supports multi-threads when importing data to elasticsearch
![Alt](static/snapshot132.png)

> As you can see these two containers have same docs loaded, if we use **_--thread 8_** it could be slightly faster.
That really depends on your computer/server resources.
This was tested on a 4GB RAM / 2.4Ghz intel i5 Linux x64 laptop system.

![Alt](static/snapshot133.png)

* And it works.
![Alt](static/snapshot105.jpg)

##### 3. Both validating and importing
* ```python jsonpyes.py --data raw_data.json --bulk http://localhost:9200 --import --index myindex1 --type mytype1 --check```
![Alt](static/snapshot135.png)

* And it works.
![Alt](static/snapshot101.jpg)



##### Happy hacking!

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

jsonpyes-1.1.8.tar.gz (5.0 kB view details)

Uploaded Source

Built Distribution

jsonpyes-1.1.8.linux-x86_64.tar.gz (5.0 kB view details)

Uploaded Source

File details

Details for the file jsonpyes-1.1.8.tar.gz.

File metadata

  • Download URL: jsonpyes-1.1.8.tar.gz
  • Upload date:
  • Size: 5.0 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No

File hashes

Hashes for jsonpyes-1.1.8.tar.gz
Algorithm Hash digest
SHA256 f07297c40b1122a190cc662c476b41bf123717e7da49d5590e9a9a374255e81b
MD5 9e144b1f4d2dc8d715408f7451205da7
BLAKE2b-256 b91cac1546b57321e4b8262d164df4861c68cc8df9bd4272b0c42a8215be8ffc

See more details on using hashes here.

File details

Details for the file jsonpyes-1.1.8.linux-x86_64.tar.gz.

File metadata

File hashes

Hashes for jsonpyes-1.1.8.linux-x86_64.tar.gz
Algorithm Hash digest
SHA256 eb016af15580a89b4307266303f82689cd9ce625a4587b59feec7a00e479fa5e
MD5 f4fef291203ab1cf68acbab9a7f4c7f1
BLAKE2b-256 b4b945b2f24639bee5feeb234f3f23fd0386c0a27b5d5fd3bf915503d6f239e7

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page