I follow this tutorial to indexing document elasticsearch https://github.com/jprante/elasticsearch-river-jdbc
when i make index api call (PUT) http://somedomain.com:9200/_river/myriver/_meta { "type" : "jdbc", "jdbc" : { "strategy" : "oneshot", "driver" : "com.mysql.jdbc.Driver", "url" : "jdbc:mysql://xx.xx.xxx.xxx:3306/portal", "user" : "username", "password" : "password", "sql" : "select item_id as _id, item_id as itemId, item_name as name from item limit 10" }, "index" : { "index" : "myindex", "type" : "mytype" } } The the response shows { "_index": "_river", "_type": "myriver", "_id": "_meta", "_version": 1, "created": true } when i get GET _river/myriver/_meta it shows only 1 document what i sent in jdbc properties. { "_index": "_river", "_type": "myriver", "_id": "_meta", "_version": 1, "found": true, "_source": { "type": "jdbc", "jdbc": { "strategy": "oneshot", "driver": "com.mysql.jdbc.Driver", "url": "jdbc:mysql://xx.xx.xxx.xxx:3306/portal", "user": "username", "password": "password", "sql": "select item_id as _id, item_id as itemId, item_name as name from item limit 10" }, "index": { "index": "myindex", "type": "mytype" } } } in my error log [2014-05-27 00:17:25,402][WARN ][river ] [Typhoid Mary] failed to get _meta from [jdbc]/[myriver] java.lang.NoSuchMethodError: org.xbib.elasticsearch.support.client.node.NodeClient.maxRequestWait(Lorg/elasticsearch/common/unit/TimeValue;)Lorg/xbib/elasticsearch/support/client/node/NodeClient; at org.xbib.elasticsearch.plugin.feeder.AbstractFeeder.setClient(AbstractFeeder.java:205) at org.xbib.elasticsearch.plugin.river.jdbc.JDBCRiver.start(JDBCRiver.java:74) at org.elasticsearch.river.RiversService.createRiver(RiversService.java:148) at org.elasticsearch.river.RiversService$ApplyRivers$2.onResponse(RiversService.java:275) at org.elasticsearch.river.RiversService$ApplyRivers$2.onResponse(RiversService.java:269) at org.elasticsearch.action.support.TransportAction$ThreadedActionListener$1.run(TransportAction.java:93) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:724) -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/5b1b9a64-a1b4-4544-8765-786367a51778%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
