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

CTAS Partition by column in deeper layer fails

    Details

      Description

      A simple data such as

      {
          "id": "0001",
          "type": "donut1",
          "batters":
          {
          	"batter": 1
          }
      }
      
      {
      	"id": "0002",
          "type": "donut2",
          "batters":
          {
          	"batter": 2
          }
      }
      

      I tried to partition by batters.batter:

      create table t1 (c1, c2) partition by (c2) as 
      select t.id, t.batters.batter from `t.json` t;
      

      But got this exception:
      Error: SYSTEM ERROR: IllegalArgumentException: partition col c2 could not be resolved in table's column lists!

        Attachments

          Activity

            People

            • Assignee:
              jni Jinfeng Ni
              Reporter:
              seanhychu Sean Hsuan-Yi Chu
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: