Daniel Dai created HIVE-21295:
---------------------------------
Summary: StorageHandler shall convert date to string using Hive
convention
Key: HIVE-21295
URL: https://issues.apache.org/jira/browse/HIVE-21295
Project: Hive
Issue Type: Improvement
Reporter: Daniel Dai
Assignee: Daniel Dai
Attachments: HIVE-21295.1.patch
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
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
