You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Daniel Clark (Jira)" <ji...@apache.org> on 2022/06/01 17:00:00 UTC
[jira] [Comment Edited] (DRILL-8190) Mongo query: "Schema change not currently supported for schemas with complex types"
[ https://issues.apache.org/jira/browse/DRILL-8190?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17545027#comment-17545027 ]
Daniel Clark edited comment on DRILL-8190 at 6/1/22 4:59 PM:
-------------------------------------------------------------
I get the same error message with all of the pluginOptimizations set to false:
{noformat}
"pluginOptimizations": {
"supportsProjectPushdown": false,
"supportsFilterPushdown": false,
"supportsAggregatePushdown": false,
"supportsSortPushdown": false,
"supportsUnionPushdown": false,
"supportsLimitPushdown": false
}{noformat}
was (Author: JIRAUSER284507):
I get the same error message with all of the pluginOptimizations set to false:
{noformat}
"pluginOptimizations": {
"supportsProjectPushdown": false,
"supportsFilterPushdown": false,
"supportsAggregatePushdown": false,
"supportsSortPushdown": false,
"supportsUnionPushdown": false,
"supportsLimitPushdown": false
}{noformat}
> Mongo query: "Schema change not currently supported for schemas with complex types"
> -----------------------------------------------------------------------------------
>
> Key: DRILL-8190
> URL: https://issues.apache.org/jira/browse/DRILL-8190
> Project: Apache Drill
> Issue Type: Bug
> Components: Server
> Affects Versions: Future, 1.20.0
> Environment: RHEL 7: Linux 3.10.0-1160.59.1.el7.x86_64 #1 SMP Wed Feb 16 12:17:35 UTC 2022 x86_64 x86_64 x86_64 GNU/Linux
> Reporter: Daniel Clark
> Priority: Major
> Fix For: Future
>
> Attachments: customGrounds.gz, log_4.txt, profile_4.json
>
>
> 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 the log, profile, and a mongodb dump containing the relevant datasets.
--
This message was sent by Atlassian Jira
(v8.20.7#820007)