JDBC importer successfully able to connect to elasticsearch, and creates the index also, but failing in index mapping and data importing.
Sample Config File.
{
"type" : "jdbc",
"jdbc" : {
"url" : "jdbc:oracle:thin:@//localhost:1521/xe",
"user" : "root",
"password" : "root",
"sql" : "select ID as "_id", NAME as "o.t", DESCRIPTION as "o.s" from test",
"column_name_map" : {
"_id" : "id",
"o" : "order",
"t" : "transaction_id",
"s" : "status"
},
"index" : "test",
"type" : "test"
}
}
is any problem in config file. Is the JDBC importer is compatible with oracle DB.