You are viewing a plain text version of this content. The canonical link for it is here.

Posted to common-commits@hadoop.apache.org by Apache Wiki <wi...@apache.org> on 2008/12/11 00:13:04 UTC

[Hadoop Wiki] Trivial Update of "Hive/HiveQL" by RaghothamMurthy

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 [PARTITION (partition_col = partition_col_value, partition_col = partiton_col_value, ...)]
+ LOAD DATA [LOCAL] INPATH '/path/to/file' [OVERWRITE] INTO TABLE table_name [partition_spec]
  
  }}}
  == Query Statement ==
@@ -93, +93 @@

  select_list: expression, expression, ...
  
  table_source
-   : table_name [PARTITION (partition_col = partition_col_value, partition_col = partiton_col_value, ...)] [table_sample] [alias]
+   : table_name [table_sample] [alias]
    | ( select_statement ) alias
  }}}