# Jdbc-elasticsearch table names with hyphens

**URL:** <https://discuss.elastic.co/t/jdbc-elasticsearch-table-names-with-hyphens/29069>\
**Category:** Elasticsearch\
**Created:** [September 10, 2015, 8:26pm UTC](https://discuss.elastic.co/t/jdbc-elasticsearch-table-names-with-hyphens/29069 "2015-09-10T20:26:21Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![entreri](https://avatars.discourse-cdn.com/v4/letter/e/bb73d2/32.png) [@entreri](https://discuss.elastic.co/u/entreri)\
**Post date:** [September 10, 2015, 8:26pm UTC](https://discuss.elastic.co/t/jdbc-elasticsearch-table-names-with-hyphens/29069/1 "2015-09-10T20:26:22Z")

</div>

Hello, any jdbc-elasticsearch users here who can help me figure out how to query data from MS SQL servers which have table names containing hyphens? I can't seem to get around the following error...

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '-'.

My select statement is as follows...

```
 "sql":"select * from TEST_Live-Orders",

```

Kind regards,

---

<div class="post-metadata">

**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\
**Post date:** [September 10, 2015, 8:30pm UTC](https://discuss.elastic.co/t/jdbc-elasticsearch-table-names-with-hyphens/29069/2 "2015-09-10T20:30:51Z")

</div>

Have you tried quoting the table name with square brackets?

> <https://stackoverflow.com/questions/2901453/sql-standard-to-escape-column-names/2901473#2901473>

---

<div class="post-metadata">

**Author:** ![entreri](https://avatars.discourse-cdn.com/v4/letter/e/bb73d2/32.png) [@entreri](https://discuss.elastic.co/u/entreri)\
**Post date:** [September 10, 2015, 8:46pm UTC](https://discuss.elastic.co/t/jdbc-elasticsearch-table-names-with-hyphens/29069/3 "2015-09-10T20:46:16Z")

</div>

Hi Magnus, thanks for the reply. I have and that didn't work either. I'm guessing I have to do something special with the jdbc script or something.

---

<div class="post-metadata">

**Author:** ![entreri](https://avatars.discourse-cdn.com/v4/letter/e/bb73d2/32.png) [@entreri](https://discuss.elastic.co/u/entreri)\
**Post date:** [September 13, 2015, 8:39pm UTC](https://discuss.elastic.co/t/jdbc-elasticsearch-table-names-with-hyphens/29069/4 "2015-09-13T20:39:28Z")

</div>

Hi again Magnus, that actually worked. When I had first tried brackets I had other syntax issues. Thanks a bunch!

---

<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:** [July 5, 2017, 11:50pm UTC](https://discuss.elastic.co/t/jdbc-elasticsearch-table-names-with-hyphens/29069/5 "2017-07-05T23:50:35Z")

</div>