[jira] [Commented] (HIVE-16614) Support "set local time zone" statement

["Hive QA (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-16614?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16101024#comment-16101024 ] 

Hive QA commented on HIVE-16614:
--------------------------------



Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12878853/HIVE-16614.02.patch

{color:green}SUCCESS:{color} +1 due to 4 test(s) being added or modified.

{color:red}ERROR:{color} -1 due to 309 failed/errored test(s), 11014 tests executed
*Failed tests:*
{noformat}
TestPerfCliDriver - did not produce a TEST-*.xml file (likely timed out) (batchId=235)
org.apache.hadoop.hive.accumulo.TestLazyAccumuloRow.testDeserializationOfBinaryEncoding (batchId=175)
org.apache.hadoop.hive.accumulo.TestLazyAccumuloRow.testExpectedDeserializationOfColumns (batchId=175)
org.apache.hadoop.hive.accumulo.TestLazyAccumuloRow.testNullInit (batchId=175)
org.apache.hadoop.hive.accumulo.mr.TestHiveAccumuloTableOutputFormat.testBinarySerializationOnStringFallsBackToUtf8 (batchId=175)
org.apache.hadoop.hive.accumulo.mr.TestHiveAccumuloTableOutputFormat.testWriteMap (batchId=175)
org.apache.hadoop.hive.accumulo.mr.TestHiveAccumuloTableOutputFormat.testWriteToMockInstance (batchId=175)
org.apache.hadoop.hive.accumulo.mr.TestHiveAccumuloTableOutputFormat.testWriteToMockInstanceWithVisibility (batchId=175)
org.apache.hadoop.hive.accumulo.serde.TestAccumuloRowSerializer.testBinarySerialization (batchId=175)
org.apache.hadoop.hive.accumulo.serde.TestAccumuloRowSerializer.testMapSerialization (batchId=175)
org.apache.hadoop.hive.accumulo.serde.TestAccumuloRowSerializer.testVisibilityLabel (batchId=175)
org.apache.hadoop.hive.accumulo.serde.TestAccumuloSerDe.deserialization (batchId=175)
org.apache.hadoop.hive.accumulo.serde.TestAccumuloSerDe.deserializeWithTooFewHiveColumns (batchId=175)
org.apache.hadoop.hive.accumulo.serde.TestAccumuloSerDe.invalidColMapping (batchId=175)
org.apache.hadoop.hive.accumulo.serde.TestAccumuloSerDe.moreAccumuloColumnsThanHiveColumns (batchId=175)
org.apache.hadoop.hive.accumulo.serde.TestAccumuloSerDe.moreHiveColumnsThanAccumuloColumns (batchId=175)
org.apache.hadoop.hive.accumulo.serde.TestAccumuloSerDe.simpleColumnMapping (batchId=175)
org.apache.hadoop.hive.accumulo.serde.TestAccumuloSerDe.testArraySerialization (batchId=175)
org.apache.hadoop.hive.accumulo.serde.TestAccumuloSerDe.testColumnVisibilityForSerializer (batchId=175)
org.apache.hadoop.hive.accumulo.serde.TestAccumuloSerDe.testCompositeKeyDeserialization (batchId=175)
org.apache.hadoop.hive.accumulo.serde.TestAccumuloSerDe.testMapSerialization (batchId=175)
org.apache.hadoop.hive.accumulo.serde.TestAccumuloSerDe.testNoVisibilitySetsEmptyVisibility (batchId=175)
org.apache.hadoop.hive.accumulo.serde.TestAccumuloSerDe.testStructOfMapSerialization (batchId=175)
org.apache.hadoop.hive.accumulo.serde.TestAccumuloSerDe.withRowID (batchId=175)
org.apache.hadoop.hive.accumulo.serde.TestAccumuloSerDeParameters.testNullAuthsFromProperties (batchId=175)
org.apache.hadoop.hive.accumulo.serde.TestAccumuloSerDeParameters.testParseAuthorizationsFromnProperties (batchId=175)
org.apache.hadoop.hive.accumulo.serde.TestAccumuloSerDeParameters.testParseColumnVisibility (batchId=175)
org.apache.hadoop.hive.accumulo.serde.TestDefaultAccumuloRowIdFactory.testBinaryStringRowId (batchId=175)
org.apache.hadoop.hive.accumulo.serde.TestDefaultAccumuloRowIdFactory.testCorrectComplexInspectors (batchId=175)
org.apache.hadoop.hive.accumulo.serde.TestDefaultAccumuloRowIdFactory.testCorrectPrimitiveInspectors (batchId=175)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[annotate_stats_select] (batchId=59)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[constantfolding] (batchId=71)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[timestamptz] (batchId=61)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[timestamptz_1] (batchId=56)
org.apache.hadoop.hive.cli.TestContribNegativeCliDriver.testCliDriver[invalid_row_sequence] (batchId=237)
org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[llap_smb] (batchId=144)
org.apache.hadoop.hive.cli.TestMiniSparkOnYarnCliDriver.testCliDriver[spark_vectorized_dynamic_partition_pruning] (batchId=168)
org.apache.hadoop.hive.cli.TestMiniTezCliDriver.testCliDriver[explainuser_3] (batchId=99)
org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[udaf_invalid_place] (batchId=89)
org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[udtf_invalid_place] (batchId=89)
org.apache.hadoop.hive.common.type.TestTimestampTZ.testConvertToUTC (batchId=250)
org.apache.hadoop.hive.common.type.TestTimestampTZ.testFromToInstant (batchId=250)
org.apache.hadoop.hive.common.type.TestTimestampTZ.testVariations (batchId=250)
org.apache.hadoop.hive.hbase.TestHBaseSerDe.testHBaseSerDeCompositeKeyWithSeparator (batchId=173)
org.apache.hadoop.hive.hbase.TestHBaseSerDe.testHBaseSerDeCompositeKeyWithoutSeparator (batchId=173)
org.apache.hadoop.hive.hbase.TestHBaseSerDe.testHBaseSerDeCustomStructValue (batchId=173)
org.apache.hadoop.hive.hbase.TestHBaseSerDe.testHBaseSerDeI (batchId=173)
org.apache.hadoop.hive.hbase.TestHBaseSerDe.testHBaseSerDeII (batchId=173)
org.apache.hadoop.hive.hbase.TestHBaseSerDe.testHBaseSerDeWithAvroExternalSchema (batchId=173)
org.apache.hadoop.hive.hbase.TestHBaseSerDe.testHBaseSerDeWithAvroSchemaInline (batchId=173)
org.apache.hadoop.hive.hbase.TestHBaseSerDe.testHBaseSerDeWithAvroSchemaUrl (batchId=173)
org.apache.hadoop.hive.hbase.TestHBaseSerDe.testHBaseSerDeWithAvroSerClass (batchId=173)
org.apache.hadoop.hive.hbase.TestHBaseSerDe.testHBaseSerDeWithBackwardEvolvedSchema (batchId=173)
org.apache.hadoop.hive.hbase.TestHBaseSerDe.testHBaseSerDeWithColumnPrefixes (batchId=173)
org.apache.hadoop.hive.hbase.TestHBaseSerDe.testHBaseSerDeWithForwardEvolvedSchema (batchId=173)
org.apache.hadoop.hive.hbase.TestHBaseSerDe.testHBaseSerDeWithHiveMapToHBaseAvroColumnFamily (batchId=173)
org.apache.hadoop.hive.hbase.TestHBaseSerDe.testHBaseSerDeWithHiveMapToHBaseColumnFamily (batchId=173)
org.apache.hadoop.hive.hbase.TestHBaseSerDe.testHBaseSerDeWithHiveMapToHBaseColumnFamilyII (batchId=173)
org.apache.hadoop.hive.hbase.TestHBaseSerDe.testHBaseSerDeWithTimestamp (batchId=173)
org.apache.hadoop.hive.metastore.TestHiveMetaStoreStatsMerge.testStatsMerge (batchId=206)
org.apache.hadoop.hive.ql.exec.TestOperators.testScriptOperator (batchId=271)
org.apache.hadoop.hive.ql.exec.vector.TestVectorSerDeRow.testVectorLazySimpleDeserializeRow (batchId=276)
org.apache.hadoop.hive.ql.exec.vector.TestVectorSerDeRow.testVectorLazySimpleSerializeRow (batchId=276)
org.apache.hadoop.hive.ql.io.TestRCFile.testCloseForErroneousRCFile (batchId=261)
org.apache.hadoop.hive.ql.io.TestRCFile.testExplicitRCFileHeader (batchId=261)
org.apache.hadoop.hive.ql.io.TestRCFile.testGetColumn (batchId=261)
org.apache.hadoop.hive.ql.io.TestRCFile.testNonExplicitRCFileHeader (batchId=261)
org.apache.hadoop.hive.ql.io.TestRCFile.testReadCorruptFile (batchId=261)
org.apache.hadoop.hive.ql.io.TestRCFile.testReadOldFileHeader (batchId=261)
org.apache.hadoop.hive.ql.io.TestRCFile.testSimpleReadAndWrite (batchId=261)
org.apache.hadoop.hive.ql.io.TestRCFile.testSynAndSplit (batchId=261)
org.apache.hadoop.hive.ql.io.TestRCFile.testSync (batchId=261)
org.apache.hadoop.hive.ql.io.TestRCFile.testWriteAndFullyRead (batchId=261)
org.apache.hadoop.hive.ql.io.TestRCFile.testWriteAndPartialRead (batchId=261)
org.apache.hadoop.hive.ql.parse.TestParseNegativeDriver.testCliDriver[invalid_dot] (batchId=239)
org.apache.hadoop.hive.ql.parse.TestParseNegativeDriver.testCliDriver[invalid_index] (batchId=239)
org.apache.hadoop.hive.ql.parse.TestParseNegativeDriver.testCliDriver[unknown_function2] (batchId=239)
org.apache.hadoop.hive.ql.parse.TestParseNegativeDriver.testCliDriver[unknown_function3] (batchId=239)
org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testRenamePartitionWithCM (batchId=218)
org.apache.hadoop.hive.serde2.TestStatsSerde.testColumnarSerDe (batchId=291)
org.apache.hadoop.hive.serde2.TestStatsSerde.testLazySimpleSerDe (batchId=291)
org.apache.hadoop.hive.serde2.columnar.TestLazyBinaryColumnarSerDe.testHandlingAlteredSchemas (batchId=291)
org.apache.hadoop.hive.serde2.columnar.TestLazyBinaryColumnarSerDe.testLazyBinaryColumnarSerDeWithEmptyBinary (batchId=291)
org.apache.hadoop.hive.serde2.columnar.TestLazyBinaryColumnarSerDe.testSerDe (batchId=291)
org.apache.hadoop.hive.serde2.columnar.TestLazyBinaryColumnarSerDe.testSerDeEmpties (batchId=291)
org.apache.hadoop.hive.serde2.columnar.TestLazyBinaryColumnarSerDe.testSerDeInnerNulls (batchId=291)
org.apache.hadoop.hive.serde2.columnar.TestLazyBinaryColumnarSerDe.testSerDeOuterNulls (batchId=291)
org.apache.hadoop.hive.serde2.lazy.TestLazyArrayMapStruct.testLazyArrayNested (batchId=289)
org.apache.hadoop.hive.serde2.lazy.TestLazyArrayMapStruct.testLazyArrayNestedExceedLimit (batchId=289)
org.apache.hadoop.hive.serde2.lazy.TestLazyArrayMapStruct.testLazyArrayNestedExceedLimitNotExtended (batchId=289)
org.apache.hadoop.hive.serde2.lazy.TestLazyArrayMapStruct.testLazyMapNested (batchId=289)
org.apache.hadoop.hive.serde2.lazy.TestLazyArrayMapStruct.testLazyMapNestedExceedLimit (batchId=289)
org.apache.hadoop.hive.serde2.lazy.TestLazyArrayMapStruct.testLazyMapNestedExceedLimitNotExtended (batchId=289)
org.apache.hadoop.hive.serde2.lazy.TestLazyArrayMapStruct.testLazyStructNested (batchId=289)
org.apache.hadoop.hive.serde2.lazy.TestLazyArrayMapStruct.testLazyStructNestedExceedLimit (batchId=289)
org.apache.hadoop.hive.serde2.lazy.TestLazyArrayMapStruct.testLazyStructNestedExceedLimitNotExtended (batchId=289)
org.apache.hadoop.hive.serde2.lazy.TestLazyArrayMapStruct.testLazyUnionNested (batchId=289)
org.apache.hadoop.hive.serde2.lazy.TestLazyArrayMapStruct.testLazyUnionNestedExceedLimit (batchId=289)
org.apache.hadoop.hive.serde2.lazy.TestLazyArrayMapStruct.testLazyUnionNestedExceedLimitNotExtended (batchId=289)
org.apache.hadoop.hive.serde2.lazy.TestLazySimpleFast.testLazyBinarySimpleComplexDepthFour (batchId=289)
org.apache.hadoop.hive.serde2.lazy.TestLazySimpleFast.testLazyBinarySimpleComplexDepthOne (batchId=289)
org.apache.hadoop.hive.serde2.lazy.TestLazySimpleFast.testLazyBinarySimplePrimitive (batchId=289)
org.apache.hadoop.hive.serde2.lazy.TestLazySimpleSerDe.testLazySimpleSerDe (batchId=289)
org.apache.hadoop.hive.serde2.lazy.TestLazySimpleSerDe.testLazySimpleSerDeExtraColumns (batchId=289)
org.apache.hadoop.hive.serde2.lazy.TestLazySimpleSerDe.testLazySimpleSerDeLastColumnTakesRest (batchId=289)
org.apache.hadoop.hive.serde2.lazy.TestLazySimpleSerDe.testLazySimpleSerDeMissingColumns (batchId=289)
org.apache.hadoop.hive.serde2.lazy.TestLazySimpleSerDe.testSerDeParameters (batchId=289)
org.apache.hadoop.hive.serde2.objectinspector.TestCrossMapEqualComparer.testCompatibleType (batchId=290)
org.apache.hadoop.hive.serde2.objectinspector.TestCrossMapEqualComparer.testIncompatibleType (batchId=290)
org.apache.hadoop.hive.serde2.objectinspector.TestSimpleMapEqualComparer.testCompatibleType (batchId=290)
org.apache.hadoop.hive.serde2.objectinspector.TestSimpleMapEqualComparer.testIncompatibleType (batchId=290)
org.apache.hive.hcatalog.api.TestHCatClient.testPartitionRegistrationWithCustomSchema (batchId=179)
org.apache.hive.hcatalog.api.TestHCatClient.testPartitionSpecRegistrationWithCustomSchema (batchId=179)
org.apache.hive.hcatalog.api.TestHCatClient.testTableSchemaPropagation (batchId=179)
org.apache.hive.hcatalog.data.TestHCatRecordSerDe.testRW (batchId=190)
org.apache.hive.hcatalog.mapreduce.TestHCatDynamicPartitioned.testHCatDynamicPartitionedTableMultipleTask[0] (batchId=186)
org.apache.hive.hcatalog.mapreduce.TestHCatDynamicPartitioned.testHCatDynamicPartitionedTableMultipleTask[1] (batchId=186)
org.apache.hive.hcatalog.mapreduce.TestHCatDynamicPartitioned.testHCatDynamicPartitionedTableMultipleTask[2] (batchId=186)
org.apache.hive.hcatalog.mapreduce.TestHCatDynamicPartitioned.testHCatDynamicPartitionedTableMultipleTask[6] (batchId=186)
org.apache.hive.hcatalog.mapreduce.TestHCatDynamicPartitioned.testHCatDynamicPartitionedTable[0] (batchId=186)
org.apache.hive.hcatalog.mapreduce.TestHCatDynamicPartitioned.testHCatDynamicPartitionedTable[1] (batchId=186)
org.apache.hive.hcatalog.mapreduce.TestHCatDynamicPartitioned.testHCatDynamicPartitionedTable[2] (batchId=186)
org.apache.hive.hcatalog.mapreduce.TestHCatDynamicPartitioned.testHCatDynamicPartitionedTable[6] (batchId=186)
org.apache.hive.hcatalog.mapreduce.TestHCatExternalDynamicPartitioned.testHCatDynamicPartitionedTableMultipleTask[0] (batchId=188)
org.apache.hive.hcatalog.mapreduce.TestHCatExternalDynamicPartitioned.testHCatDynamicPartitionedTableMultipleTask[1] (batchId=188)
org.apache.hive.hcatalog.mapreduce.TestHCatExternalDynamicPartitioned.testHCatDynamicPartitionedTableMultipleTask[2] (batchId=188)
org.apache.hive.hcatalog.mapreduce.TestHCatExternalDynamicPartitioned.testHCatDynamicPartitionedTableMultipleTask[6] (batchId=188)
org.apache.hive.hcatalog.mapreduce.TestHCatExternalDynamicPartitioned.testHCatDynamicPartitionedTable[0] (batchId=188)
org.apache.hive.hcatalog.mapreduce.TestHCatExternalDynamicPartitioned.testHCatDynamicPartitionedTable[1] (batchId=188)
org.apache.hive.hcatalog.mapreduce.TestHCatExternalDynamicPartitioned.testHCatDynamicPartitionedTable[2] (batchId=188)
org.apache.hive.hcatalog.mapreduce.TestHCatExternalDynamicPartitioned.testHCatDynamicPartitionedTable[6] (batchId=188)
org.apache.hive.hcatalog.mapreduce.TestHCatExternalDynamicPartitioned.testHCatExternalDynamicCustomLocation[0] (batchId=188)
org.apache.hive.hcatalog.mapreduce.TestHCatExternalDynamicPartitioned.testHCatExternalDynamicCustomLocation[1] (batchId=188)
org.apache.hive.hcatalog.mapreduce.TestHCatExternalDynamicPartitioned.testHCatExternalDynamicCustomLocation[2] (batchId=188)
org.apache.hive.hcatalog.mapreduce.TestHCatExternalDynamicPartitioned.testHCatExternalDynamicCustomLocation[6] (batchId=188)
org.apache.hive.hcatalog.mapreduce.TestHCatExternalNonPartitioned.testHCatNonPartitionedTable[0] (batchId=189)
org.apache.hive.hcatalog.mapreduce.TestHCatExternalNonPartitioned.testHCatNonPartitionedTable[1] (batchId=189)
org.apache.hive.hcatalog.mapreduce.TestHCatExternalNonPartitioned.testHCatNonPartitionedTable[2] (batchId=189)
org.apache.hive.hcatalog.mapreduce.TestHCatExternalNonPartitioned.testHCatNonPartitionedTable[6] (batchId=189)
org.apache.hive.hcatalog.mapreduce.TestHCatExternalPartitioned.testHCatPartitionedTable[0] (batchId=185)
org.apache.hive.hcatalog.mapreduce.TestHCatExternalPartitioned.testHCatPartitionedTable[1] (batchId=185)
org.apache.hive.hcatalog.mapreduce.TestHCatExternalPartitioned.testHCatPartitionedTable[2] (batchId=185)
org.apache.hive.hcatalog.mapreduce.TestHCatExternalPartitioned.testHCatPartitionedTable[6] (batchId=185)
org.apache.hive.hcatalog.mapreduce.TestHCatHiveCompatibility.testPartedRead (batchId=233)
org.apache.hive.hcatalog.mapreduce.TestHCatHiveCompatibility.testUnpartedReadWrite (batchId=233)
org.apache.hive.hcatalog.mapreduce.TestHCatMutableDynamicPartitioned.testHCatDynamicPartitionedTableMultipleTask[0] (batchId=183)
org.apache.hive.hcatalog.mapreduce.TestHCatMutableDynamicPartitioned.testHCatDynamicPartitionedTableMultipleTask[1] (batchId=183)
org.apache.hive.hcatalog.mapreduce.TestHCatMutableDynamicPartitioned.testHCatDynamicPartitionedTableMultipleTask[2] (batchId=183)
org.apache.hive.hcatalog.mapreduce.TestHCatMutableDynamicPartitioned.testHCatDynamicPartitionedTableMultipleTask[6] (batchId=183)
org.apache.hive.hcatalog.mapreduce.TestHCatMutableDynamicPartitioned.testHCatDynamicPartitionedTable[0] (batchId=183)
org.apache.hive.hcatalog.mapreduce.TestHCatMutableDynamicPartitioned.testHCatDynamicPartitionedTable[1] (batchId=183)
org.apache.hive.hcatalog.mapreduce.TestHCatMutableDynamicPartitioned.testHCatDynamicPartitionedTable[2] (batchId=183)
org.apache.hive.hcatalog.mapreduce.TestHCatMutableDynamicPartitioned.testHCatDynamicPartitionedTable[6] (batchId=183)
org.apache.hive.hcatalog.mapreduce.TestHCatMutableNonPartitioned.testHCatNonPartitionedTable[0] (batchId=189)
org.apache.hive.hcatalog.mapreduce.TestHCatMutableNonPartitioned.testHCatNonPartitionedTable[1] (batchId=189)
org.apache.hive.hcatalog.mapreduce.TestHCatMutableNonPartitioned.testHCatNonPartitionedTable[2] (batchId=189)
org.apache.hive.hcatalog.mapreduce.TestHCatMutableNonPartitioned.testHCatNonPartitionedTable[6] (batchId=189)
org.apache.hive.hcatalog.mapreduce.TestHCatMutablePartitioned.testHCatPartitionedTable[0] (batchId=187)
org.apache.hive.hcatalog.mapreduce.TestHCatMutablePartitioned.testHCatPartitionedTable[1] (batchId=187)
org.apache.hive.hcatalog.mapreduce.TestHCatMutablePartitioned.testHCatPartitionedTable[2] (batchId=187)
org.apache.hive.hcatalog.mapreduce.TestHCatMutablePartitioned.testHCatPartitionedTable[6] (batchId=187)
org.apache.hive.hcatalog.mapreduce.TestHCatNonPartitioned.testHCatNonPartitionedTable[0] (batchId=184)
org.apache.hive.hcatalog.mapreduce.TestHCatNonPartitioned.testHCatNonPartitionedTable[1] (batchId=184)
org.apache.hive.hcatalog.mapreduce.TestHCatNonPartitioned.testHCatNonPartitionedTable[2] (batchId=184)
org.apache.hive.hcatalog.mapreduce.TestHCatNonPartitioned.testHCatNonPartitionedTable[6] (batchId=184)
org.apache.hive.hcatalog.mapreduce.TestHCatPartitioned.testHCatPartitionedTable[0] (batchId=184)
org.apache.hive.hcatalog.mapreduce.TestHCatPartitioned.testHCatPartitionedTable[1] (batchId=184)
org.apache.hive.hcatalog.mapreduce.TestHCatPartitioned.testHCatPartitionedTable[2] (batchId=184)
org.apache.hive.hcatalog.mapreduce.TestHCatPartitioned.testHCatPartitionedTable[6] (batchId=184)
org.apache.hive.hcatalog.mapreduce.TestSequenceFileReadWrite.testSequenceTableWriteRead (batchId=233)
org.apache.hive.hcatalog.mapreduce.TestSequenceFileReadWrite.testSequenceTableWriteReadMR (batchId=233)
org.apache.hive.hcatalog.mapreduce.TestSequenceFileReadWrite.testTextTableWriteRead (batchId=233)
org.apache.hive.hcatalog.mapreduce.TestSequenceFileReadWrite.testTextTableWriteReadMR (batchId=233)
org.apache.hive.hcatalog.pig.TestAvroHCatLoader.testConvertBooleanToInt (batchId=182)
org.apache.hive.hcatalog.pig.TestAvroHCatLoader.testReadDataPrimitiveTypes (batchId=182)
org.apache.hive.hcatalog.pig.TestAvroHCatStorer.testStoreMultiTables (batchId=182)
org.apache.hive.hcatalog.pig.TestE2EScenarios.testReadOrcAndRCFromPig (batchId=182)
org.apache.hive.hcatalog.pig.TestHCatLoaderComplexSchema.testMapNullKey[0] (batchId=182)
org.apache.hive.hcatalog.pig.TestHCatLoaderComplexSchema.testMapNullKey[1] (batchId=182)
org.apache.hive.hcatalog.pig.TestHCatLoaderComplexSchema.testMapNullKey[2] (batchId=182)
org.apache.hive.hcatalog.pig.TestHCatLoaderComplexSchema.testMapWithComplexData[0] (batchId=182)
org.apache.hive.hcatalog.pig.TestHCatLoaderComplexSchema.testMapWithComplexData[1] (batchId=182)
org.apache.hive.hcatalog.pig.TestHCatLoaderComplexSchema.testMapWithComplexData[2] (batchId=182)
org.apache.hive.hcatalog.pig.TestHCatLoaderComplexSchema.testSyntheticComplexSchema[0] (batchId=182)
org.apache.hive.hcatalog.pig.TestHCatLoaderComplexSchema.testSyntheticComplexSchema[1] (batchId=182)
org.apache.hive.hcatalog.pig.TestHCatLoaderComplexSchema.testSyntheticComplexSchema[2] (batchId=182)
org.apache.hive.hcatalog.pig.TestHCatLoaderComplexSchema.testTupleInBagInTupleInBag[0] (batchId=182)
org.apache.hive.hcatalog.pig.TestHCatLoaderComplexSchema.testTupleInBagInTupleInBag[1] (batchId=182)
org.apache.hive.hcatalog.pig.TestHCatLoaderComplexSchema.testTupleInBagInTupleInBag[2] (batchId=182)
org.apache.hive.hcatalog.pig.TestHCatLoaderEncryption.testReadDataFromEncryptedHiveTableByHCatMR[0] (batchId=182)
org.apache.hive.hcatalog.pig.TestHCatLoaderEncryption.testReadDataFromEncryptedHiveTableByHCatMR[1] (batchId=182)
org.apache.hive.hcatalog.pig.TestHCatLoaderEncryption.testReadDataFromEncryptedHiveTableByHCatMR[2] (batchId=182)
org.apache.hive.hcatalog.pig.TestHCatLoaderEncryption.testReadDataFromEncryptedHiveTableByHCatMR[3] (batchId=182)
org.apache.hive.hcatalog.pig.TestHCatLoaderEncryption.testReadDataFromEncryptedHiveTableByHCatMR[4] (batchId=182)
org.apache.hive.hcatalog.pig.TestHCatLoaderEncryption.testReadDataFromEncryptedHiveTableByHCatMR[5] (batchId=182)
org.apache.hive.hcatalog.pig.TestHCatLoaderEncryption.testReadDataFromEncryptedHiveTableByPig[0] (batchId=182)
org.apache.hive.hcatalog.pig.TestHCatLoaderEncryption.testReadDataFromEncryptedHiveTableByPig[1] (batchId=182)
org.apache.hive.hcatalog.pig.TestHCatLoaderEncryption.testReadDataFromEncryptedHiveTableByPig[2] (batchId=182)
org.apache.hive.hcatalog.pig.TestHCatLoaderEncryption.testReadDataFromEncryptedHiveTableByPig[3] (batchId=182)
org.apache.hive.hcatalog.pig.TestHCatLoaderEncryption.testReadDataFromEncryptedHiveTableByPig[4] (batchId=182)
org.apache.hive.hcatalog.pig.TestHCatLoaderEncryption.testReadDataFromEncryptedHiveTableByPig[5] (batchId=182)
org.apache.hive.hcatalog.pig.TestHCatLoaderStorer.testReadWrite (batchId=182)
org.apache.hive.hcatalog.pig.TestHCatLoaderStorer.testSmallTinyInt (batchId=182)
org.apache.hive.hcatalog.pig.TestHCatStorerMulti.testStoreBasicTable[0] (batchId=182)
org.apache.hive.hcatalog.pig.TestHCatStorerMulti.testStoreBasicTable[1] (batchId=182)
org.apache.hive.hcatalog.pig.TestHCatStorerMulti.testStoreBasicTable[2] (batchId=182)
org.apache.hive.hcatalog.pig.TestHCatStorerMulti.testStorePartitionedTable[0] (batchId=182)
org.apache.hive.hcatalog.pig.TestHCatStorerMulti.testStorePartitionedTable[1] (batchId=182)
org.apache.hive.hcatalog.pig.TestHCatStorerMulti.testStorePartitionedTable[2] (batchId=182)
org.apache.hive.hcatalog.pig.TestHCatStorerMulti.testStoreTableMulti[0] (batchId=182)
org.apache.hive.hcatalog.pig.TestHCatStorerMulti.testStoreTableMulti[1] (batchId=182)
org.apache.hive.hcatalog.pig.TestHCatStorerMulti.testStoreTableMulti[2] (batchId=182)
org.apache.hive.hcatalog.pig.TestHCatStorerWrapper.testStoreExternalTableWithExternalDir (batchId=182)
org.apache.hive.hcatalog.pig.TestOrcHCatLoader.testConvertBooleanToInt (batchId=182)
org.apache.hive.hcatalog.pig.TestOrcHCatLoader.testReadDataPrimitiveTypes (batchId=182)
org.apache.hive.hcatalog.pig.TestOrcHCatStorer.testStoreMultiTables (batchId=182)
org.apache.hive.hcatalog.pig.TestParquetHCatLoader.testConvertBooleanToInt (batchId=182)
org.apache.hive.hcatalog.pig.TestParquetHCatLoader.testReadDataPrimitiveTypes (batchId=182)
org.apache.hive.hcatalog.pig.TestParquetHCatStorer.testStoreMultiTables (batchId=182)
org.apache.hive.hcatalog.pig.TestRCFileHCatLoader.testColumnarStorePushdown2 (batchId=182)
org.apache.hive.hcatalog.pig.TestRCFileHCatLoader.testConvertBooleanToInt (batchId=182)
org.apache.hive.hcatalog.pig.TestRCFileHCatLoader.testDatePartitionPushUp (batchId=182)
org.apache.hive.hcatalog.pig.TestRCFileHCatLoader.testProjectionsBasic (batchId=182)
org.apache.hive.hcatalog.pig.TestRCFileHCatLoader.testReadDataBasic (batchId=182)
org.apache.hive.hcatalog.pig.TestRCFileHCatLoader.testReadDataPrimitiveTypes (batchId=182)
org.apache.hive.hcatalog.pig.TestRCFileHCatLoader.testReadPartitionedBasic (batchId=182)
org.apache.hive.hcatalog.pig.TestRCFileHCatStorer.testBagNStruct (batchId=182)
org.apache.hive.hcatalog.pig.TestRCFileHCatStorer.testDateCharTypes (batchId=182)
org.apache.hive.hcatalog.pig.TestRCFileHCatStorer.testDynamicPartitioningMultiPartColsInDataNoSpec (batchId=182)
org.apache.hive.hcatalog.pig.TestRCFileHCatStorer.testDynamicPartitioningMultiPartColsInDataPartialSpec (batchId=182)
org.apache.hive.hcatalog.pig.TestRCFileHCatStorer.testMultiPartColsInData (batchId=182)
org.apache.hive.hcatalog.pig.TestRCFileHCatStorer.testPartColsInData (batchId=182)
org.apache.hive.hcatalog.pig.TestRCFileHCatStorer.testStoreFuncAllSimpleTypes (batchId=182)
org.apache.hive.hcatalog.pig.TestRCFileHCatStorer.testStoreFuncSimple (batchId=182)
org.apache.hive.hcatalog.pig.TestRCFileHCatStorer.testStoreInPartiitonedTbl (batchId=182)
org.apache.hive.hcatalog.pig.TestRCFileHCatStorer.testStoreMultiTables (batchId=182)
org.apache.hive.hcatalog.pig.TestRCFileHCatStorer.testStoreWithNoCtorArgs (batchId=182)
org.apache.hive.hcatalog.pig.TestRCFileHCatStorer.testStoreWithNoSchema (batchId=182)
org.apache.hive.hcatalog.pig.TestRCFileHCatStorer.testWriteChar (batchId=182)
org.apache.hive.hcatalog.pig.TestRCFileHCatStorer.testWriteDate (batchId=182)
org.apache.hive.hcatalog.pig.TestRCFileHCatStorer.testWriteDate2 (batchId=182)
org.apache.hive.hcatalog.pig.TestRCFileHCatStorer.testWriteDate3 (batchId=182)
org.apache.hive.hcatalog.pig.TestRCFileHCatStorer.testWriteDecimal (batchId=182)
org.apache.hive.hcatalog.pig.TestRCFileHCatStorer.testWriteDecimalX (batchId=182)
org.apache.hive.hcatalog.pig.TestRCFileHCatStorer.testWriteDecimalXY (batchId=182)
org.apache.hive.hcatalog.pig.TestRCFileHCatStorer.testWriteSmallint (batchId=182)
org.apache.hive.hcatalog.pig.TestRCFileHCatStorer.testWriteTimestamp (batchId=182)
org.apache.hive.hcatalog.pig.TestRCFileHCatStorer.testWriteTinyint (batchId=182)
org.apache.hive.hcatalog.pig.TestRCFileHCatStorer.testWriteVarchar (batchId=182)
org.apache.hive.hcatalog.pig.TestSequenceFileHCatLoader.testColumnarStorePushdown2 (batchId=182)
org.apache.hive.hcatalog.pig.TestSequenceFileHCatLoader.testConvertBooleanToInt (batchId=182)
org.apache.hive.hcatalog.pig.TestSequenceFileHCatLoader.testDatePartitionPushUp (batchId=182)
org.apache.hive.hcatalog.pig.TestSequenceFileHCatLoader.testProjectionsBasic (batchId=182)
org.apache.hive.hcatalog.pig.TestSequenceFileHCatLoader.testReadDataBasic (batchId=182)
org.apache.hive.hcatalog.pig.TestSequenceFileHCatLoader.testReadDataPrimitiveTypes (batchId=182)
org.apache.hive.hcatalog.pig.TestSequenceFileHCatLoader.testReadPartitionedBasic (batchId=182)
org.apache.hive.hcatalog.pig.TestSequenceFileHCatStorer.testBagNStruct (batchId=182)
org.apache.hive.hcatalog.pig.TestSequenceFileHCatStorer.testDateCharTypes (batchId=182)
org.apache.hive.hcatalog.pig.TestSequenceFileHCatStorer.testDynamicPartitioningMultiPartColsInDataNoSpec (batchId=182)
org.apache.hive.hcatalog.pig.TestSequenceFileHCatStorer.testDynamicPartitioningMultiPartColsInDataPartialSpec (batchId=182)
org.apache.hive.hcatalog.pig.TestSequenceFileHCatStorer.testMultiPartColsInData (batchId=182)
org.apache.hive.hcatalog.pig.TestSequenceFileHCatStorer.testPartColsInData (batchId=182)
org.apache.hive.hcatalog.pig.TestSequenceFileHCatStorer.testStoreFuncAllSimpleTypes (batchId=182)
org.apache.hive.hcatalog.pig.TestSequenceFileHCatStorer.testStoreFuncSimple (batchId=182)
org.apache.hive.hcatalog.pig.TestSequenceFileHCatStorer.testStoreInPartiitonedTbl (batchId=182)
org.apache.hive.hcatalog.pig.TestSequenceFileHCatStorer.testStoreMultiTables (batchId=182)
org.apache.hive.hcatalog.pig.TestSequenceFileHCatStorer.testStoreWithNoCtorArgs (batchId=182)
org.apache.hive.hcatalog.pig.TestSequenceFileHCatStorer.testStoreWithNoSchema (batchId=182)
org.apache.hive.hcatalog.pig.TestSequenceFileHCatStorer.testWriteChar (batchId=182)
org.apache.hive.hcatalog.pig.TestSequenceFileHCatStorer.testWriteDate (batchId=182)
org.apache.hive.hcatalog.pig.TestSequenceFileHCatStorer.testWriteDate2 (batchId=182)
org.apache.hive.hcatalog.pig.TestSequenceFileHCatStorer.testWriteDate3 (batchId=182)
org.apache.hive.hcatalog.pig.TestSequenceFileHCatStorer.testWriteDecimal (batchId=182)
org.apache.hive.hcatalog.pig.TestSequenceFileHCatStorer.testWriteDecimalX (batchId=182)
org.apache.hive.hcatalog.pig.TestSequenceFileHCatStorer.testWriteDecimalXY (batchId=182)
org.apache.hive.hcatalog.pig.TestSequenceFileHCatStorer.testWriteSmallint (batchId=182)
org.apache.hive.hcatalog.pig.TestSequenceFileHCatStorer.testWriteTimestamp (batchId=182)
org.apache.hive.hcatalog.pig.TestSequenceFileHCatStorer.testWriteTinyint (batchId=182)
org.apache.hive.hcatalog.pig.TestSequenceFileHCatStorer.testWriteVarchar (batchId=182)
org.apache.hive.hcatalog.pig.TestTextFileHCatLoader.testColumnarStorePushdown2 (batchId=182)
org.apache.hive.hcatalog.pig.TestTextFileHCatLoader.testConvertBooleanToInt (batchId=182)
org.apache.hive.hcatalog.pig.TestTextFileHCatLoader.testDatePartitionPushUp (batchId=182)
org.apache.hive.hcatalog.pig.TestTextFileHCatLoader.testProjectionsBasic (batchId=182)
org.apache.hive.hcatalog.pig.TestTextFileHCatLoader.testReadDataBasic (batchId=182)
org.apache.hive.hcatalog.pig.TestTextFileHCatLoader.testReadDataPrimitiveTypes (batchId=182)
org.apache.hive.hcatalog.pig.TestTextFileHCatLoader.testReadPartitionedBasic (batchId=182)
org.apache.hive.hcatalog.pig.TestTextFileHCatStorer.testBagNStruct (batchId=182)
org.apache.hive.hcatalog.pig.TestTextFileHCatStorer.testDateCharTypes (batchId=182)
org.apache.hive.hcatalog.pig.TestTextFileHCatStorer.testDynamicPartitioningMultiPartColsInDataNoSpec (batchId=182)
org.apache.hive.hcatalog.pig.TestTextFileHCatStorer.testDynamicPartitioningMultiPartColsInDataPartialSpec (batchId=182)
org.apache.hive.hcatalog.pig.TestTextFileHCatStorer.testMultiPartColsInData (batchId=182)
org.apache.hive.hcatalog.pig.TestTextFileHCatStorer.testPartColsInData (batchId=182)
org.apache.hive.hcatalog.pig.TestTextFileHCatStorer.testStoreFuncAllSimpleTypes (batchId=182)
org.apache.hive.hcatalog.pig.TestTextFileHCatStorer.testStoreFuncSimple (batchId=182)
org.apache.hive.hcatalog.pig.TestTextFileHCatStorer.testStoreInPartiitonedTbl (batchId=182)
org.apache.hive.hcatalog.pig.TestTextFileHCatStorer.testStoreMultiTables (batchId=182)
org.apache.hive.hcatalog.pig.TestTextFileHCatStorer.testStoreWithNoCtorArgs (batchId=182)
org.apache.hive.hcatalog.pig.TestTextFileHCatStorer.testStoreWithNoSchema (batchId=182)
org.apache.hive.hcatalog.pig.TestTextFileHCatStorer.testWriteChar (batchId=182)
org.apache.hive.hcatalog.pig.TestTextFileHCatStorer.testWriteDate (batchId=182)
org.apache.hive.hcatalog.pig.TestTextFileHCatStorer.testWriteDate2 (batchId=182)
org.apache.hive.hcatalog.pig.TestTextFileHCatStorer.testWriteDate3 (batchId=182)
org.apache.hive.hcatalog.pig.TestTextFileHCatStorer.testWriteDecimal (batchId=182)
org.apache.hive.hcatalog.pig.TestTextFileHCatStorer.testWriteDecimalX (batchId=182)
org.apache.hive.hcatalog.pig.TestTextFileHCatStorer.testWriteDecimalXY (batchId=182)
org.apache.hive.hcatalog.pig.TestTextFileHCatStorer.testWriteSmallint (batchId=182)
org.apache.hive.hcatalog.pig.TestTextFileHCatStorer.testWriteTimestamp (batchId=182)
org.apache.hive.hcatalog.pig.TestTextFileHCatStorer.testWriteTinyint (batchId=182)
org.apache.hive.hcatalog.pig.TestTextFileHCatStorer.testWriteVarchar (batchId=182)
{noformat}

Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/6131/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/6131/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-6131/

Messages:
{noformat}
Executing org.apache.hive.ptest.execution.TestCheckPhase
Executing org.apache.hive.ptest.execution.PrepPhase
Executing org.apache.hive.ptest.execution.ExecutionPhase
Executing org.apache.hive.ptest.execution.ReportingPhase
Tests exited with: TestsFailedException: 309 tests failed
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12878853 - PreCommit-HIVE-Build

> Support "set local time zone" statement
> ---------------------------------------
>
>                 Key: HIVE-16614
>                 URL: https://issues.apache.org/jira/browse/HIVE-16614
>             Project: Hive
>          Issue Type: Improvement
>            Reporter: Carter Shanklin
>            Assignee: Jesus Camacho Rodriguez
>         Attachments: HIVE-16614.01.patch, HIVE-16614.02.patch, HIVE-16614.patch
>
>
> HIVE-14412 introduces a timezone-aware timestamp.
> SQL has a concept of default time zone displacements, which are transparently applied when converting between timezone-unaware types and timezone-aware types and, in Hive's case, are also used to shift a timezone aware type to a different time zone, depending on configuration.
> SQL also provides that the default time zone displacement be settable at a session level, so that clients can access a database simultaneously from different time zones and see time values in their own time zone.
> Currently the time zone displacement is fixed and is set based on the system time zone where the Hive client runs (HiveServer2 or Hive CLI). It will be more convenient for users if they have the ability to set their time zone of choice.
> SQL defines "set time zone" with 2 ways of specifying the time zone, first using an interval and second using the special keyword LOCAL.
> Examples:
> 	• set time zone '-8:00';
> 	• set time zone LOCAL;
> LOCAL means to set the current default time zone displacement to the session's original default time zone displacement.
> Reference: SQL:2011 section 19.4



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)