Not having a lot of luck here
Installed the plugin based on Github, and tried the request. I'm getting a
fail..
curl -XPUT 'localhost:9200/_river/my_csv_river/_meta' -d '
{
"type": "jdbc",
"jdbc": {
"url": "jdbc:xbib:csv:/home/user",
"sql": "select * from garages",
"index": "csv",
"type": "csv"
}
}'
{"_index":"_river","_type":"my_csv_river","_id":"_meta","_version":4,"created":false}
On Sun Jan 25 2015 at 7:57:29 AM joergprante@gmail.com <
joergprante@gmail.com> wrote:
I finally managed to modify the CsvJdbc driver from
http://csvjdbc.sourceforge.net/ so it behaves nicely and pushed it to
GitHub - jprante/jdbc-driver-csv: JDBC driver for CSV
So the news is, if you install JDBC river 1.4.0.9 onwards, a CSV driver is
included.
GitHub - jprante/elasticsearch-jdbc: JDBC importer for Elasticsearch
To index CSV files from a directory without knowing the column names, just
use
curl -XPUT 'localhost:9200/_river/my_csv_river/_meta' -d '
{
"type": "jdbc",
"jdbc": {
"url": "jdbc:xbib:csv:/Users/joerg/Desktop/csv",
"sql": "select * from airports",
"index": "csv",
"type": "csv"
}
}'
In the URL, you specify a directory, in the SQL statement table name, you
select a file from within the directory (without .csv suffix, here:
airports.csv)
Jörg
On Sun, Jan 25, 2015 at 7:55 AM, Ron rulko313@gmail.com wrote:
Yup.. I'm one of the guys posting in that Issue log..
On Sunday, January 25, 2015 at 12:26:04 AM UTC-5, David Pilato wrote:
I think you are looking for this?
Make it easier to ingest CSV files · Issue #2088 · elastic/logstash · GitHub
--
David 
Twitter : @dadoonet / @elasticsearchfr / @scrutmydocs
Le 25 janv. 2015 à 03:40, Ron rulk...@gmail.com a écrit :
The same issue exists with the Logstash plugin. You have to define the
field names in the Logstash config file.
Almost worse, each time you update field names, you have to restart
logstash.
On Friday, January 23, 2015 at 5:23:49 PM UTC-5, Mark Walkom wrote:
You could use Logstash for this as well, it has a CSV filter.
On 24 January 2015 at 01:21, Ron rulk...@gmail.com wrote:
Hello all,
So I'm trying to import a large number of CSV files into
Elasticsearch. All the files have different content in them, with different
headers.
My goal is to have a directory we can drop CSVs into, and some plugin
or process would pick them up, read the header and place the data in
Elasticsearch mapping data to fields (gotten from the header).
I've looked at the CSV River plugin and Fluentd. It looks like they
both support half of the plan. The issue we run into is it looks like both
want static field names before import.
Am I wrong? Anyone's help would be wonderful.
Thanks
Ron
--
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 elasticsearc...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/
msgid/elasticsearch/54f555d9-1d66-4b19-9334-90dde4fc658a%
40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/54f555d9-1d66-4b19-9334-90dde4fc658a%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.
--
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 elasticsearc...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/
msgid/elasticsearch/620537a8-7bf4-4acf-b5ea-46c2d24c3812%
40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/620537a8-7bf4-4acf-b5ea-46c2d24c3812%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.
--
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/e5f58365-65e7-45b6-a1ce-b86f55d655df%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/e5f58365-65e7-45b6-a1ce-b86f55d655df%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to a topic in the
Google Groups "elasticsearch" group.
To unsubscribe from this topic, visit
https://groups.google.com/d/topic/elasticsearch/wDathej_ySQ/unsubscribe.
To unsubscribe from this group and all its topics, send an email to
elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/CAKdsXoETGaDFHbZX3ncmGi_-sFAVCwpYOjoWkkX%3DCjrLkoXb5A%40mail.gmail.com
https://groups.google.com/d/msgid/elasticsearch/CAKdsXoETGaDFHbZX3ncmGi_-sFAVCwpYOjoWkkX%3DCjrLkoXb5A%40mail.gmail.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.
--
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/CAKKgDVEeMa%3Dp9QyCtjuNN%3Dzx528cPHtP2yP%2BKb6hmYdqj3f43A%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.