Dear Wiki user, You have subscribed to a wiki page or wiki category on "Hadoop Wiki" for change notification.
The "Hive/LanguageManual/DDL" page has been changed by ArvindPrabhakar. http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL?action=diff&rev1=54&rev2=55 -------------------------------------------------- CREATE [EXTERNAL] TABLE [IF NOT EXISTS] table_name [(col_name data_type [COMMENT col_comment], ...)] [COMMENT table_comment] - [PARTITIONED BY (col_name data_type [col_comment], col_name data_type [COMMENT col_comment], ...)] + [PARTITIONED BY (col_name data_type [COMMENT col_comment], ...)] - [CLUSTERED BY (col_name, col_name, ...) [SORTED BY (col_name, ...)] INTO num_buckets BUCKETS] + [CLUSTERED BY (col_name, col_name, ...) [SORTED BY (col_name [ASC|DESC], ...)] INTO num_buckets BUCKETS] [ROW FORMAT row_format] [STORED AS file_format] [LOCATION hdfs_path] @@ -24, +24 @@ : primitive_type | array_type | map_type + | struct_type primitive_type : TINYINT @@ -36, +37 @@ | STRING array_type - : ARRAY < primitive_type > + : ARRAY < data_type > map_type - : MAP < primitive_type, primitive_type > + : MAP < primitive_type, data_type > + + struct_type + : STRUCT < col_name : data_type [COMMENT col_comment], ...> row_format : DELIMITED [FIELDS TERMINATED BY char] [COLLECTION ITEMS TERMINATED BY char]
