[
https://issues.apache.org/jira/browse/HIVE-21576?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16848872#comment-16848872
]
Hive QA commented on HIVE-21576:
--------------------------------
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12969852/HIVE-21576.03.patch
{color:green}SUCCESS:{color} +1 due to 9 test(s) being added or modified.
{color:red}ERROR:{color} -1 due to 92 failed/errored test(s), 16082 tests
executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.accumulo.mr.TestHiveAccumuloTypes.testUtf8Types
(batchId=201)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[autogen_colalias]
(batchId=30)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[date_udf] (batchId=34)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[parquet_ppd_date]
(batchId=18)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[timestamp_formats]
(batchId=25)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[timestamp_udf]
(batchId=86)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[timestamptz_4]
(batchId=67)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[udf9] (batchId=88)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[udf_date_format]
(batchId=63)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[udf_from_utc_timestamp]
(batchId=92)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[udf_last_day]
(batchId=42)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[udf_mask] (batchId=82)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[udf_mask_first_n]
(batchId=85)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[udf_mask_last_n]
(batchId=41)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[udf_mask_show_first_n]
(batchId=5)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[udf_mask_show_last_n]
(batchId=62)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[udf_months_between]
(batchId=58)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[udf_next_day] (batchId=2)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[udf_to_string]
(batchId=82)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[udf_to_utc_timestamp]
(batchId=24)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[udf_trunc] (batchId=4)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[udf_weekofyear]
(batchId=7)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[update_all_types]
(batchId=19)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vector_udf_trunc]
(batchId=8)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vectorized_date_funcs]
(batchId=84)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[vectorized_timestamp_funcs]
(batchId=33)
org.apache.hadoop.hive.cli.TestMiniDruidCliDriver.testCliDriver[druidmini_expressions]
(batchId=197)
org.apache.hadoop.hive.cli.TestMiniDruidCliDriver.testCliDriver[druidmini_mv]
(batchId=197)
org.apache.hadoop.hive.cli.TestMiniHiveKafkaCliDriver.testCliDriver[kafka_storage_handler]
(batchId=286)
org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[orc_ppd_basic]
(batchId=154)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[approx_distinct]
(batchId=170)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[current_date_timestamp]
(batchId=173)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[default_constraint]
(batchId=170)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[dst]
(batchId=166)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[orc_ppd_date]
(batchId=172)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[results_cache_2]
(batchId=183)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[schema_evol_orc_nonvec_part_all_primitive]
(batchId=185)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[schema_evol_orc_nonvec_part_all_primitive_llap_io]
(batchId=184)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[schema_evol_orc_vec_part_all_primitive]
(batchId=182)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[schema_evol_orc_vec_part_all_primitive_llap_io]
(batchId=166)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[schema_evol_text_nonvec_part_all_primitive]
(batchId=174)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[schema_evol_text_nonvec_part_all_primitive_llap_io]
(batchId=185)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[schema_evol_text_vec_part_all_primitive]
(batchId=177)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[schema_evol_text_vec_part_all_primitive_llap_io]
(batchId=182)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[schema_evol_text_vecrow_part_all_primitive]
(batchId=177)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[timestamp_4]
(batchId=169)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[timestamptz_5]
(batchId=167)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[update_all_types]
(batchId=164)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vector_partitioned_date_time]
(batchId=182)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vectorized_date_funcs]
(batchId=181)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vectorized_timestamp_funcs]
(batchId=168)
org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[date_literal2]
(batchId=100)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[date_udf]
(batchId=126)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[timestamp_udf]
(batchId=148)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[vectorized_timestamp_funcs]
(batchId=126)
org.apache.hadoop.hive.ql.TestTxnCommands.testQuotedIdentifier (batchId=339)
org.apache.hadoop.hive.ql.TestTxnCommandsWithSplitUpdateAndVectorization.testQuotedIdentifier
(batchId=321)
org.apache.hadoop.hive.ql.exec.vector.expressions.TestVectorTimestampExtract.testString
(batchId=325)
org.apache.hadoop.hive.ql.exec.vector.expressions.TestVectorTypeCasts.testCastDateToString
(batchId=324)
org.apache.hadoop.hive.ql.exec.vector.expressions.TestVectorTypeCastsWithFormat.testCastStringToDateWithFormat
(batchId=326)
org.apache.hadoop.hive.ql.exec.vector.expressions.TestVectorTypeCastsWithFormat.testCastStringToTimestampWithFormat
(batchId=326)
org.apache.hadoop.hive.ql.io.orc.TestVectorizedORCReader.createFile
(batchId=313)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFAddMonths.testWrongDateStr
(batchId=303)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFAddMonths.testWrongTsStr
(batchId=303)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFCastWithFormat.testStringToTimestampWithFormat
(batchId=305)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFDate.testTimestampToDate
(batchId=303)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFDateAdd.testStringToDate
(batchId=300)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFDateAdd.testTimestampToDate
(batchId=300)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFDateDiff.testTimestampToDate
(batchId=300)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFDateFormat.testDateFormatStr
(batchId=300)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFDateFormat.testWrongDateStr
(batchId=300)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFDateSub.testStringToDate
(batchId=302)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFDateSub.testTimestampToDate
(batchId=302)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFFromUtcTimestamp.testFromUtcTimestamp
(batchId=303)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFFromUtcTimestamp.testToUtcTimestamp
(batchId=303)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFLastDay.testLastDay
(batchId=302)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFLastDay.testWrongDateStr
(batchId=302)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFLastDay.testWrongTsStr
(batchId=302)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFMonthsBetween.testMonthsBetweenForDate
(batchId=304)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFMonthsBetween.testMonthsBetweenForString
(batchId=304)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFNextDay.testNextDay
(batchId=303)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFNextDay.testNotValidValues
(batchId=303)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFQuarter.testQuarterStr
(batchId=304)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFQuarter.testWrongDateStr
(batchId=304)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFTrunc.testStringToDateWithMonthFormat
(batchId=299)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFTrunc.testStringToDateWithQuarterFormat
(batchId=299)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFTrunc.testStringToDateWithYearFormat
(batchId=299)
org.apache.hive.common.util.TestDateParser.testValidCases (batchId=296)
org.apache.hive.common.util.TestTimestampParser.testDefault (batchId=296)
org.apache.hive.common.util.TestTimestampParser.testMillisParser (batchId=296)
org.apache.hive.common.util.TestTimestampParser.testPattern1 (batchId=296)
org.apache.hive.common.util.TestTimestampParser.testPattern2 (batchId=296)
{noformat}
Test results:
https://builds.apache.org/job/PreCommit-HIVE-Build/17315/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/17315/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-17315/
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: 92 tests failed
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12969852 - PreCommit-HIVE-Build
> Introduce CAST...FORMAT and limited list of SQL:2016 datetime formats
> ---------------------------------------------------------------------
>
> Key: HIVE-21576
> URL: https://issues.apache.org/jira/browse/HIVE-21576
> Project: Hive
> Issue Type: Improvement
> Reporter: Karen Coppage
> Assignee: Karen Coppage
> Priority: Major
> Attachments: HIVE-21576.01.patch, HIVE-21576.03.patch,
> HIVE-21576.2.patch
>
>
> Introduce FORMAT clause to CAST statements as well as the below limited list
> of SQL:2016 datetime formats to Hive in general. These can be used if a
> session-level feature flag is turned on.
> * YYYY
> * MM
> * DD
> * HH
> * MI
> * SS
> Definitions of these formats here:
> [https://docs.google.com/document/d/1V7k6-lrPGW7_uhqM-FhKl3QsxwCRy69v2KIxPsGjc1k/|https://docs.google.com/document/d/1V7k6-lrPGW7_uhqM-FhKl3QsxwCRy69v2KIxPsGjc1k/edit]
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
