[
https://issues.apache.org/jira/browse/HIVE-777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12747756#action_12747756
]
Zheng Shao commented on HIVE-777:
---------------------------------
Looks good. Will commit if tests pass. I changed the test case a little bit to
have non-null "b" value.
{code}
drop table abc;
create table abc(strct struct<a:int, b:string, c:string>)
row format delimited
fields terminated by '\t'
collection items terminated by '\001';
load data local inpath '../data/files/kv1.txt'
overwrite into table abc;
SELECT strct, strct.a, strct.b FROM abc LIMIT 10;
drop table abc;
{code}
> CREATE TABLE with STRUCT type
> -----------------------------
>
> Key: HIVE-777
> URL: https://issues.apache.org/jira/browse/HIVE-777
> Project: Hadoop Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Zheng Shao
> Assignee: He Yongqiang
> Attachments: hive-777-2009-8-21-2.patch, hive-777-2009-8-21.patch,
> hive-777-2009-8-29.patch
>
>
> Currently we only support map/array in type definition.
> We should support STRUCT as well.
> {code}
> CREATE TABLE abc (
> pageid INT,
> ads STRUCT<adid:INT,location:STRING>,
> userid INT
> );
> {code}
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
