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/01/31 09:29:00 UTC
[jira] [Created] (DRILL-8119) MongoDB query regression: mem leak and data type error
James Turton created DRILL-8119:
-----------------------------------
Summary: 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: Vova Vysotskyi
Fix For: 1.20.0
Attachments: 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)