[jira] [Created] (CALCITE-3337) Support query arrays of Embedded Documents in MongoDB adapter

["Martin Dearnley (Jira)" <ji...@apache.org>]

Martin Dearnley created CALCITE-3337:
----------------------------------------

             Summary: Support query arrays of Embedded Documents in MongoDB adapter
                 Key: CALCITE-3337
                 URL: https://issues.apache.org/jira/browse/CALCITE-3337
             Project: Calcite
          Issue Type: Improvement
          Components: mongodb-adapter
            Reporter: Martin Dearnley


With CALCITE-194 it will be possible to SELECT elements of arrays. 

Would be great to support WHERE clauses for arrays especially for arrays of embedded documents.

 

I tried it with the fix from CALCITE-194
{code:java}
  {
    "name": "ZIPS",
    "type": "view",
    "sql": "select cast(_MAP['city'] AS varchar(20)) AS city,\n cast(_MAP['loc'][0] AS float) AS longitude, cast(_MAP['loc'][1] AS float) AS latitude, cast(_MAP['pop'] AS integer) AS pop, cast(_MAP['state'] AS varchar(2)) AS state, cast(_MAP['_id'] AS varchar(5)) AS id from \"mongo_raw\".\"zips\""
   }

 Select longitude from zips where longitude = -71.425486
{code}
Mongo Adapter Exception
{code:java}
java.lang.AssertionError: cannot translate op null call =(CAST(CAST(ITEM(ITEM($0, 'loc'), 0)):FLOAT):DOUBLE, -71.425486)
{code}



--
This message was sent by Atlassian Jira
(v8.3.2#803003)