[DRILL-679] Support create table as query (CTAS)

• Type: Task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Assignee: Venki Korukanti
• Reporter: Venki Korukanti
• Created: 09/May/14 17:15
• Updated: 14/Sep/15 23:19
• Resolved: 12/May/14 09:13

Description

Support queries like:

USE dfs.tmp;
CREATE TABLE nameposTable AS SELECT first_name, last_name, position_id FROM cp.`employee.json`;

Above query will create "nameposTable" directory under the dfs.tmp workspace and it has the data files created from the SELECT query.

As part of this there is a change in format of workspaces field of storage-plugins.json:

New workspaces field looks like:

      workspaces: {
        "home" : {
          location: "/",
          writable: false
        },
        "tmp" : {
          location: "/tmp/drilltest",
          writable: true,
          storageformat: "csv"
        }
      },

"storageformat" tells what is the default format of new tables created in this workspace. "writable" tells whether new tables/views are allowed in this workspace.

Issue Links

• is depended upon by: DRILL-675 Views created in dfs (with no workspace subschema) schema are not be found when queried
• links to: Review Board Link