curl -X POST " http://localhost:9200/_xpack/sql?format=json " -H 'Content-Type: application/json' -d' { "query": "SELECT * FROM logstash-2018.06.28" } ' {"error":{"root_cause":[{"type":"parsing_exception","reason":"line 1:23: mismatched input '-' expecting {, ',', 'FULL', 'GROUP', 'HAVING', 'INNE…

X-pack 6.3 sql query

Andrei_Stefan (Andrei Stefan) June 28, 2018, 11:34am 7

Also, regarding the error about arrays - Elasticsearch SQL doesn't support them at the moment.

Elasticsearch is a trademark of Elasticsearch BV, registered in the U.S. and in other countries
Trademarks
Terms
Privacy
Brand
Code of Conduct

Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.