hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sha Liu <lius...@hotmail.com>
Subject RE: Multiple Insert with Where Clauses
Date Fri, 02 Aug 2013 17:55:11 GMT
It looks like this is a known issue (https://issues.apache.org/jira/browse/HIVE-4173).

From: spragues@gmail.com
Date: Thu, 1 Aug 2013 17:36:37 -0700
Subject: Re: Multiple Insert with Where Clauses
To: user@hive.apache.org

yeah.i agree.  that doesn't make any sense.  why in the world would  the "where clause" not
be supported with that syntax?  something's rotten in denmark there with your query. 

what version of hive are you seeing this on? 




On Tue, Jul 30, 2013 at 9:34 PM, Sha Liu <liusand@hotmail.com> wrote:





Doesn't INSERT INTO do what you said? I'm not sure I understand "inserting a few records into
a table".
Anyway here the problem seems different to me. For my cases these where clauses for multiple
inserts seem not effective, while Hive doesn't complain about that.


-Sha

Date: Tue, 30 Jul 2013 21:06:22 -0700
Subject: Re: Multiple Insert with Where Clauses
From: bruderman@radiumone.com


To: user@hive.apache.org

Hive doesn't support inserting a few records into a table. You will need to write a query
to union your select and then insert. IF you can partition, then you can insert a whole partition
at a time instead of the table.



Thanks,Brad

On Tue, Jul 30, 2013 at 9:04 PM, Sha Liu <liusand@hotmail.com> wrote:






Yes for the example you gave, it works. It even works when there is a single insert under
the from clause, but there there are multiple inserts, the where clauses seem no longer effective.




Date: Tue, 30 Jul 2013 20:29:19 -0700
Subject: Re: Multiple Insert with Where Clauses
From: bruderman@radiumone.com
To: user@hive.apache.org




Have you simply tried
INSERT OVERWRITE TABLE destination SELECT col1, col2, col3FROM sourceWHERE col4 = 'abc'

Thanks!



On Tue, Jul 30, 2013 at 8:25 PM, Sha Liu <liusand@hotmail.com> wrote:




Hi Hive Gurus,
When using the Hive extension of multiple inserts, can we add Where clauses for each Select
statement, like the following?
FROM ...



INSERT OVERWRITE TABLE ...    SELECT col1, col2, col3    WHERE col4='abc'INSERT OVERWRITE
TABLE ...    SELECT col1, col4, col2    WHERE col3='xyz'




The underlined parts didn't cause any errors, but they didn't seem to be effective either
(I'm using Hive 0.9). Note that the columns used in the Where clauses are not among the selected
ones, but I'm not sure if that is important. Is this kind of operations supported?




Thanks,Sha Liu 		 	   		  

 		 	   		  

 		 	   		  

 		 	   		  
Mime
View raw message