caofangkun created HIVE-3417:
--------------------------------
Summary: mulit inserts when the from statement is a subquery,this
is a bug
Key: HIVE-3417
URL: https://issues.apache.org/jira/browse/HIVE-3417
Project: Hive
Issue Type: Bug
Components: Query Processor, SQL
Affects Versions: 0.8.1
Environment: Linux 3.0.0-14-generic #23-Ubuntu SMP Mon Nov 21 20:34:47
UTC 2011 i686 i686 i386 GNU/Linux
java version "1.6.0_25"
hadoop-0.20.2-cdh3u0
hive-0.8.1
Reporter: caofangkun
vi mulit-insert.sql
create table src (key string, value string);
load data local inpath './in1.txt' overwrite into table src;
drop table if exists test1;
drop table if exists test2;
create table test1 (key string, value string) partitioned by (dt string);
create table test2 (key string, value string) partitioned by (dt string);
select * from src;
from (select * from src
where key is not null
) --there is a bug here
insert overwrite table test1 PARTITION (dt='1') select key ,value where key='48'
insert overwrite table test2 PARTITION (dt='2') select key, value where
key='100';
select * from test1;
select * from test2;
test1 and test2 shoud both have a single line of context.But it's not .
Has a Solution:
when set hive.ppd.remove.duplicatefilters=false;
this's not such bug.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
