No, exec.enable_union_type is set to false. On Tue, Feb 1, 2022 at 10:59 AM James Turton <[email protected]> wrote:
> Do you have exec.enable_union_type = true in your 1.19 environment? > > On 2022/02/01 17:30, Daniel Clark wrote: > > 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> > >>> > >>> > >> > > >
