[
https://issues.apache.org/jira/browse/HIVE-21576?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16849193#comment-16849193
]
Hive QA commented on HIVE-21576:
--------------------------------
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12969924/HIVE-21576.04.patch
{color:green}SUCCESS:{color} +1 due to 11 test(s) being added or modified.
{color:red}ERROR:{color} -1 due to 55 failed/errored test(s), 16086 tests
executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[cast_datetime_with_sql_2016_format]
(batchId=87)
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[timestamptz_4]
(batchId=67)
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_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_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[update_all_types]
(batchId=19)
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.TestMiniLlapLocalCliDriver.testCliDriver[dst]
(batchId=166)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[orc_ppd_date]
(batchId=172)
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[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[vectorized_timestamp_funcs]
(batchId=126)
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.parse.TestReplicationScenariosAcidTablesBootstrap.testBootstrapAcidTablesDuringIncrementalWithConcurrentWrites
(batchId=246)
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.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.TestGenericUDFFromUtcTimestamp.testFromUtcTimestamp
(batchId=303)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFFromUtcTimestamp.testToUtcTimestamp
(batchId=303)
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.testNotValidValues
(batchId=303)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFQuarter.testWrongDateStr
(batchId=304)
org.apache.hive.common.util.TestDateParser.testValidCases (batchId=296)
{noformat}
Test results:
https://builds.apache.org/job/PreCommit-HIVE-Build/17320/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/17320/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-17320/
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: 55 tests failed
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12969924 - 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.04.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)
