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/LanguageManual/DML" by ZhengShao
Date Thu, 04 Jun 2009 00:57:21 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 ZhengShao:
http://wiki.apache.org/hadoop/Hive/LanguageManual/DML

------------------------------------------------------------------------------
  
  ===== Syntax =====
  {{{
+ Standard syntax:
+ INSERT OVERWRITE TABLE tablename1 [PARTITION (partcol1=val1, partcol2=val2 ...)] FROM from_statement
select_statement1
+ 
+ Hive extension (multiple inserts):
  FROM from_statement
  INSERT OVERWRITE TABLE tablename1 [PARTITION (partcol1=val1, partcol2=val2 ...)] select_statement1
  [INSERT OVERWRITE TABLE tablename2 [PARTITION ...] select_statement2] ...
@@ -63, +67 @@

  
  ===== Syntax =====
  {{{
+ Standard syntax:
+ INSERT OVERWRITE [LOCAL] DIRECTORY directory1 FROM from_statement select_statement1
+ 
+ Hive extension (multiple inserts):
  FROM from_statement
  INSERT OVERWRITE [LOCAL] DIRECTORY directory1 select_statement1
  [INSERT OVERWRITE [LOCAL] DIRECTORY directory2 select_statement2] ...

Mime
View raw message