Elasticserach jdbc river when i index document not created


(jakjothi) #1

I follow this tutorial to indexing document elasticsearch

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 elasticsearch+unsubscribe@googlegroups.com.
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.


(system) #2