[jira] [Created] (HIVE-16609) col='__HIVE_DEFAULT_PARTITION__' condition in select statement may produce wrong result

["Daniel Dai (JIRA)" <ji...@apache.org>]

Daniel Dai created HIVE-16609:
---------------------------------

             Summary: col='__HIVE_DEFAULT_PARTITION__' condition in select statement may produce wrong result
                 Key: HIVE-16609
                 URL: https://issues.apache.org/jira/browse/HIVE-16609
             Project: Hive
          Issue Type: Bug
          Components: Metastore
            Reporter: Daniel Dai
            Assignee: Daniel Dai


A variation of drop_partitions_filter4.q produces wrong result:
{code}
create table ptestfilter (a string, b int) partitioned by (c string, d int);
INSERT OVERWRITE TABLE ptestfilter PARTITION (c,d) select 'Col1', 1, null, null;
INSERT OVERWRITE TABLE ptestfilter PARTITION (c,d) select 'Col2', 2, null, 2;
INSERT OVERWRITE TABLE ptestfilter PARTITION (c,d) select 'Col3', 3, 'Uganda', null;
select * from ptestfilter where c='__HIVE_DEFAULT_PARTITION__' or lower(c)='a';
{code}
The "select" statement does not produce the rows containing "__HIVE_DEFAULT_PARTITION__".

Note "select * from ptestfilter where c is null or lower(c)='a';" works fine.

In the query, c is a non-string partition column, we need another condition containing a udf so the condition is not recognized by PartFilterExprUtil.makeExpressionTree in ObjectStore. HIVE-11208/HIVE-15923 is addressing a similar issue in drop partition, however, select is not covered.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)