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 18:01:54 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

------------------------------------------------------------------------------
  
  == 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
  }}}
  

Mime
View raw message