You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "James Turton (Jira)" <ji...@apache.org> on 2022/02/01 09:46:00 UTC
[jira] [Assigned] (DRILL-8119) MongoDB query regression: mem leak and data type error
[ https://issues.apache.org/jira/browse/DRILL-8119?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
James Turton reassigned DRILL-8119:
-----------------------------------
Assignee: Cong Luo (was: Vova Vysotskyi)
> MongoDB query regression: mem leak and data type error
> ------------------------------------------------------
>
> 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: Blocker
> 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)