Hi James, Thanks for your help with this. I've created https://issues.apache.org/jira/browse/DRILL-8190.
On Wed, Apr 6, 2022 at 2:28 PM James Turton <[email protected]> wrote: > It's good to attach a profile and log too. The better the instructions and > observations that a ticket contains, the faster a developer can proceed to > a fix. > > On 6 April 2022 19:55:52 GMT+02:00, Daniel Clark <[email protected]> > wrote: > >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. > >> > >> > >> > > -- > Sent from my Android device with K-9 Mail. Please excuse my brevity.
