[
https://issues.apache.org/jira/browse/DRILL-679?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Venki Korukanti updated DRILL-679:
----------------------------------
Attachment: DRILL-679-1.patch
> 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)
