You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Venki Korukanti (JIRA)" <ji...@apache.org> on 2014/05/10 23:58:50 UTC
[jira] [Updated] (DRILL-679) Support create table as query (CTAS)
[ 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)