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 ArvindPrabhakar
Date Wed, 17 Mar 2010 02:16:20 GMT
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]

Mime
View raw message