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] ...

Reply via email to