Skip to main content

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

Project description


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

Alexander Liu

- To import raw JSON data files to ElasticSearch in one line of

.. figure:: static/jsonpyes_data_processing_diagram.png
:alt: jsonpyes diagram

jsonpyes diagram
Very fast -- 4 to 10 times faster when processing big data.


``pip install jsonpyes``

**Notice**: Before using ``pip`` to install ``jsonpyes``, firstly
you need to install ``python-pip`` on your system. ( Supports
Python2.6, Python2.7 )


.. figure::
:alt: user interface

user interface


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

A valid JSON file here refers to a JSON file stacked with many lines of data

file valid_data.json and its content

{"key1": "valueA", "key2": {"sub_key1": "value2A", "sub_key2": ["Good", "Morning"]}}
{"key1": "valueB", "key2": {"sub_key1": "value2B", "sub_key2": ["Good", "Afternoon"]}}
{"key1": "valueC", "key2": {"sub_key1": "value2C", "sub_key2": ["Good", "Evening"]}}

Functions included

1. Validating JSON format data

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

If the json data file is valid:

.. figure::
:alt: json valid

json valid
If the json data file is invalid:

.. figure::
:alt: json invalid

json invalid
2. Only importing without validating

``jsonpyes --data raw_data.json --bulk http://localhost:9200 --import --index myindex2 --type mytype2``

Notice: If the raw JSON data file is invalid, ``jsonpyes`` will not
import it.

Or enable multi-threads
``jsonpyes --data raw_data.json --bulk http://localhost:9200 --import --index myindex2 --type mytype2 --thread 8``

.. figure::
:alt: no threads

no threads
``jsonpyes`` supports multi-threads when importing data to elasticsearch

Multi-threads comparison

1. No multi-threads

.. figure::
:alt: benchmarks

2. With 8 threads and ``jsonpyes`` cuts files into pieces, then
destributes to workers fairly

.. figure::
:alt: use helpers.bulk API with multi-threads

use helpers.bulk API with multi-threads

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

And it works.

.. figure::
:alt: it works

it works
3. Both validating and importing

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

.. figure::
:alt: validating and importing

validating and importing
And it works.

.. figure::
:alt: the results

the results

- Algorithm handwritting

.. figure::
:alt: handwritting

Happy hacking!

.. |Build Status| image::
.. |GitHub release| image::
.. |GitHub license| image::

Project details

Download files

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

Filename, size & hash SHA256 hash help File type Python version Upload date
jsonpyes-1.3.1.tar.gz (9.2 kB) Copy SHA256 hash SHA256 Source None

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN SignalFx SignalFx Supporter DigiCert DigiCert EV certificate StatusPage StatusPage Status page