# Questions about SQL CLI

**URL:** <https://discuss.elastic.co/t/questions-about-sql-cli/205803>\
**Category:** Elasticsearch\
**Created:** [October 30, 2019, 7:36am UTC](https://discuss.elastic.co/t/questions-about-sql-cli/205803 "2019-10-30T07:36:56Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![smash](https://avatars.discourse-cdn.com/v4/letter/s/e274bd/32.png) [@smash](https://discuss.elastic.co/u/smash)\
**Post date:** [October 30, 2019, 7:36am UTC](https://discuss.elastic.co/t/questions-about-sql-cli/205803/1 "2019-10-30T07:36:56Z")

</div>

hello

hello!  
If "-" is included in index, an error occurs.  
How can I escape? \ Was added but it was not escaped.

#Error Msg  
Sql\>select Count(\*) from db01-TEST;  
Bad request [line 1:25: extraneous input '-' expecting {, ',', '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}]

---

<div class="post-metadata">

**Author:** ![matriv](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/matriv/32/43656_2.png) [@matriv](https://discuss.elastic.co/u/matriv)\
**Post date:** [October 30, 2019, 10:55pm UTC](https://discuss.elastic.co/t/questions-about-sql-cli/205803/2 "2019-10-30T22:55:14Z")

</div>

`select count(*) from "db01-TEST";`

---

<div class="post-metadata">

**Author:** ![smash](https://avatars.discourse-cdn.com/v4/letter/s/e274bd/32.png) [@smash](https://discuss.elastic.co/u/smash)\
**Post date:** [October 31, 2019, 5:23am UTC](https://discuss.elastic.co/t/questions-about-sql-cli/205803/3 "2019-10-31T05:23:51Z")

</div>

to matriv

thanks

We were able to execute as shown！

---

<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 28, 2019, 5:23am UTC](https://discuss.elastic.co/t/questions-about-sql-cli/205803/4 "2019-11-28T05:23:59Z")

</div>

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