Hi again Daniel
Sorry everyone's so busy at the moment. The best way to turn this into
something a developer will work on is going to be to make it a small
reproducible example in Jira ticket. That should include some trivial
Mongo datasets that have the right data types to reveal the problem and
a query like the one below.
Regards
James
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.
