# Kibana 7.4.0 and SQL Queries :: Can Index Name Have "." Character?

**URL:** <https://discuss.elastic.co/t/kibana-7-4-0-and-sql-queries-can-index-name-have-character/203680>\
**Category:** Kibana\
**Tags:** elastic-stack-sql\
**Created:** [October 15, 2019, 3:09pm UTC](https://discuss.elastic.co/t/kibana-7-4-0-and-sql-queries-can-index-name-have-character/203680 "2019-10-15T15:09:19Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![redapplesonly](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/redapplesonly/32/57700_2.png) [@redapplesonly](https://discuss.elastic.co/u/redapplesonly)\
**Post date:** [October 15, 2019, 3:09pm UTC](https://discuss.elastic.co/t/kibana-7-4-0-and-sql-queries-can-index-name-have-character/203680/1 "2019-10-15T15:09:19Z")

</div>

Hi Kibana Grandmasters,

I recently upgraded to Elasticsearch and Kibana 7.4.0 on Docker, because I want to use the new SQL query-like feature. I watched the training video by Arthur Gimpel, plus read through the online Kibana documentation on how to use Dev Tools to run SQL-like queries. But I’m hitting a syntax error right off the bat.

I have only one index in ES at the moment, called “`myindex2019.10.09`”. I picked that name when I set up Logstash and Elasticsearch, and I didn’t put a lot of thought into which characters to use or not to use. But now that “`myindex2019.10.09`” is populated with data and I want to SQL query it, I get this on Dev Tools:

My query is:

```
GET _sql?format=txt
{
  "query": "SELECT * FROM myindex2019.10.09"
}

```

Dev Tools complains:

```
{
  "error": {
    "root_cause": [
      {
        "type": "parsing_exception",
        "reason": "line 1:27: mismatched input '.10' expecting {<EOF>, ',', 'ANALYZE', 'ANALYZED', 'AS', 'CATALOGS', 'COLUMNS', 'CURRENT_DATE', 'CURRENT_TIME', 'CURRENT_TIMESTAMP', 'DAY', 'DEBUG', 'EXECUTABLE', 'EXPLAIN', 'FIRST', 'FORMAT', 'FULL', 'FUNCTIONS', 'GRAPHVIZ', 'GROUP', 'HAVING', 'HOUR', 'INNER', 'INTERVAL', 'JOIN', 'LAST', 'LEFT', 'LIMIT', 'MAPPED', 'MINUTE', 'MONTH', 'NATURAL', 'OPTIMIZED', 'ORDER', 'PARSED', 'PHYSICAL', 'PLAN', 'RIGHT', 'RLIKE', 'QUERY', 'SCHEMAS', 'SECOND', 'SHOW', 'SYS', 'TABLES', 'TEXT', 'TYPE', 'TYPES', 'VERIFY', 'WHERE', 'YEAR', '{LIMIT', IDENTIFIER, DIGIT_IDENTIFIER, QUOTED_IDENTIFIER, BACKQUOTED_IDENTIFIER}"
      }
    ],
    "type": "parsing_exception",
    "reason": "line 1:27: mismatched input '.10' expecting {<EOF>, ',', 'ANALYZE', 'ANALYZED', 'AS', 'CATALOGS', 'COLUMNS', 'CURRENT_DATE', 'CURRENT_TIME', 'CURRENT_TIMESTAMP', 'DAY', 'DEBUG', 'EXECUTABLE', 'EXPLAIN', 'FIRST', 'FORMAT', 'FULL', 'FUNCTIONS', 'GRAPHVIZ', 'GROUP', 'HAVING', 'HOUR', 'INNER', 'INTERVAL', 'JOIN', 'LAST', 'LEFT', 'LIMIT', 'MAPPED', 'MINUTE', 'MONTH', 'NATURAL', 'OPTIMIZED', 'ORDER', 'PARSED', 'PHYSICAL', 'PLAN', 'RIGHT', 'RLIKE', 'QUERY', 'SCHEMAS', 'SECOND', 'SHOW', 'SYS', 'TABLES', 'TEXT', 'TYPE', 'TYPES', 'VERIFY', 'WHERE', 'YEAR', '{LIMIT', IDENTIFIER, DIGIT_IDENTIFIER, QUOTED_IDENTIFIER, BACKQUOTED_IDENTIFIER}",
    "caused_by": {
      "type": "input_mismatch_exception",
      "reason": null
    }
  },
  "status": 400
}

```

So clearly it doesn’t like that my index name uses the “.” character. I’ve tried enclosing the index name in single quotes, and that doesn’t help either.

My question to the forum is: Is my index name incompatible with the SQL parser because I used the “.” character? Is there a workaround? Or am I doing something else wrong? Thanks!

---

<div class="post-metadata">

**Author:** ![Andrei\_Stefan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/andrei_stefan/32/47533_2.png) [@Andrei\_Stefan](https://discuss.elastic.co/u/Andrei_Stefan)\
**Post date:** [October 16, 2019, 7:24am UTC](https://discuss.elastic.co/t/kibana-7-4-0-and-sql-queries-can-index-name-have-character/203680/2 "2019-10-16T07:24:56Z")

</div>

@redapplesonly you need to [escape](https://www.elastic.co/guide/en/elasticsearch/reference/7.x/sql-lexical-structure.html#sql-syntax-single-vs-double-quotes) the index name because `.` (dot) has a special meaning: `"query": "SELECT * FROM \"myindex2019.10.09\""`.

---

<div class="post-metadata">

**Author:** ![redapplesonly](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/redapplesonly/32/57700_2.png) [@redapplesonly](https://discuss.elastic.co/u/redapplesonly)\
**Post date:** [October 18, 2019, 4:03pm UTC](https://discuss.elastic.co/t/kibana-7-4-0-and-sql-queries-can-index-name-have-character/203680/3 "2019-10-18T16:03:50Z")

</div>

Yes! Absolutely right! Thank you!

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [November 15, 2019, 4:03pm UTC](https://discuss.elastic.co/t/kibana-7-4-0-and-sql-queries-can-index-name-have-character/203680/4 "2019-11-15T16:03:52Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.