You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Daniel Clark (Jira)" <ji...@apache.org> on 2022/04/06 19:18:00 UTC
[jira] [Created] (DRILL-8190) 1.21.0-SNAPSHOT: Schema change not currently supported for schemas with complex types
Daniel Clark created DRILL-8190:
-----------------------------------
Summary: 1.21.0-SNAPSHOT: 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: 1.20.0, Future
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
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.1#820001)