You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "caofangkun (JIRA)" <ji...@apache.org> on 2012/08/30 03:24:07 UTC
[jira] [Created] (HIVE-3417) mulit inserts when the from statement
is a subquery,this is a bug
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
[jira] [Commented] (HIVE-3417) mulit inserts when the from
statement is a subquery,this is a bug
Posted by "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