[ https://issues.apache.org/jira/browse/HIVE-20013?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16527137#comment-16527137 ]
Hive QA commented on HIVE-20013: -------------------------------- Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12929456/HIVE-20013.patch {color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified. {color:red}ERROR:{color} -1 due to 2 failed/errored test(s), 14628 tests executed *Failed tests:* {noformat} org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[fold_eq_with_case_when] (batchId=85) org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[kryo] (batchId=165) {noformat} Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/12233/testReport Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/12233/console Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-12233/ 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: 2 tests failed {noformat} This message is automatically generated. ATTACHMENT ID: 12929456 - PreCommit-HIVE-Build > Add an Implicit cast to date type for to_date function > ------------------------------------------------------ > > Key: HIVE-20013 > URL: https://issues.apache.org/jira/browse/HIVE-20013 > Project: Hive > Issue Type: Bug > Reporter: Nishant Bangarwa > Assignee: Nishant Bangarwa > Priority: Major > Attachments: HIVE-20013.patch > > > Issue - > SELECT TO_DATE(date1), TO_DATE(datetime1) FROM druid_table_n1; > Running this query on Druid returns null values when date1 and datetime1 are > of type String. > {code} > INFO : Executing > command(queryId=hive_20180627144822_d4395567-e3cb-4b20-b53b-4e5eba2d7dac): > EXPLAIN SELECT TO_DATE(datetime0) ,TO_DATE(date0) FROM calcs > INFO : Starting task [Stage-1:EXPLAIN] in serial mode > INFO : Completed executing > command(queryId=hive_20180627144822_d4395567-e3cb-4b20-b53b-4e5eba2d7dac); > Time taken: 0.003 seconds > INFO : OK > +----------------------------------------------------+ > | Explain | > +----------------------------------------------------+ > | Plan optimized by CBO. | > | | > | Stage-0 | > | Fetch Operator | > | limit:-1 | > | Select Operator [SEL_1] | > | Output:["_col0","_col1"] | > | TableScan [TS_0] | > | > Output:["vc","vc0"],properties:{"druid.fieldNames":"vc,vc0","druid.fieldTypes":"date,date","druid.query.json":"{\"queryType\":\"scan\",\"dataSource\":\"druid_tableau.calcs\",\"intervals\":[\"1900-01-01T00:00:00.000Z/3000-01-01T00:00:00.000Z\"],\"virtualColumns\":[{\"type\":\"expression\",\"name\":\"vc\",\"expression\":\"timestamp_floor(\\\"datetime0\\\",'P1D','','UTC')\",\"outputType\":\"LONG\"},{\"type\":\"expression\",\"name\":\"vc0\",\"expression\":\"timestamp_floor(\\\"date0\\\",'P1D','','UTC')\",\"outputType\":\"LONG\"}],\"columns\":[\"vc\",\"vc0\"],\"resultFormat\":\"compactedList\"}","druid.query.type":"scan"} > | > | | > +----------------------------------------------------+ > 10 rows selected (0.606 seconds) > {code} -- This message was sent by Atlassian JIRA (v7.6.3#76005)