elasticsearch-jdbc
elasticsearch-jdbc copied to clipboard
Need assistance for the beginner
Let's say I have some simplest oracle DB table named "user" contains 2 columns : _id as int and _name as varchar2 (30).
- I have Elastic-search (ES) on some machine.
- I have the JDBCImporter installed as described. I have ojdbc7.jar - driver into it's lib-folder.
- Now I attempt to launch the : sh oracle-connection-properties.sh
I receive the log: [12:27:35,121][INFO ][org.xbib.elasticsearch.helper.client.BaseMetricTransportClient][pool-2-thread-1] found mapping for twitter [12:27:35,791][ERROR][importer.jdbc.context.standard][pool-2-thread-1] after fetch: no such index org.elasticsearch.index.IndexNotFoundException: no such index ....
My questions are follows:
- Does I need to have the index let's say named "twitter" into my ES before I launch the oracle-connection-properties.sh ?
- Let's say I create such index manually via:
curl -XPUT 'localhost:9200/twitter?pretty' -H 'Content-Type: application/json' -d' { "settings" : { "index" : { "number_of_shards" : 3, "number_of_replicas" : 2 } } } ' { "acknowledged" : true }
I receive other error into the log:
[12:53:43,892][INFO ][org.xbib.elasticsearch.helper.client.BaseMetricTransportClient][pool-2-thread-1] settings = {index={number_of_shards=3, number_of_replica=2}} [12:53:43,893][INFO ][org.xbib.elasticsearch.helper.client.BaseMetricTransportClient][pool-2-thread-1] found mapping for twitter [12:53:44,204][WARN ][importer.jdbc.sink.standard][pool-2-thread-1] already exists
- If I must previously create the index where the JDBCImporter will write, how such index must looks like for my table?