[
https://issues.apache.org/jira/browse/HIVE-18430?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16322526#comment-16322526
]
Hive QA commented on HIVE-18430:
--------------------------------
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12905562/HIVE-18430.1.patch
{color:green}SUCCESS:{color} +1 due to 1 test(s) being added or modified.
{color:red}ERROR:{color} -1 due to 67 failed/errored test(s), 11552 tests
executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[auto_join25] (batchId=72)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[autogen_colalias]
(batchId=27)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[dynpart_sort_opt_bucketing]
(batchId=85)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[mapjoin_hook]
(batchId=12)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[ppd_join5] (batchId=35)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[udf_current_database]
(batchId=66)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[udf_logged_in_user]
(batchId=5)
org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[orc_ppd_basic]
(batchId=146)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[bucket_map_join_tez1]
(batchId=169)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[bucketsortoptimize_insert_2]
(batchId=151)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[current_date_timestamp]
(batchId=161)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[hybridgrace_hashjoin_2]
(batchId=156)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[insert_values_orig_table_use_metadata]
(batchId=164)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[llap_acid]
(batchId=168)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[llap_acid_fast]
(batchId=159)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[sysdb]
(batchId=159)
org.apache.hadoop.hive.cli.TestNegativeCliDriver.testCliDriver[authorization_part]
(batchId=93)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[ppd_join5]
(batchId=120)
org.apache.hadoop.hive.cli.TestSparkPerfCliDriver.testCliDriver[query39]
(batchId=247)
org.apache.hadoop.hive.metastore.TestEmbeddedHiveMetaStore.testTransactionalValidation
(batchId=213)
org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testAlterPartition
(batchId=211)
org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testAlterTable
(batchId=211)
org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testAlterTableCascade
(batchId=211)
org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testAlterViewParititon
(batchId=211)
org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testColumnStatistics
(batchId=211)
org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testComplexTable
(batchId=211)
org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testComplexTypeApi
(batchId=211)
org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testConcurrentMetastores
(batchId=211)
org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testDBLocationChange
(batchId=211)
org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testDBOwner
(batchId=211)
org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testDBOwnerChange
(batchId=211)
org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testDatabase
(batchId=211)
org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testDatabaseLocation
(batchId=211)
org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testDatabaseLocationWithPermissionProblems
(batchId=211)
org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testDropTable
(batchId=211)
org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testFilterLastPartition
(batchId=211)
org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testFilterSinglePartition
(batchId=211)
org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testFunctionWithResources
(batchId=211)
org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testGetConfigValue
(batchId=211)
org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testGetMetastoreUuid
(batchId=211)
org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testGetSchemaWithNoClassDefFoundError
(batchId=211)
org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testGetTableObjects
(batchId=211)
org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testGetUUIDInParallel
(batchId=211)
org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testJDOPersistanceManagerCleanup
(batchId=211)
org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testListPartitionNames
(batchId=211)
org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testListPartitions
(batchId=211)
org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testListPartitionsWihtLimitEnabled
(batchId=211)
org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testNameMethods
(batchId=211)
org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testPartition
(batchId=211)
org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testPartitionFilter
(batchId=211)
org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testRenamePartition
(batchId=211)
org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testRetriableClientWithConnLifetime
(batchId=211)
org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testSimpleFunction
(batchId=211)
org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testSimpleTable
(batchId=211)
org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testSimpleTypeApi
(batchId=211)
org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testStatsFastTrivial
(batchId=211)
org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testSynchronized
(batchId=211)
org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testTableDatabase
(batchId=211)
org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testTableFilter
(batchId=211)
org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testTransactionalValidation
(batchId=211)
org.apache.hadoop.hive.metastore.TestSetUGIOnBothClientServer.testValidateTableCols
(batchId=211)
org.apache.hadoop.hive.ql.io.TestDruidRecordWriter.testWrite (batchId=253)
org.apache.hadoop.hive.ql.parse.TestReplicationScenarios.testConstraints
(batchId=225)
org.apache.hive.beeline.TestBeeLineWithArgs.testConnectionWithURLParams
(batchId=228)
org.apache.hive.jdbc.TestSSL.testConnectionMismatch (batchId=231)
org.apache.hive.jdbc.TestSSL.testConnectionWrongCertCN (batchId=231)
org.apache.hive.jdbc.TestSSL.testMetastoreConnectionWrongCertCN (batchId=231)
{noformat}
Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/8571/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/8571/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-8571/
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: 67 tests failed
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12905562 - PreCommit-HIVE-Build
> Add new determinism category for runtime constants (current_date,
> current_timestamp)
> ------------------------------------------------------------------------------------
>
> Key: HIVE-18430
> URL: https://issues.apache.org/jira/browse/HIVE-18430
> Project: Hive
> Issue Type: Bug
> Components: UDF
> Reporter: Jason Dere
> Assignee: Jason Dere
> Attachments: HIVE-18430.1.patch
>
>
> Add a new piece of metadata to the UDFs to specify if whether a UDF is a
> runtime constant. Runtime constants also exist in SQL Server, and this is
> similar to Postgres' concept of STABLE functions. This metadata may be useful
> for materialized views and query caching.
> Some Hive functions such as the ones listed below are currently labelled as
> deterministic, but really are runtime constants:
> current_timestamp
> current_date
> current_user
> current_database
> The values for these functions are not deterministic between different
> queries - for example current_timestamp will most likely be different every
> query executed. This makes these functions ineligible for things like
> materialized views or cached query results.
> However the value for the current_timestamp should not change during the life
> of a single query, which allows these values to be used in optimizations such
> as constant folding.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
