[FLINK-13438] Support date type in Hive

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 1.10.0
• Component/s: Connectors / Hive
• Labels: pull-request-available
• Assignee: Rui Li
• Reporter: Caizhi Weng
• Created: 26/Jul/19 09:58
• Updated: 09/Dec/19 12:29
• Resolved: 09/Dec/19 12:29

Description

Similar to JDBC connectors, Hive connectors communicate with Flink framework using TableSchema, which contains DataType. As the time data read from and write to Hive connectors must be java.sql.* types and the default conversion class of our time data types are java.time.*, we have to fix Hive connector with DataTypes.DATE/TIME/TIMESTAMP support.

But currently when reading tables from Hive, the table schema is created using Hive's schema, so the time types in the created schema will be sql time type not local time type. If user specifies a local time type in the table schema when creating a table in Hive, he will get a different schema when reading it out. This is undesired.

Issue Links

• is related to: FLINK-15020 Support timestamp type in hive
• links to: GitHub Pull Request #9342
• links to: GitHub Pull Request #10494