[jira] [Commented] (DRILL-8119) MongoDB ObjectID becomes MAP under store.mongo.bson.record.reader = false

["James Turton (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-8119?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17485288#comment-17485288 ] 

James Turton commented on DRILL-8119:
-------------------------------------

This is not a regression in 1.20.0-SNAPSHOT as was initially thought.  ObjectIDs are returned as MAPs under the config option store.mongo.bson.record.reader = false (i.e. a JSON reader is used).  The simple workaround is to set store.mongo.bson.record.reader = true.

> MongoDB ObjectID becomes MAP under store.mongo.bson.record.reader = false
> -------------------------------------------------------------------------
>
>                 Key: DRILL-8119
>                 URL: https://issues.apache.org/jira/browse/DRILL-8119
>             Project: Apache Drill
>          Issue Type: Bug
>    Affects Versions: 1.20.0
>            Reporter: James Turton
>            Assignee: Cong Luo
>            Priority: Minor
>             Fix For: 1.20.0
>
>         Attachments: profile.json, stacktrace.txt
>
>
> The following query works in Drill 1.19 but not in 1.20.
> {code:java}
> SELECT `Elements_Efforts`.`EffortTypeName` AS `EffortTypeName`,
>   `Elements`.`ElementSubTypeName` AS `ElementSubTypeName`,
>   `Elements`.`ElementTypeName` AS `ElementTypeName`,
>   `Elements`.`PlanID` AS `PlanID`
> FROM `mongo.grounds`.`Elements` `Elements`
>   INNER JOIN `mongo.grounds`.`Elements_Efforts` `Elements_Efforts` ON (`Elements`.`_id` = `Elements_Efforts`.`_id`)
> WHERE (`Elements`.`PlanID` = '1623263140')
> GROUP BY `Elements_Efforts`.`EffortTypeName`,
>   `Elements`.`ElementSubTypeName`,
>   `Elements`.`ElementTypeName`,
>   `Elements`.`PlanID` {code}
> Two issues have been reported, one is a memory leak
> {code:java}
> org.apache.drill.common.exceptions.UserException: DATA_READ ERROR: Memory was leaked by query. Memory leaked: (1945600) {code}
> and the other is a data type error
> {code:java}
> org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: UnsupportedOperationException: Map, Array, Union or repeated scalar type should not be used in group by, order by or in a comparison operator. Drill does not support compare between MAP:REQUIRED and MAP:REQUIRED. {code}
> .  A stack trace is attached and a query profile will be attached when (and if) I receive it.
> [^stacktrace.txt]



--
This message was sent by Atlassian Jira
(v8.20.1#820001)