You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Syed Shameerur Rahman (Jira)" <ji...@apache.org> on 2022/11/25 13:00:00 UTC
[jira] [Created] (HIVE-26778) Pushdown Date data type to metastore via direct sql / JDO
Syed Shameerur Rahman created HIVE-26778:
--------------------------------------------
Summary: Pushdown Date data type to metastore via direct sql / JDO
Key: HIVE-26778
URL: https://issues.apache.org/jira/browse/HIVE-26778
Project: Hive
Issue Type: Bug
Reporter: Syed Shameerur Rahman
Assignee: Syed Shameerur Rahman
The original feature to push down date data type while doing partition pruning via direct sql / JDO was added as part of the jira : https://issues.apache.org/jira/browse/HIVE-5679
Since the behavior of Hive has changed with CBO, Now when CBO is turned on, The date data types are not pushed down to metastore due to CBO adding extra keyword 'DATE' with the original filter since the filter parser is not handled to parse this extra keyword it fails and hence the date data type is not pushed down to the metastore.
{code:java}
select * from test_table where date_col = '2022-01-01';
{code}
When CBO is turned on, The filter predicate generated is date_col=DATE'2022-01-01'
--
This message was sent by Atlassian Jira
(v8.20.10#820010)