Taraka Rama Rao Lethavadla created HIVE-26827:
-------------------------------------------------
Summary: Add configs to workaround predicate issue with Parquet on
TIMESTAMP data type
Key: HIVE-26827
URL: https://issues.apache.org/jira/browse/HIVE-26827
Project: Hive
Issue Type: Improvement
Reporter: Taraka Rama Rao Lethavadla
Assignee: Taraka Rama Rao Lethavadla
The below query fails with error
{noformat}
ect * from db.parquet_table_with_timestamp where created_date_utc between
'2022-11-05 00:01:01' and '2022-11-08 23:59:59'{noformat}
We can workaround the issue below
{noformat}
2022-11-10 06:43:36,751 [ERROR] [TezChild]
|read.ParquetFilterPredicateConverter|: fail to build predicate filter leaf
with errors org.apache.hadoop.hive.ql.metadata.HiveException: Conversion to
Parquet FilterPredicate not supported for TIMESTAMP{noformat}
by setting configs at session level
# set hive.optimize.index.filter=false;
# set hive.optimize.ppd=false;
As part of this Jira proposing to add these config info to the above message so
that who ever encounter this problem can try the workaround
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
