;> 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
