[jira] [Created] (METAMODEL-229) Unable to use a field from Document in ES in the where clause within the query

["Akash Suryawanshi (JIRA)" <ji...@apache.org>]

Akash Suryawanshi created METAMODEL-229:
-------------------------------------------

             Summary: Unable to use a field from Document in ES in the where clause within the query
                 Key: METAMODEL-229
                 URL: https://issues.apache.org/jira/browse/METAMODEL-229
             Project: Apache MetaModel
          Issue Type: Bug
    Affects Versions: 4.5.0
            Reporter: Akash Suryawanshi


I am trying to use an SQL like query to retrieve some rows/documents from ElasticSearch.

The query works fine when the query has the `_id` in the where clause i.e.. it returns me the row
{code}
select * from superhero where _id='4'
{code}

an equivalent query with the where clause changed to a field in the Document returns me no rows.
{code}
select * from superhero where name='Wolverine'
{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)