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

CTAS partition by columns[i] from csv fails

    XMLWordPrintableJSON

Details

    Description

      CTAS does not work when users try to partition by index on complex types.
      For example,
      create table `z` partition by columns[0] as select columns[0], columns[1], columns[2] from `t.csv`;

      Will result into
      Error: PARSE ERROR: Encountered "columns" at line 1, column 31.

      Query parser does not support it; We need to do it from here

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: