Skip to main content

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

Project description

json-py-es
==========

|Build Status| |GitHub release| |PyPI| |GitHub license|

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|

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
--------

.. figure:: static/snapshot139.png
:alt: Alt

Alt
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
''''''''''''''''''

- ``jsonpyes --data raw_data.json --check``

- If the json data file is valid: |Alt|

- If the json data file is invalid: |Alt|

2. Only importing without validating
''''''''''''''''''''''''''''''''''''

- Notice: If the raw JSON data file is invalid, ElasticSearch will not
import it.
- ``jsonpyes --data raw_data.json --bulk http://localhost:9200 --import --index myindex2 --type mytype2``
- Or enable multi-threads
``jsonpyes --data raw_data.json --bulk http://localhost:9200 --import --index myindex2 --type mytype2 --thread 8``
|Alt|

- ``jsonpyes`` supports multi-threads when importing data to
elasticsearch |Alt|

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.

.. figure:: static/snapshot133.png
:alt: Alt

Alt

- And it works. |Alt|

3. Both validating and importing
''''''''''''''''''''''''''''''''

- ``jsonpyes --data raw_data.json --bulk http://localhost:9200 --import --index myindex1 --type mytype1 --check``
|Alt|

- And it works. |Alt|

Happy hacking!
''''''''''''''

.. |Build Status| image:: https://travis-ci.org/xros/jsonpyes.svg?branch=master
:target: https://travis-ci.org/xros/jsonpyes
.. |GitHub release| image:: https://img.shields.io/github/release/xros/jsonpyes.svg
:target: https://github.com/xros/jsonpyes/releases
.. |PyPI| image:: https://img.shields.io/pypi/dm/jsonpyes.svg
:target: https://pypi.python.org/jsonpyes
.. |GitHub license| image:: https://img.shields.io/github/license/xros/jsonpyes.svg
:target: https://github.com/xros/jsonpyes/blob/master/LICENSE
.. |Alt| image:: static/snapshot106.jpg
.. |Alt| image:: static/snapshot98.jpg
.. |Alt| image:: static/snapshot99.jpg
.. |Alt| image:: static/snapshot102.jpg
.. |Alt| image:: static/snapshot132.png
.. |Alt| image:: static/snapshot105.jpg
.. |Alt| image:: static/snapshot135.png
.. |Alt| image:: static/snapshot101.jpg

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.2.18.tar.gz (19.2 kB view details)

Uploaded Source

File details

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

File metadata

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

File hashes

Hashes for jsonpyes-1.2.18.tar.gz
Algorithm Hash digest
SHA256 36455e3d25c32eb71b87500e3eee05e3fb18e0b82ab5412294595512ca3341f2
MD5 bd3b29f07903f40c13765d32a910d0ca
BLAKE2b-256 ea9e236f85d02f08dd037dee67b889a946ec1b54a540a31aa95bea937de7dbfc

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