You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Daniel Clark <cl...@gmail.com> on 2022/03/09 19:21:45 UTC
1.21.0-SNAPSHOT: Schema change not currently supported for schemas with complex types
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.
Re: 1.21.0-SNAPSHOT: Schema change not currently supported for schemas with complex types
Posted by Daniel Clark <cl...@gmail.com>.
Hi James,
I just disabled all the pushdowns and tried the query again. Same error in
less time. Logs attached.
Re: 1.21.0-SNAPSHOT: Schema change not currently supported for schemas with complex types
Posted by James Turton <dz...@apache.org>.
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.
Re: 1.21.0-SNAPSHOT: Schema change not currently supported for schemas with complex types
Posted by James Turton <dz...@apache.org>.
Hi Daniel
Please refresh my memory, have we tried to run this query with all push
downs disabled?
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.
Re: 1.21.0-SNAPSHOT: Schema change not currently supported for schemas with complex types
Posted by Daniel Clark <cl...@gmail.com>.
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 <ja...@somecomputer.xyz.invalid>
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 <cl...@gmail.com>
> 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 <ja...@somecomputer.xyz>
> >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.
Re: 1.21.0-SNAPSHOT: Schema change not currently supported for schemas with complex types
Posted by James Turton <ja...@somecomputer.xyz.INVALID>.
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 <cl...@gmail.com> 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 <ja...@somecomputer.xyz>
>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.
Re: 1.21.0-SNAPSHOT: Schema change not currently supported for schemas with complex types
Posted by Daniel Clark <cl...@gmail.com>.
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 <ja...@somecomputer.xyz>
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.
>
>
>
Re: 1.21.0-SNAPSHOT: Schema change not currently supported for schemas with complex types
Posted by James Turton <ja...@somecomputer.xyz.INVALID>.
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.