[jira] [Commented] (HIVE-3417) mulit inserts when the from statement is a subquery,this is a bug

["Zhuoluo (Clark) Yang (JIRA)" <ji...@apache.org>]

    [ 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