curl -XPUT 'localhost:9200/_river/jdbc/_meta' -d '{
    "type" : "jdbc",
    "jdbc": {
   "driver" : "com.mysql.jdbc.Driver",
        "url" : "jdbc:mysql://localhost:3306/dbname",
        "user" : "username",
        "password" : "password",
        "sql": "select * from table where cat_id=1"
        "poll": "24h",
        "strategy": "simple",
        "scale": 0,
        "autocommit": true,
        "bulk_size": 5000,
        "max_bulk_requests": 30,
        "bulk_flush_interval": "5s",
        "fetchsize": 100,
        "max_rows": 200000,
        "max_retries": 3,
        "max_retries_wait": "10s",
        "locale": "in",
        "digesting": true,
}}

"sql": "select * from table where module_id>6 AND cat_id != 1"