jprante / elasticsearch-csv Goto Github PK

hello @jprante wanted to consult you where I can get the version 1.3.0.0 is not available as http://xbib.org/repository/org/xbib/elasticsearch/plugin/elasticsearch-csv/1.3.0.0

How to add _version in the output? Query below does not return _version of the doc:

GET /_search_csv?with_id&with_index&keys=_id,_version,_timestamp,fielda&size=10
{
"fields" : [ "_source","_version","_timestamp"]
,"query": {
"match_all": {}
}
}

Running ES 1.3.4 with java 1.7.0_51 and installed the 1.3.0.0 plug-in. github says that it works with ES 1.3.2 and I was hoping it would work with 1.3.4 as well. cluster re-start was fine

loaded [csv-1.3.0.0-55f146c, jdbc-1.3.4.4-d2e33c3, knapsack-1.3.2.0-d5501ef], sites [bigdesk, head]

and there were no problems with the cluster (running locally on port 9200) which has an index/type of order/header. However, running

curl -XGET "http://localhost:9200/order/_search_csv"
or
curl -XGET "http://localhost:9200/order/header/_search_csv"

or doing the same as a POST, I get a response of

{"error":"NullPointerException[null]","status":500}

Is the plugin compatible with ES 1.3.4? And if so, what am I missing?

Thanks in advance. Keep up the great work!

It would be good if you can include a query parameter , where we can pass a query and get the results back as CSV

Hi @jprante, is it meant to save as _search_csv all the time? Thank you.

This is all I get. The formats are good because it previously worked but I don't want to run a vulnerable version of elasticsearch as you know. I'm running 1.6.0 and the following output is all I get.

{"error":"ElasticsearchIllegalArgumentException[No feature for name [_search_csv]]","status":400}

This plug-in is very useful - thank you!

However, when I try to start ES 1.4.1 or 1.4.2 with this plugin installed, the cluster won't start and there is no error (looks like no cluster master is elected but that's just a guess since there are no log entries indicating that). Trying to start 1.4.2 with latest version of river-jdbc, head and bigdesk starts the cluster as expected but install this plugin and the cluster start up just hangs.

Logs show

[2014-12-28 20:27:59,603][INFO ][node ] [Man-Thing] initializing ...
[2014-12-28 20:27:59,650][INFO ][plugins ] [Man-Thing] loaded [jdbc-1.4.0.6-664f819, csv-1.3.0.0-55f146c], sites [bigdesk, head]

and then nothing.

Any chance of getting this updated to be 1.4 compatible? Thanks again!

Is there any plan to support elastic search 1.7?

In CSV it is realy problem, becasue it corrupts data structure.

When a key passed as parameter references a multi-value field, it won't bring any values to this field in the resulting csv

http://xbib.org/repository/org/xbib/elasticsearch/plugin/elasticsearch-csv/1.4.0.0/elasticsearch-csv-1.4.0.0-plugin.zip is a 404 right now,

correct url seems to be http://xbib.org/repository/org/xbib/elasticsearch/plugin/elasticsearch-csv/1.4.0.1/elasticsearch-csv-1.4.0.1-plugin.zip

On Elasticsearch 1.4.0 on starting elasticsearch after installing elasticsearch-csv the following error occurs:

`{1.4.0}: Initialization Failed ...

1. NoSuchMethodError[org.elasticsearch.rest.BaseRestHandler.(Lorg/elasticsearch/common/settings/Settings;Lorg/elasticsearch/client/Client;)V]`

I can not get meta data like _parent, _id etc. with search_csv.

Is there an option to use other field separator than comma?

• Pasi -

Hi,
I have been using this plugin and it works for ElasticSearch version 1.5.0.
After I upgrade ElasticSearch to version 1.6.0, I get this error when using this plugin:
{
"error": "NoSuchMethodError[org.elasticsearch.rest.BytesRestResponse.(Lorg/elasticsearch/rest/RestStatus;Ljava/lang/String;Lorg/elasticsearch/common/bytes/BytesReference;Z)V]",
"status": 500
}

Are you planning to release a new version which is compatible with ES version 1.6.0?

In the logfile, it says:
[2015-07-15 03:51:09,755][ERROR][csv ] org.elasticsearch.rest.BytesRestResponse.(Lorg/elasticsearch/rest/RestStatus;Ljava/lang/String;Lorg/elasticsearch/common/bytes/BytesReference;Z)V
java.lang.NoSuchMethodError: org.elasticsearch.rest.BytesRestResponse.(Lorg/elasticsearch/rest/RestStatus;Ljava/lang/String;Lorg/elasticsearch/common/bytes/BytesReference;Z)V
at org.xbib.elasticsearch.rest.csv.CSVToXContentListener.buildResponse(CSVToXContentListener.java:104)
at org.xbib.elasticsearch.rest.csv.CSVToXContentListener.buildResponse(CSVToXContentListener.java:27)
at org.elasticsearch.rest.action.support.RestResponseListener.processResponse(RestResponseListener.java:43)
at org.elasticsearch.rest.action.support.RestActionListener.onResponse(RestActionListener.java:49)
at org.elasticsearch.action.search.type.TransportSearchQueryThenFetchAction$AsyncAction$2.doRun(TransportSearchQueryThenFetchAction.java:152)
at org.elasticsearch.common.util.concurrent.AbstractRunnable.run(AbstractRunnable.java:36)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)