Zhihua Deng created HIVE-27683:
----------------------------------

             Summary: 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


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.



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to