You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Zheng Shao (JIRA)" <ji...@apache.org> on 2009/08/20 21:19:14 UTC

[jira] Created: (HIVE-779) CREATE TYPE and use the TYPE in CREATE TABLE

CREATE TYPE and use the TYPE in CREATE TABLE
--------------------------------------------

                 Key: HIVE-779
                 URL: https://issues.apache.org/jira/browse/HIVE-779
             Project: Hadoop Hive
          Issue Type: New Feature
            Reporter: Zheng Shao


>From Namit:

{code}
create type addata (adid int, location string);

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

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


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


[jira] Updated: (HIVE-779) CREATE TYPE and use the TYPE in CREATE TABLE

Posted by "He Yongqiang (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-779?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

He Yongqiang updated HIVE-779:
------------------------------

    Attachment: hive-779-2009-08-27.patch

patch a new file against truck, and refine the testcase according to the one added in hive-777.

> CREATE TYPE and use the TYPE in CREATE TABLE
> --------------------------------------------
>
>                 Key: HIVE-779
>                 URL: https://issues.apache.org/jira/browse/HIVE-779
>             Project: Hadoop Hive
>          Issue Type: New Feature
>            Reporter: Zheng Shao
>         Attachments: hive-779-2009-08-21.patch, hive-779-2009-08-27.patch
>
>
> From Namit:
> {code}
> create type addata (adid int, location string);
> CREATE TABLE abc (
> pageid INT,
> ads addata,
> userid INT
> );
> {code}
> 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

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


[jira] Updated: (HIVE-779) CREATE TYPE and use the TYPE in CREATE TABLE

Posted by "He Yongqiang (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/HIVE-779?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

He Yongqiang updated HIVE-779:
------------------------------

    Attachment: hive-779-2009-08-21.patch

> CREATE TYPE and use the TYPE in CREATE TABLE
> --------------------------------------------
>
>                 Key: HIVE-779
>                 URL: https://issues.apache.org/jira/browse/HIVE-779
>             Project: Hadoop Hive
>          Issue Type: New Feature
>            Reporter: Zheng Shao
>         Attachments: hive-779-2009-08-21.patch
>
>
> From Namit:
> {code}
> create type addata (adid int, location string);
> CREATE TABLE abc (
> pageid INT,
> ads addata,
> userid INT
> );
> {code}
> 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

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