elasticsearch-jdbc icon indicating copy to clipboard operation
elasticsearch-jdbc copied to clipboard

Need assistance for the beginner

Open artoban opened this issue 8 years ago • 0 comments

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:

  1. Does I need to have the index let's say named "twitter" into my ES before I launch the oracle-connection-properties.sh ?
  2. 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

  1. If I must previously create the index where the JDBCImporter will write, how such index must looks like for my table?

artoban avatar Mar 21 '17 11:03 artoban