Hi James, Is a mongodb dump, along with the query sufficient, or should I also attach the profile and error log also?
On Thu, Mar 31, 2022 at 11:02 AM James Turton <[email protected]> wrote: > 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. > > >
