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/HiveQL" by RaghothamMurthy
Date Mon, 06 Oct 2008 03:02:38 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 RaghothamMurthy:
http://wiki.apache.org/hadoop/Hive/HiveQL

New page:
= Data Definition Statements =

== Create Table ==

{{{
CREATE TABLE tablename 
  (col_name data_type [col_comment], col_name data_type [col_comment], ...)
  [PARTITIONED BY (col_name data_type [col_comment], col_name data_type [col_comment], ...)]
  [CLUSTERED BY (col_name, col_name, ...) [SORTED BY (col_name, ...)] INTO num_buckets BUCKETS]
  [row_format]
  [file_format]

data_type
  :  primitive_type
  | array_type
  | map_type

primitive_type
  : TINYINT
  | INT
  | BIGINT
  | BOOLEAN
  | FLOAT
  | DOUBLE
  | DATE
  | DATETIME
  | TIMESTAMP
  | STRING

array_type
  : ARRAY < primitive_type > 

map_type
  : MAP < primitive_type, primitive_type >

row_format
  : ROW FORMAT DELIMITED [FIELDS TERMINATED BY char] [COLLECTION ITEMS TERMINATED BY char]
[MAP KEYS TERMINATED BY char] [LINES TERMINATED BY char]
  | ROW FORMAT SERIALIZER serde_name [WITH PROPERTIES property_name=property_value, property_name=property_value,
...]
}}}


= Data Manipulation Statements =

= Hive Utility Statements =

Mime
View raw message