[ https://issues.apache.org/jira/browse/HIVE-21295?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16772631#comment-16772631 ]
Hive QA commented on HIVE-21295: -------------------------------- Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12959362/HIVE-21295.1.patch {color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 7 failed/errored test(s), 15797 tests executed *Failed tests:* {noformat} org.apache.hive.jdbc.TestTriggersTezSessionPoolManager.testTriggerCustomCreatedDynamicPartitions (batchId=264) org.apache.hive.jdbc.TestTriggersTezSessionPoolManager.testTriggerCustomCreatedDynamicPartitionsUnionAll (batchId=264) org.apache.hive.jdbc.TestTriggersTezSessionPoolManager.testTriggerCustomNonExistent (batchId=264) org.apache.hive.jdbc.TestTriggersTezSessionPoolManager.testTriggerHighBytesRead (batchId=264) org.apache.hive.jdbc.TestTriggersTezSessionPoolManager.testTriggerHighShuffleBytes (batchId=264) org.apache.hive.jdbc.TestTriggersTezSessionPoolManager.testTriggerSlowQueryElapsedTime (batchId=264) org.apache.hive.jdbc.TestTriggersTezSessionPoolManager.testTriggerSlowQueryExecutionTime (batchId=264) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/16155/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/16155/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-16155/ Messages: {noformat} Executing org.apache.hive.ptest.execution.TestCheckPhase Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.YetusPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 7 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12959362 - PreCommit-HIVE-Build > 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 > Priority: Major > 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)