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

Explain CTAS statement support

    XMLWordPrintableJSON

Details

    Description

      Currently, only SELECT query could be put in EXPLAIN statement, and Drill does not support EXPLAIN CTAS statement.

      One option would be to EXPLAIN the select_query in CTAS directly. However, with the partition by clause added in CTAS, it's not possible to do so any more, since there is no corresponding "PARTITION BY" clause in the SELECT query.

      Therefore, it is important to extend EXPLAIN to accept CTAS directly.

      Attachments

        Activity

          People

            Unassigned Unassigned
            jni Jinfeng Ni
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: