You are viewing a plain text version of this content. The canonical link for it is here.
Posted to common-commits@hadoop.apache.org by Apache Wiki <wi...@apache.org> on 2009/05/18 02:56:36 UTC
[Hadoop Wiki] Update of "Hive/LanguageManual/DDL" by PrasadChakka
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.