[jira] Updated: (HIVE-31) Hive: support CREATE TABLE xxx SELECT yyy.* FROM yyy

["Ning Zhang (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-31?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ning Zhang updated HIVE-31:
---------------------------

    Attachment: HIVE-31.patch

Attaching HIVE-31.patch. 

This patch implements the CTAS feature:

1) The select statement could be any query we support right now.
2) The created table and and source tables could have different SerDe and/or Storage formats.
3) the schema of the created table is detected from the select statement. User don't need to (and should not) specify that.

Limitations:
1) Created table does not support partition now. There is another work on automatic partitioning for insert statement. That will solve this problem.
2) Create table could not be an external table. 

> Hive: support CREATE TABLE xxx SELECT yyy.* FROM yyy
> ----------------------------------------------------
>
>                 Key: HIVE-31
>                 URL: https://issues.apache.org/jira/browse/HIVE-31
>             Project: Hadoop Hive
>          Issue Type: Bug
>          Components: Query Processor
>            Reporter: Zheng Shao
>            Assignee: Ning Zhang
>         Attachments: HIVE-31.patch
>
>
> We should allow users to create a table using query result, without specifying the column names and column types.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.