# Execute sql queries in elassandra \[elastic search\]

**URL:** <https://discuss.elastic.co/t/execute-sql-queries-in-elassandra-elastic-search/294260>\
**Category:** Elasticsearch\
**Created:** [January 13, 2022, 10:57am UTC](https://discuss.elastic.co/t/execute-sql-queries-in-elassandra-elastic-search/294260 "2022-01-13T10:57:51Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![kvaishnavi97](https://avatars.discourse-cdn.com/v4/letter/k/c0e974/32.png) [@kvaishnavi97](https://discuss.elastic.co/u/kvaishnavi97)\
**Post date:** [January 13, 2022, 10:57am UTC](https://discuss.elastic.co/t/execute-sql-queries-in-elassandra-elastic-search/294260/1 "2022-01-13T10:57:51Z")

</div>

Hi, I am using Elassandra [Combination of Elasticsearch + Cassandra], I want to execute sql queries in Elasticsearch, But I am getting one exception. I gone inside the elassandra pod,  
tried this cmd

`curl -XPOST [http://localhost:9200/indexalarm/\_sql?format=txt](http://localhost:9200/indexalarm/_sql?format=txt) -H 'Content-Type: application/json' -d '{"query": "SELECT \* FROM tl1\_active"}'

here indexalarm is a index name and tl1\_active is a table name created in cassandra.

Following is the response I got

`{"error":{"root_cause":[{"type":"runtime_exception","reason":"InvalidTypeNameException[Document mapping type name can't start with '_', found: [_sql]]"}],"type":"runtime_exception","reason":"InvalidTypeNameException[Document mapping type name can't start with '_', found: [_sql]]","caused_by":{"type":"invalid_type_name_exception","reason":"Document mapping type name can't start with '_', found: [_sql]"}},"status":500}`

Can anyone please help where I am going wrong?

Thanks

---

<div class="post-metadata">

**Author:** ![Tomo\_M](https://avatars.discourse-cdn.com/v4/letter/t/848f3c/32.png) [@Tomo\_M](https://discuss.elastic.co/u/Tomo_M)\
**Post date:** [January 13, 2022, 1:06pm UTC](https://discuss.elastic.co/t/execute-sql-queries-in-elassandra-elastic-search/294260/2 "2022-01-13T13:06:12Z")

</div>

I suppose this is an Elassandra specific problem and it is better to ask somewhere about Elassandra.

Though I'm not familiar with Elassandra, as for [Elasticsearch SQL API](https://www.elastic.co/guide/en/elasticsearch/reference/current/sql-search-api.html), `/index_name/_sql?...` is not a valid Elasticsearch API request. In Elasticsearch, you have to use `_sql?...` only and set index name in FROM clause.

---

<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:** [February 10, 2022, 1:06pm UTC](https://discuss.elastic.co/t/execute-sql-queries-in-elassandra-elastic-search/294260/3 "2022-02-10T13:06:25Z")

</div>

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