[
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)
