elasticsearch-jdbc
elasticsearch-jdbc copied to clipboard
jprante
JDBC importer for Elasticsearch
Hi is there any planned feature to access data through weblogic jndi ?
ES 2.3.4, JDBC Importer 2.3.4, many other types working including string, long, geoshape (points) pulling from a SQL Server table. I cannot get IP types to work. They are stored...
Scenario: I have a mysql table with a field named executiondate which I've set as my @timestamp. I want a new index created for each new month since the data...
If I run a new river with "{index_settings:{index:{number_of_shards:1}}" for example it will fail with "after fetch: no such index org.elasticsearch.index.IndexNotFoundException: no such index" however if I create the index beforehand...
Hi, I'm trying to create a nested JSON using jdbc, but I cannot replicate the example from the docs: ``` CREATE TABLE blog (name VARCHAR(100), published DATE); CREATE TABLE attachment...
Hello, We had setup environment with ES 2.2.0 and JDBC importer 2.2.0.0 . We are trying to fill index with data from MS SQL database, which we were able to...
I'm trying to import from mysql database some rows with joins with other tables as this: bin=$JDBC_IMPORTER_HOME/bin lib=$JDBC_IMPORTER_HOME/lib echo '{ "type" : "jdbc", "jdbc" : { "elasticsearch.autodiscover":true, "elasticsearch.cluster":"elasticsearch", "url" :...
Can somebody explain why this query doesn't work when used with elasticsearch-jdbc? `SELECT CASE WHEN TRANSFERTYPE = 4 THEN 'yes' ELSE 'no' END AS BILLABLE, FROM TIMETABLE` Whilst this does...
data type _id id enterpriseMaterial 806450891548564141 1 806450891548564100 enterpriseMaterial 806450891548564146 1 806450891548564100 sql SELECT `ID` AS `_id`,`ID` ......... There are a lot of similar data
