Hello, i have index names as alpha-* and when i try to run SQL query on the index it throws error POST /_xpack/sql?format=txt { "query": "SELECT * FROM alpha-* " } error :-1: "type": "parsing_exception", "reason": "line 1:20: mismatched input '-' expecting {, ',', 'ANALYZE', 'ANALYZED', 'AS',…

Try with "query": "SELECT * FROM \"alpha-*\" "

SQL Query not executing

dadoonet (David Pilato) July 19, 2019, 1:09pm 5

See https://www.elastic.co/guide/en/elasticsearch/reference/7.2/sql-index-patterns.html#sql-index-patterns-multi

Topic		Replies	Views
Error sql api index name with '-' Elasticsearch	3	553	July 24, 2018
X-pack 6.3 sql query Elasticsearch elastic-stack-sql	7	2710	July 26, 2018
SQL Query special chars Elasticsearch	2	3506	October 15, 2018
Unable to perform sql select on logstash index Elasticsearch elastic-stack-sql	2	553	April 15, 2019
Elasticsearch sql not accepting index with - in it Elasticsearch elastic-stack-sql	2	474	May 6, 2019

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.

SQL Query not executing

Related topics