[
https://issues.apache.org/jira/browse/HIVE-27683?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Zhihua Deng updated HIVE-27683:
-------------------------------
Description:
Steps to repro:
{noformat}
create database pt;
create table pt.alterdynamic_part_table(intcol string) partitioned by (partcol1
int, partcol2 int);
insert into table pt.alterdynamic_part_table partition(partcol1, partcol2)
select '2', 2, NULL;
select intcol from pt.alterdynamic_part_table where (partcol1=2 and partcol2=1)
or (partcol1=2 and partcol2='__HIVE_DEFAULT_PARTITION__');
set hive.cbo.enable=false;
select intcol from pt.alterdynamic_part_table where
partcol2='__HIVE_DEFAULT_PARTITION__';{noformat}
The last two queries should return one line row instead of empty result.
was:
Steps to repro:
{noformat}
create database pt;
create table pt.alterdynamic_part_table(intcol string) partitioned by (partcol1
string, partcol2 string);
insert into table pt.alterdynamic_part_table partition(partcol1, partcol2)
select 2, '2', NULL;
select intcol from pt.alterdynamic_part_table where
partcol2='__HIVE_DEFAULT_PARTITION__';{noformat}
The last query should return 2 instead of empty result.
> Incorrect result when filtering the table with default partition
> ----------------------------------------------------------------
>
> Key: HIVE-27683
> URL: https://issues.apache.org/jira/browse/HIVE-27683
> Project: Hive
> Issue Type: Bug
> Reporter: Zhihua Deng
> Priority: Major
>
> Steps to repro:
> {noformat}
> create database pt;
> create table pt.alterdynamic_part_table(intcol string) partitioned by
> (partcol1 int, partcol2 int);
> insert into table pt.alterdynamic_part_table partition(partcol1, partcol2)
> select '2', 2, NULL;
> select intcol from pt.alterdynamic_part_table where (partcol1=2 and
> partcol2=1) or (partcol1=2 and partcol2='__HIVE_DEFAULT_PARTITION__');
> set hive.cbo.enable=false;
> select intcol from pt.alterdynamic_part_table where
> partcol2='__HIVE_DEFAULT_PARTITION__';{noformat}
> The last two queries should return one line row instead of empty result.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
