Hi Daniel, What is the data type of the `_id` field? The default ObjectId, or String or key-value pair (Struct)?
> On Jan 31, 2022, at 11:12, Daniel Clark <[email protected]> wrote: > > > Hello, > > I'm running this mongo query on the 1.20.0-SNAPSHOT build. It runs without > error on the 1.19 release. > > 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` > > The error message returned is: > > 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. > > Fragment: 0:0 > > Please, refer to logs for more information. > > [Error Id: 21b3260d-9ebf-4156-a5fa-4748453b5465 on localhost:31010] > > I've tried searching the mailing list archives, as well as googling the > error. The stack trace mentions that memory was leaked by the query. Any > ideas? Full stack trace attached. > <stacktrace.txt>
