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)