Problem with SQL Query with special character in field and table name

Elastic Stack Elasticsearch
4

OK. Got it to work. Andrei was right, you will have to escape it. I ran this on the console as follows:

POST _xpack/sql
{
  "query": "select \"@timestamp\" from \"my-alarms-2018.08.28\""
}

Apparently, you had to escape the double quotes. :smile:

2 Likes