Hi James, Yes, the store.mongo.bson.record.reader was set to false. I set it to true and re-ran the original query. It returned an error: UNSUPPORTED_OPERATION ERROR: Schema changes not supported in External Sort. Please enable Union type.
On Tue, Feb 1, 2022 at 9:19 AM James Turton <[email protected]> wrote: > Hi Daniel > > Please let us know if you have set the config option > store.mongo.bson.record.reader > = false and, if so, please set it to true. > > Thanks > James > > On 2022/01/31 17:45, Daniel Clark wrote: > > Here it is. Please see the attached file. > > On Mon, Jan 31, 2022 at 4:22 AM James Turton <[email protected]> wrote: > >> Please also attach the query profile if you can. >> >> Thanks >> James >> >> On 2022/01/31 08:09, luoc 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> >> >> >
