wow. good find Sha. i see its marked critical. Hello!! I mean, come on, hive is _silently_ ignoring the where clause??? I'll check this out on my version (v0.10) and confirm/deny its behavior there.
In the meantime i guess stay far far away from that form of insert statement. Who knows now what else is broken. Sad. On Fri, Aug 2, 2013 at 10:55 AM, Sha Liu <lius...@hotmail.com> wrote: > It looks like this is a known issue ( > https://issues.apache.org/jira/browse/HIVE-4173). > > ------------------------------ > From: sprag...@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 <lius...@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: bruder...@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 <lius...@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: bruder...@radiumone.com > To: user@hive.apache.org > > > Have you simply tried > > INSERT OVERWRITE TABLE destination > SELECT col1, col2, col3 > FROM source > WHERE col4 = 'abc' > > Thanks! > > > > On Tue, Jul 30, 2013 at 8:25 PM, Sha Liu <lius...@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 > > > > >