hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ning Zhang (JIRA)" <j...@apache.org>
Subject [jira] Updated: (HIVE-31) Hive: support CREATE TABLE xxx SELECT yyy.* FROM yyy
Date Tue, 29 Sep 2009 18:42:18 GMT

     [ 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.


Mime
View raw message