Dear Wiki user, You have subscribed to a wiki page or wiki category on "Hadoop Wiki" for change notification.
The following page has been changed by PrasadChakka: http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL ------------------------------------------------------------------------------ === Create Table === {{{ CREATE [EXTERNAL] TABLE [IF NOT EXISTS] table_name - [(col_name data_type [col_comment], col_name data_type [col_comment], ...)] + [(col_name data_type [col_comment], col_name data_type [COMMENT col_comment], ...)] [table_comment] - [PARTITIONED BY (col_name data_type [col_comment], col_name data_type [col_comment], ...)] + [PARTITIONED BY (col_name data_type [col_comment], col_name data_type [COMMENT col_comment], ...)] [CLUSTERED BY (col_name, col_name, ...) [SORTED BY (col_name, ...)] INTO num_buckets BUCKETS] [ROW FORMAT row_format] [STORED AS file_format] @@ -157, +157 @@ === Add/Repalce Columns === {{{ - ALTER TABLE table_name ADD|REPLACE COLUMNS (col_name data_type [col_comment], ...) + ALTER TABLE table_name ADD|REPLACE COLUMNS (col_name data_type [COMMENT col_comment], ...) }}} ADD COLUMNS lets you add new columns to the end of the existing columns but before the partition columns.
