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 =
