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 ------------------------------------------------------------------------------ == Load data == {{{ - LOAD DATA [LOCAL] INPATH '/path/to/file' [OVERWRITE] INTO TABLE table_name + LOAD DATA [LOCAL] INPATH '/path/to/file' [OVERWRITE] INTO TABLE table_name [PARTITION (partition_col = partition_col_value, partition_col = partiton_col_value, ...)] + }}} == Query Statement == @@ -156, +157 @@ destination : LOCAL DIRECTORY '/local/path' | DIRECTORY '/hdfs/path' - | TABLE table_name + | TABLE table_name [PARTITION (partition_col = partition_col_value, partition_col = partiton_col_value, ...)] }}} Will support APPEND and PARTITION in the future. @@ -182, +183 @@ = Hive Utility Statements = == Describe table == {{{ - DESCRIBE [EXTENDED] table_name + DESCRIBE [EXTENDED] table_name [PARTITION (partition_col = partition_col_value, partition_col = partiton_col_value, ...)] }}} == Show tables/partitions == {{{ @@ -196, +197 @@ {{{ -- To show all properties SET [EXTENDED] + + -- Set property value SET property_name=property_value }}}
