[FLINK-18529] Query Hive table and filter by timestamp partition can fail

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.11.1
• Component/s: Connectors / Hive
• Labels: pull-request-available
• Assignee: Rui Li
• Reporter: Rui Li
• Created: 08/Jul/20 12:22
• Updated: 14/Jul/20 06:07
• Resolved: 14/Jul/20 06:07

Description

The following example

create table foo (x int) partitioned by (ts timestamp);
select x from foo where timestamp '2020-07-08 13:08:14' = ts;

fails with

CatalogException: HiveCatalog currently only supports timestamp of precision 9

Issue Links

• links to: GitHub Pull Request #12856