Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-8190

Mongo query: "Schema change not currently supported for schemas with complex types"

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.20.0
    • 1.20.3
    • Server
    • None
    • 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

    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.

      Attachments

        1. customGrounds.gz
          18 kB
          Daniel Clark
        2. log_4.txt
          34 kB
          Daniel Clark
        3. profile_4.json
          21 kB
          Daniel Clark

        Issue Links

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            volodymyr Vova Vysotskyi
            clarkddc Daniel Clark
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment