hadoop-common-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Hadoop Wiki] Update of "Hive/LanguageManual/DDL" by PrasadChakka
Date Mon, 18 May 2009 00:56:36 GMT
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.

Mime
View raw message