hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Edward Capriolo (JIRA)" <j...@apache.org>
Subject [jira] Commented: (HIVE-31) Hive: support CREATE TABLE xxx SELECT yyy.* FROM yyy
Date Tue, 08 Sep 2009 20:07:57 GMT

    [ https://issues.apache.org/jira/browse/HIVE-31?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12752704#action_12752704
] 

Edward Capriolo commented on HIVE-31:
-------------------------------------

I don't know if anyone can solve this. I will try to replicate the situation it came up on.

{noformat}
create table tableA(  url string , time string, cookies string) partitioned by (year string,month
string)
{noformat}


{noformat}
create table tableb(  url string , time string, cookies string) partitioned by (year string,month
string)
row format compressed
{noformat}

INSERT INTO tableb (url,time,string)partition x,y 
from select * from tablea where year=x,month=y

See? I needed to list every column because the select * from tableA turns a partition into
a column. In my case both tables are partitioned in the same way. I am not sure if this Jira
can deal with this directly but I found this fact annoying.

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