Check "Inserting data into Hive Tables from queries" section of http://wiki.apache.org/hadoop/Hive/LanguageManual/DML. Multiplem insert statements can share a single FROM clause.
Prasad ________________________________ From: Utkarsh Srivastava <[email protected]> Reply-To: <[email protected]> Date: Sat, 10 Oct 2009 22:41:08 -0700 To: <[email protected]> Subject: Multi-query support Hi, I haven't looked at the user manual in detail, so please bear with me if this is a silly question. Does HIVE support the kind of multi-query execution that Pig just added? By multi-query I mean the capability to compute two or more different result sets from the same input data set using only a single scan. Thanks Utkarsh
