;> 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
>> T
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
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
ive, 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 re
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
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:
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
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 wrote:
> Hi Hive Gurus,
>
> When using the Hive extension of multiple inserts, can we add Where
> clauses for each Select statement
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, col3WHERE
col4='abc'INSERT OVERWRITE TABLE ...SELECT col1, col4, col2WHERE
col3='xyz'
The