Venki Korukanti created DRILL-679:
-------------------------------------
Summary: Support create table as query (CTAS)
Key: DRILL-679
URL: https://issues.apache.org/jira/browse/DRILL-679
Project: Apache Drill
Issue Type: Task
Reporter: Venki Korukanti
Assignee: Venki Korukanti
Attachments: DRILL-679-1.patch
Support queries like:
{code}
USE dfs.tmp;
CREATE TABLE nameposTable AS SELECT first_name, last_name, position_id FROM
cp.`employee.json`;
{code}
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:
{code}
workspaces: {
"home" : {
location: "/",
writable: false
},
"tmp" : {
location: "/tmp/drilltest",
writable: true,
storageformat: "csv"
}
},
{code}
"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.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
