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

["Venki Korukanti (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-679?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13994948#comment-13994948 ] 

Venki Korukanti commented on DRILL-679:
---------------------------------------

Fixed in e19606593f3173d8f82ca3074186e9ca7a960ce2 & 5b7f351e3bbc26d5e9a686cd5b0c636bb0b94b2e

> 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)