[
https://issues.apache.org/jira/browse/HIVE-12192?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16499087#comment-16499087
]
Hive QA commented on HIVE-12192:
--------------------------------
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12926116/HIVE-12192.08.patch
{color:green}SUCCESS:{color} +1 due to 63 test(s) being added or modified.
{color:red}ERROR:{color} -1 due to 179 failed/errored test(s), 14447 tests
executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.accumulo.predicate.TestAccumuloRangeGenerator.testDateRangeConjunction
(batchId=191)
org.apache.hadoop.hive.cli.TestBeeLineDriver.testCliDriver[udf_unix_timestamp]
(batchId=255)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[cast_on_constant]
(batchId=25)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[confirm_initial_tbl_stats]
(batchId=31)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[druid_timestamptz2]
(batchId=35)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[infer_join_preds]
(batchId=25)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[input31] (batchId=63)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[interval_alt] (batchId=4)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[partition_timestamp2]
(batchId=33)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[partition_timestamp]
(batchId=37)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[singletsinsertorc]
(batchId=53)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[timestamp] (batchId=30)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[timestamp_literal]
(batchId=27)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[udf_to_utc_timestamp]
(batchId=23)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[update_all_types]
(batchId=18)
org.apache.hadoop.hive.cli.TestHBaseCliDriver.testCliDriver[hbase_timestamp]
(batchId=103)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[default_constraint]
(batchId=164)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[results_cache_2]
(batchId=175)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[schema_evol_text_nonvec_part_all_primitive_llap_io]
(batchId=177)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[schema_evol_text_vec_part_all_primitive_llap_io]
(batchId=174)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[stats_date]
(batchId=171)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[vectorized_timestamp_funcs]
(batchId=162)
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver[orc_merge5]
(batchId=184)
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver[orc_merge6]
(batchId=184)
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver[orc_merge7]
(batchId=186)
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver[orc_merge8]
(batchId=186)
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver[orc_merge9]
(batchId=183)
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver[orc_merge_incompat1]
(batchId=185)
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver[orc_merge_incompat2]
(batchId=186)
org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[acid_vectorization_original_tez]
(batchId=107)
org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[orc_merge12]
(batchId=106)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[vectorized_timestamp_funcs]
(batchId=122)
org.apache.hadoop.hive.cli.TestSparkPerfCliDriver.testCliDriver[query12]
(batchId=257)
org.apache.hadoop.hive.cli.TestSparkPerfCliDriver.testCliDriver[query16]
(batchId=257)
org.apache.hadoop.hive.cli.TestSparkPerfCliDriver.testCliDriver[query20]
(batchId=257)
org.apache.hadoop.hive.cli.TestSparkPerfCliDriver.testCliDriver[query21]
(batchId=257)
org.apache.hadoop.hive.cli.TestSparkPerfCliDriver.testCliDriver[query32]
(batchId=257)
org.apache.hadoop.hive.cli.TestSparkPerfCliDriver.testCliDriver[query37]
(batchId=257)
org.apache.hadoop.hive.cli.TestSparkPerfCliDriver.testCliDriver[query40]
(batchId=257)
org.apache.hadoop.hive.cli.TestSparkPerfCliDriver.testCliDriver[query5]
(batchId=257)
org.apache.hadoop.hive.cli.TestSparkPerfCliDriver.testCliDriver[query77]
(batchId=257)
org.apache.hadoop.hive.cli.TestSparkPerfCliDriver.testCliDriver[query80]
(batchId=257)
org.apache.hadoop.hive.cli.TestSparkPerfCliDriver.testCliDriver[query82]
(batchId=257)
org.apache.hadoop.hive.cli.TestSparkPerfCliDriver.testCliDriver[query92]
(batchId=257)
org.apache.hadoop.hive.cli.TestSparkPerfCliDriver.testCliDriver[query94]
(batchId=257)
org.apache.hadoop.hive.cli.TestSparkPerfCliDriver.testCliDriver[query95]
(batchId=257)
org.apache.hadoop.hive.cli.TestSparkPerfCliDriver.testCliDriver[query98]
(batchId=257)
org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query12]
(batchId=255)
org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query16]
(batchId=255)
org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query20]
(batchId=255)
org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query21]
(batchId=255)
org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query32]
(batchId=255)
org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query37]
(batchId=255)
org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query40]
(batchId=255)
org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query5]
(batchId=255)
org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query77]
(batchId=255)
org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query80]
(batchId=255)
org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query82]
(batchId=255)
org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query92]
(batchId=255)
org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query94]
(batchId=255)
org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query95]
(batchId=255)
org.apache.hadoop.hive.cli.TestTezPerfCliDriver.testCliDriver[query98]
(batchId=255)
org.apache.hadoop.hive.ql.exec.TestUtilities.testSerializeTimestamp
(batchId=297)
org.apache.hadoop.hive.ql.exec.vector.TestStructColumnVector.testStringify
(batchId=194)
org.apache.hadoop.hive.ql.exec.vector.TestVectorGroupByOperator.testTimestampKeyTypeAggregate
(batchId=294)
org.apache.hadoop.hive.ql.exec.vector.TestVectorizationContext.testBetweenFilters
(batchId=291)
org.apache.hadoop.hive.ql.exec.vector.TestVectorizationContext.testIfConditionalExprs
(batchId=291)
org.apache.hadoop.hive.ql.exec.vector.expressions.TestVectorCastStatement.testDecimal
(batchId=294)
org.apache.hadoop.hive.ql.exec.vector.expressions.TestVectorDateExpressions.testVectorUDFDayOfMonth
(batchId=291)
org.apache.hadoop.hive.ql.exec.vector.expressions.TestVectorDateExpressions.testVectorUDFMonth
(batchId=291)
org.apache.hadoop.hive.ql.exec.vector.expressions.TestVectorDateExpressions.testVectorUDFWeekOfYear
(batchId=291)
org.apache.hadoop.hive.ql.exec.vector.expressions.TestVectorDateExpressions.testVectorUDFYear
(batchId=291)
org.apache.hadoop.hive.ql.exec.vector.expressions.TestVectorGenericDateExpressions.testDate
(batchId=292)
org.apache.hadoop.hive.ql.exec.vector.expressions.TestVectorGenericDateExpressions.testDateAddColCol
(batchId=292)
org.apache.hadoop.hive.ql.exec.vector.expressions.TestVectorGenericDateExpressions.testDateAddColScalar
(batchId=292)
org.apache.hadoop.hive.ql.exec.vector.expressions.TestVectorGenericDateExpressions.testDateAddScalarCol
(batchId=292)
org.apache.hadoop.hive.ql.exec.vector.expressions.TestVectorGenericDateExpressions.testDateDiffColCol
(batchId=292)
org.apache.hadoop.hive.ql.exec.vector.expressions.TestVectorGenericDateExpressions.testDateDiffColScalar
(batchId=292)
org.apache.hadoop.hive.ql.exec.vector.expressions.TestVectorGenericDateExpressions.testDateDiffScalarCol
(batchId=292)
org.apache.hadoop.hive.ql.exec.vector.expressions.TestVectorGenericDateExpressions.testDateSubColCol
(batchId=292)
org.apache.hadoop.hive.ql.exec.vector.expressions.TestVectorGenericDateExpressions.testDateSubColScalar
(batchId=292)
org.apache.hadoop.hive.ql.exec.vector.expressions.TestVectorGenericDateExpressions.testDateSubScalarCol
(batchId=292)
org.apache.hadoop.hive.ql.exec.vector.expressions.TestVectorGenericDateExpressions.testToDate
(batchId=292)
org.apache.hadoop.hive.ql.exec.vector.expressions.TestVectorTimestampExpressions.testVectorUDFDayOfMonthString
(batchId=292)
org.apache.hadoop.hive.ql.exec.vector.expressions.TestVectorTimestampExpressions.testVectorUDFHourString
(batchId=292)
org.apache.hadoop.hive.ql.exec.vector.expressions.TestVectorTimestampExpressions.testVectorUDFMonthString
(batchId=292)
org.apache.hadoop.hive.ql.exec.vector.expressions.TestVectorTimestampExpressions.testVectorUDFWeekOfYearString
(batchId=292)
org.apache.hadoop.hive.ql.exec.vector.expressions.TestVectorTimestampExpressions.testVectorUDFYearString
(batchId=292)
org.apache.hadoop.hive.ql.io.arrow.TestArrowColumnarBatchSerDe.testComprehensive
(batchId=276)
org.apache.hadoop.hive.ql.io.arrow.TestArrowColumnarBatchSerDe.testListDTI
(batchId=276)
org.apache.hadoop.hive.ql.io.arrow.TestArrowColumnarBatchSerDe.testMapDTI
(batchId=276)
org.apache.hadoop.hive.ql.io.arrow.TestArrowColumnarBatchSerDe.testPrimitiveDTI
(batchId=276)
org.apache.hadoop.hive.ql.io.arrow.TestArrowColumnarBatchSerDe.testStructDTI
(batchId=276)
org.apache.hadoop.hive.ql.io.orc.TestInputOutputFormat.testVectorizationWithAcid
(batchId=280)
org.apache.hadoop.hive.ql.io.orc.TestOrcSerDeStats.testOrcSerDeStatsComplex
(batchId=280)
org.apache.hadoop.hive.ql.io.orc.TestOrcSerDeStats.testOrcSerDeStatsComplexOldFormat
(batchId=280)
org.apache.hadoop.hive.ql.io.orc.TestVectorizedORCReader.createFile
(batchId=280)
org.apache.hadoop.hive.ql.io.parquet.serde.TestParquetTimestampUtils.testTimezoneValues
(batchId=278)
org.apache.hadoop.hive.ql.io.parquet.serde.TestParquetTimestampUtils.testTimezoneless
(batchId=278)
org.apache.hadoop.hive.ql.io.parquet.serde.TestParquetTimestampUtils.testTimezonelessValues
(batchId=278)
org.apache.hadoop.hive.ql.parse.TestSemanticAnalyzer.testNormalizeColSpec
(batchId=281)
org.apache.hadoop.hive.ql.udf.TestUDFDateFormatGranularity.testTimestampToTimestampWithGranularity
(batchId=274)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFDate.testDateWritablepToDate
(batchId=271)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFDate.testTimestampToDate
(batchId=271)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFDateAdd.testByteDataTypeAsDays
(batchId=268)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFDateAdd.testDateWritablepToDate
(batchId=268)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFDateAdd.testShortDataTypeAsDays
(batchId=268)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFDateAdd.testTimestampToDate
(batchId=268)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFDateFormat.testWrongDateStr
(batchId=269)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFDateSub.testByteDataTypeAsDays
(batchId=271)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFDateSub.testDateWritablepToDate
(batchId=271)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFDateSub.testShortDataTypeAsDays
(batchId=271)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFDateSub.testTimestampToDate
(batchId=271)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFFromUtcTimestamp.testFromUtcTimestamp
(batchId=271)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFFromUtcTimestamp.testToUtcTimestamp
(batchId=271)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFLastDay.testWrongDateStr
(batchId=270)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFLastDay.testWrongTsStr
(batchId=270)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFMonthsBetween.testMonthsBetweenForDate
(batchId=272)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFMonthsBetween.testMonthsBetweenForString
(batchId=272)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFMonthsBetween.testMonthsBetweenForTimestamp
(batchId=272)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFMonthsBetween.testWrongDateStr
(batchId=272)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFNextDay.testNotValidValues
(batchId=272)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFOPMinus.testTimestampMinusIntervalDayTime
(batchId=269)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFOPPlus.testDatePlusIntervalDayTime
(batchId=268)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFOPPlus.testIntervalDayTimePlusDate
(batchId=268)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFOPPlus.testIntervalDayTimePlusTimestamp
(batchId=268)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFOPPlus.testTimestampPlusIntervalDayTime
(batchId=268)
org.apache.hadoop.hive.ql.udf.generic.TestGenericUDFQuarter.testWrongDateStr
(batchId=272)
org.apache.hadoop.hive.ql.util.TestDateTimeMath.testTimestampIntervalDayTimeArithmetic
(batchId=266)
org.apache.hadoop.hive.ql.util.TestDateTimeMath.testTimestampIntervalYearMonthArithmetic
(batchId=266)
org.apache.hadoop.hive.ql.util.TestDateTimeMath.testTimestampSubtraction
(batchId=266)
org.apache.hadoop.hive.serde2.io.TestTimestampWritable.testDecimalToTimestampCornerCases
(batchId=308)
org.apache.hadoop.hive.serde2.io.TestTimestampWritable.testDecimalToTimestampRandomly
(batchId=308)
org.apache.hadoop.hive.serde2.io.TestTimestampWritable.testToFromDouble
(batchId=308)
org.apache.hadoop.hive.serde2.lazy.TestLazyPrimitive.testLazyDate (batchId=308)
org.apache.hadoop.hive.serde2.lazy.TestLazyPrimitive.testLazyTimestamp
(batchId=308)
org.apache.hadoop.hive.serde2.objectinspector.TestStandardObjectInspectors.testStandardPrimitiveObjectInspector
(batchId=309)
org.apache.hadoop.hive.serde2.objectinspector.primitive.TestPrimitiveObjectInspectorUtils.testGetTimestampFromString
(batchId=309)
org.apache.hadoop.hive.serde2.objectinspector.primitive.TestPrimitiveObjectInspectorUtils.testgetTimestampWithMillisecondsInt
(batchId=309)
org.apache.hadoop.hive.serde2.objectinspector.primitive.TestPrimitiveObjectInspectorUtils.testgetTimestampWithSecondsInt
(batchId=309)
org.apache.hive.common.util.TestDateParser.testValidCases (batchId=265)
org.apache.hive.common.util.TestTimestampParser.testDefault (batchId=265)
org.apache.hive.common.util.TestTimestampParser.testMillisParser (batchId=265)
org.apache.hive.common.util.TestTimestampParser.testPattern1 (batchId=265)
org.apache.hive.common.util.TestTimestampParser.testPattern2 (batchId=265)
org.apache.hive.hcatalog.data.TestDefaultHCatRecord.testRYW (batchId=206)
org.apache.hive.hcatalog.data.TestJsonSerDe.testRW (batchId=206)
org.apache.hive.hcatalog.data.TestJsonSerDe.testRobustRead (batchId=206)
org.apache.hive.hcatalog.pig.TestAvroHCatLoader.testDatePartitionPushUp
(batchId=198)
org.apache.hive.hcatalog.pig.TestAvroHCatLoader.testReadDataPrimitiveTypes
(batchId=198)
org.apache.hive.hcatalog.pig.TestAvroHCatStorer.testWriteDate (batchId=198)
org.apache.hive.hcatalog.pig.TestAvroHCatStorer.testWriteDate2 (batchId=198)
org.apache.hive.hcatalog.pig.TestOrcHCatLoader.testDatePartitionPushUp
(batchId=198)
org.apache.hive.hcatalog.pig.TestOrcHCatLoader.testReadDataPrimitiveTypes
(batchId=198)
org.apache.hive.hcatalog.pig.TestOrcHCatStorer.testWriteDate (batchId=198)
org.apache.hive.hcatalog.pig.TestOrcHCatStorer.testWriteDate2 (batchId=198)
org.apache.hive.hcatalog.pig.TestOrcHCatStorer.testWriteTimestamp (batchId=198)
org.apache.hive.hcatalog.pig.TestParquetHCatLoader.testDatePartitionPushUp
(batchId=198)
org.apache.hive.hcatalog.pig.TestParquetHCatLoader.testReadDataPrimitiveTypes
(batchId=198)
org.apache.hive.hcatalog.pig.TestParquetHCatStorer.testWriteDate (batchId=198)
org.apache.hive.hcatalog.pig.TestParquetHCatStorer.testWriteDate2 (batchId=198)
org.apache.hive.hcatalog.pig.TestParquetHCatStorer.testWriteTimestamp
(batchId=198)
org.apache.hive.hcatalog.pig.TestRCFileHCatLoader.testDatePartitionPushUp
(batchId=198)
org.apache.hive.hcatalog.pig.TestRCFileHCatLoader.testReadDataPrimitiveTypes
(batchId=198)
org.apache.hive.hcatalog.pig.TestRCFileHCatStorer.testWriteDate (batchId=198)
org.apache.hive.hcatalog.pig.TestRCFileHCatStorer.testWriteDate2 (batchId=198)
org.apache.hive.hcatalog.pig.TestRCFileHCatStorer.testWriteTimestamp
(batchId=198)
org.apache.hive.hcatalog.pig.TestSequenceFileHCatLoader.testDatePartitionPushUp
(batchId=198)
org.apache.hive.hcatalog.pig.TestSequenceFileHCatLoader.testReadDataPrimitiveTypes
(batchId=198)
org.apache.hive.hcatalog.pig.TestSequenceFileHCatStorer.testWriteDate
(batchId=198)
org.apache.hive.hcatalog.pig.TestSequenceFileHCatStorer.testWriteDate2
(batchId=198)
org.apache.hive.hcatalog.pig.TestSequenceFileHCatStorer.testWriteTimestamp
(batchId=198)
org.apache.hive.hcatalog.pig.TestTextFileHCatLoader.testDatePartitionPushUp
(batchId=198)
org.apache.hive.hcatalog.pig.TestTextFileHCatLoader.testReadDataPrimitiveTypes
(batchId=198)
org.apache.hive.hcatalog.pig.TestTextFileHCatStorer.testWriteDate (batchId=198)
org.apache.hive.hcatalog.pig.TestTextFileHCatStorer.testWriteDate2 (batchId=198)
org.apache.hive.hcatalog.pig.TestTextFileHCatStorer.testWriteTimestamp
(batchId=198)
org.apache.hive.jdbc.TestJdbcWithMiniLlapArrow.testDataTypes (batchId=242)
org.apache.hive.jdbc.TestJdbcWithMiniLlapRow.testDataTypes (batchId=242)
{noformat}
Test results:
https://builds.apache.org/job/PreCommit-HIVE-Build/11438/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/11438/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-11438/
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: 179 tests failed
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12926116 - PreCommit-HIVE-Build
> Hive should carry out timestamp computations in UTC
> ---------------------------------------------------
>
> Key: HIVE-12192
> URL: https://issues.apache.org/jira/browse/HIVE-12192
> Project: Hive
> Issue Type: Sub-task
> Components: Hive
> Reporter: Ryan Blue
> Assignee: Jesus Camacho Rodriguez
> Priority: Blocker
> Labels: timestamp
> Attachments: HIVE-12192.01.patch, HIVE-12192.02.patch,
> HIVE-12192.03.patch, HIVE-12192.04.patch, HIVE-12192.05.patch,
> HIVE-12192.06.patch, HIVE-12192.07.patch, HIVE-12192.08.patch,
> HIVE-12192.patch
>
>
> Hive currently uses the "local" time of a java.sql.Timestamp to represent the
> SQL data type TIMESTAMP WITHOUT TIME ZONE. The purpose is to be able to use
> {{Timestamp#getYear()}} and similar methods to implement SQL functions like
> {{year}}.
> When the SQL session's time zone is a DST zone, such as America/Los_Angeles
> that alternates between PST and PDT, there are times that cannot be
> represented because the effective zone skips them.
> {code}
> hive> select TIMESTAMP '2015-03-08 02:10:00.101';
> 2015-03-08 03:10:00.101
> {code}
> Using UTC instead of the SQL session time zone as the underlying zone for a
> java.sql.Timestamp avoids this bug, while still returning correct values for
> {{getYear}} etc. Using UTC as the convenience representation (timestamp
> without time zone has no real zone) would make timestamp calculations more
> consistent and avoid similar problems in the future.
> Notably, this would break the {{unix_timestamp}} UDF that specifies the
> result is with respect to ["the default timezone and default
> locale"|https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-DateFunctions].
> That function would need to be updated to use the
> {{System.getProperty("user.timezone")}} zone.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
