Hi, The _id field is the default ObjectId type. I also have store.mongo.all_text_mode set to true.
On Mon, Jan 31, 2022 at 1:09 AM luoc <[email protected]> wrote: > > 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> >
