[jira] [Created] (DRILL-8119) MongoDB query regression: mem leak and data type error

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

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)