[HIVE-779] CREATE TYPE and use the TYPE in CREATE TABLE

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Assignee: Unassigned
• Reporter: Zheng Shao
• Created: 20/Aug/09 19:18
• Updated: 27/Aug/09 13:17

Description

From Namit:

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

Issue Links

• relates to: HIVE-777 CREATE TABLE with STRUCT type