It's also surprising and worrying that this query took 24 minutes to plan.
On 2022/03/09 21:21, Daniel Clark wrote:
I'm attempting to run this mongo query that ran successfully in Drill
1.19 with the 1.21.0-SNAPSHOT build.
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`
I'm getting this error message: UserRemoteException : SYSTEM ERROR:
RuntimeException: Schema change not currently supported for schemas
with complex types. I've attached both the log and the profile. Any
tips, or suggestions will be greatly appreciated.
