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.
