[ https://issues.apache.org/jira/browse/DRILL-2440?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jacques Nadeau resolved DRILL-2440. ----------------------------------- Resolution: Fixed Resolved in 314e5a2 > Drill should support MongoDB's extended JSON support > ---------------------------------------------------- > > Key: DRILL-2440 > URL: https://issues.apache.org/jira/browse/DRILL-2440 > Project: Apache Drill > Issue Type: Bug > Components: Storage - JSON > Affects Versions: 0.7.0 > Environment: Windows embeded mode. MongoDB plugin > Reporter: Filip Grabowski > Assignee: Jacques Nadeau > Fix For: 0.9.0 > > > I configured Apache drill and connected to Mongo and created some nice > queries. > This is a query that works fine - just a proof that the environment is > configured. > SELECT interactionDateTime FROM interactionrecord limit 5; > { "$date" : "2015-03-05T00:08:10.753Z"} > { "$date" : "2015-03-05T00:08:10.794Z"} > { "$date" : "2015-03-05T00:08:10.803Z"} > { "$date" : "2015-03-05T00:08:35.180Z"} > { "$date" : "2015-03-05T00:08:35.180Z"} > This simple query fails regardless of upper or lower case of function name. > Similarly fail other queries that use other data time functions. This one > seemed the simplest... > SELECT CURRENT_DATE FROM interactionrecord limit 5; > Query failed to execute. Execute Query failed. > Error type: Odbc error. Odbc operation attempted: SQLExecDirect. [S1000:1040: > on HSTMT] [MapR][Drill] (1040) Drill failed to execute the query: SELECT > CURRENT_DATE FROM interactionrecord limit 5 > [30024]Query execution error. Details:[ > Query stopped., Failure while trying to materialize incoming schema. Errors: > Error in expression at index -1. Error: Missing function implementation: > [extractDay(MAP-REQUIRED)]. Full expression: --UNKNOWN EXPRESSION--.. [ > 714416ec-e841-4443-8d70-bbb351547ddd on Window764bi-0:31010 ] > ] -- This message was sent by Atlassian JIRA (v6.3.4#6332)