[HIVE-21295] StorageHandler shall convert date to string using Hive convention

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Target Version/s: 4.0.0
• Hadoop Flags: Reviewed
• Assignee: Daniel Dai
• Reporter: Daniel Dai
• Created: 20/Feb/19 03:39
• Updated: 27/Feb/24 22:23
• Resolved: 21/Feb/19 18:25

Description

If we have date datatype in mysql, string datatype defined in hive, JdbcStorageHandler will translate the date to string with the format yyyy-MM-dd HH:mm:ss. However, Hive convention is yyyy-MM-dd, we shall follow Hive convention. Eg:

mysql: CREATE TABLE test ("datekey" DATE);
hive: CREATE TABLE test (datekey string) STORED BY 'org.apache.hive.storage.jdbc.JdbcStorageHandler' TBLPROPERTIES (......"hive.sql.table" = "test"......);

Then in hive, do: select datekey from test;

We get: 1999-03-24 00:00:00

But should be: 1999-03-24