[
https://issues.apache.org/jira/browse/HIVE-16609?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16005421#comment-16005421
]
Thejas M Nair commented on HIVE-16609:
--------------------------------------
[~sershe]
It looks like we have support for this query type in some scenarios, but it
produces wrong result in some others.
We show this in partition names, and because of the support for this query,
users are can be using it.
We need to have consistent behavior here, not what could be seen as incorrect
result. The current state is not right.
We should either fix this for broken case or make changes to stop supporting
this type of predicate completely (which would be backward incompatible).
Thoughts ?
> 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
> Attachments: HIVE-16609.1.patch, HIVE-16609.2.patch
>
>
> A variation of alter_partition_change_col.q produces wrong result:
> {code}
> SET hive.exec.dynamic.partition.mode = nonstrict;
> create table alter_partition_change_col0 (c1 string, c2 string);
> load data local inpath 'dec.txt' overwrite into table
> alter_partition_change_col0;
> create table alter_partition_change_col1 (c1 string, c2 string) partitioned
> by (p1 string comment 'Column p1', p2 string comment 'Column p2');
> insert overwrite table alter_partition_change_col1 partition (p1, p2)
> select c1, c2, 'abc', '123' from alter_partition_change_col0
> union all
> select c1, c2, cast(null as string), '123' from alter_partition_change_col0;
> select * from alter_partition_change_col1 where
> p1='__HIVE_DEFAULT_PARTITION__' or lower(p1)='a';
> {code}
> The "select" statement does not produce the rows containing
> "__HIVE_DEFAULT_PARTITION__".
> We need another condition containing a udf so the condition is not recognized
> by PartFilterExprUtil.makeExpressionTree in ObjectStore. Looks like
> HIVE-11208 breaks it.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
