[DRILL-8190] Mongo query: "Schema change not currently supported for schemas with complex types"

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.20.0
• Fix Version/s: 1.20.3
• Component/s: Server

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

• Assignee: Vova Vysotskyi
• Reporter: Daniel Clark
• Created: 06/Apr/22 19:17
• Updated: 07/Jan/23 13:52
• Resolved: 22/Sep/22 11:08

Description

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.

Issue Links

• is related to: DRILL-7935 Error: Hash join does not support schema changes in probe side.
• relates to: DRILL-8119 MongoDB ObjectID becomes MAP under store.mongo.bson.record.reader = false