hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Namit Jain (JIRA)" <j...@apache.org>
Subject [jira] Commented: (HIVE-777) CREATE TABLE with STRUCT type
Date Thu, 20 Aug 2009 16:06:14 GMT

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

Namit Jain commented on HIVE-777:
---------------------------------

Do we want to support this ? or go the other route of first creating a type:

for eg:


create type addata (adid int, location string);

CREATE TABLE abc (
  pageid INT,
  ads addata,
  userid INT
);


That way the same type can be used across multiple tables - you can select from one and insert
into another etc.
Type will be a first class citizen, it can be passed to udfs, can be described etc.

> 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
>         Attachments: 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.


Mime
View raw message