[
https://issues.apache.org/jira/browse/HIVE-3417?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13444756#comment-13444756
]
Zhuoluo (Clark) Yang commented on HIVE-3417:
--------------------------------------------
I think this bug was involved by HIVE-1538 for the optimizer prunes the wrong
filters. And I think we can modify the optimizer to make it work in good
manners.
> 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
