[
https://issues.apache.org/jira/browse/HIVE-18638?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16365326#comment-16365326
]
Hive QA commented on HIVE-18638:
--------------------------------
Here are the results of testing the latest attachment:
https://issues.apache.org/jira/secure/attachment/12910665/HIVE-18638.1.patch
{color:red}ERROR:{color} -1 due to no test(s) being added or modified.
{color:red}ERROR:{color} -1 due to 25 failed/errored test(s), 13103 tests
executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestAccumuloCliDriver.testCliDriver[accumulo_queries]
(batchId=240)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[mapjoin_hook]
(batchId=12)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[ppd_join5] (batchId=36)
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver[row__id] (batchId=78)
org.apache.hadoop.hive.cli.TestEncryptedHDFSCliDriver.testCliDriver[encryption_move_tbl]
(batchId=174)
org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver[llap_smb]
(batchId=151)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[insert_values_orig_table_use_metadata]
(batchId=166)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[llap_acid]
(batchId=170)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[llap_acid_fast]
(batchId=161)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[resourceplan]
(batchId=163)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[results_cache_1]
(batchId=167)
org.apache.hadoop.hive.cli.TestMiniLlapLocalCliDriver.testCliDriver[sysdb]
(batchId=160)
org.apache.hadoop.hive.cli.TestSparkCliDriver.testCliDriver[ppd_join5]
(batchId=121)
org.apache.hadoop.hive.cli.control.TestDanglingQOuts.checkDanglingQOut
(batchId=221)
org.apache.hadoop.hive.metastore.client.TestTablesList.testListTableNamesByFilterNullDatabase[Embedded]
(batchId=205)
org.apache.hadoop.hive.ql.TestAcidOnTez.testGetSplitsLocks (batchId=224)
org.apache.hive.beeline.cli.TestHiveCli.testNoErrorDB (batchId=187)
org.apache.hive.hcatalog.listener.TestDbNotificationListener.alterIndex
(batchId=242)
org.apache.hive.hcatalog.listener.TestDbNotificationListener.createIndex
(batchId=242)
org.apache.hive.hcatalog.listener.TestDbNotificationListener.dropIndex
(batchId=242)
org.apache.hive.jdbc.TestJdbcWithMiniLlap.testLlapInputFormatEndToEnd
(batchId=235)
org.apache.hive.jdbc.TestSSL.testConnectionMismatch (batchId=234)
org.apache.hive.jdbc.TestSSL.testConnectionWrongCertCN (batchId=234)
org.apache.hive.jdbc.TestSSL.testMetastoreConnectionWrongCertCN (batchId=234)
org.apache.hive.jdbc.TestTriggersMoveWorkloadManager.testTriggerMoveBackKill
(batchId=235)
{noformat}
Test results: https://builds.apache.org/job/PreCommit-HIVE-Build/9227/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-Build/9227/console
Test logs: http://104.198.109.242/logs/PreCommit-HIVE-Build-9227/
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: 25 tests failed
{noformat}
This message is automatically generated.
ATTACHMENT ID: 12910665 - PreCommit-HIVE-Build
> Triggers for multi-pool move, failing to initiate the move event
> ----------------------------------------------------------------
>
> Key: HIVE-18638
> URL: https://issues.apache.org/jira/browse/HIVE-18638
> Project: Hive
> Issue Type: Bug
> Components: HiveServer2
> Affects Versions: 3.0.0
> Reporter: Aswathy Chellammal Sreekumar
> Assignee: Prasanth Jayachandran
> Priority: Major
> Attachments: HIVE-18638.1.patch
>
>
> Resource plan with multiple pools and trigger set to move job across those
> pools seems to be failing to do so
> Resource plan:
> {noformat}
> 1: jdbc:hive2://ctr-e137-1514896590304-51538-> show resource plan plan_2;
> INFO : Compiling
> command(queryId=hive_20180202220823_2fb8bca7-5b7a-48cf-8ff9-8d5f3548d334):
> show resource plan plan_2 INFO : Semantic Analysis Completed INFO : Returning
> Hive schema: Schema(fieldSchemas:[FieldSchema(name:line, type:string,
> comment:from deserializer)], properties:null) INFO : Completed compiling
> command(queryId=hive_20180202220823_2fb8bca7-5b7a-48cf-8ff9-8d5f3548d334);
> Time taken: 0.008 seconds INFO : Executing
> command(queryId=hive_20180202220823_2fb8bca7-5b7a-48cf-8ff9-8d5f3548d334):
> show resource plan plan_2 INFO : Starting task [Stage-0:DDL] in serial mode
> INFO : Completed executing
> command(queryId=hive_20180202220823_2fb8bca7-5b7a-48cf-8ff9-8d5f3548d334);
> Time taken: 0.196 seconds INFO : OK
> +----------------------------------------------------+ | line |
> +----------------------------------------------------+ |
> plan_2[status=ACTIVE,parallelism=null,defaultPool=pool2] | | +
> pool2[allocFraction=0.5,schedulingPolicy=default,parallelism=3] | | | trigger
> too_large_write_triger: if (HDFS_BYTES_WRITTEN > 10kb) { MOVE TO pool1 } | |
> | mapped for default | | +
> pool1[allocFraction=0.3,schedulingPolicy=default,parallelism=5] | | | trigger
> slow_pool_trigger: if (ELAPSED_TIME > 30000) { MOVE TO pool3 } | | +
> pool3[allocFraction=0.2,schedulingPolicy=default,parallelism=3] | | +
> default[allocFraction=0.0,schedulingPolicy=null,parallelism=4] |
> +----------------------------------------------------+ 8 rows selected (0.25
> seconds)
> {noformat}
> Workload Manager Events Summary from query run:
> {noformat}
> INFO : {
> "queryId" : "hive_20180202213425_9633d7af-4242-4e95-a391-2cd3823e3eac",
> "queryStartTime" : 1517607265395,
> "queryEndTime" : 1517607321648,
> "queryCompleted" : true,
> "queryWmEvents" : [ {
> "wmTezSessionInfo" : {
> "sessionId" : "21f8a4ab-511e-4828-a2dd-1d5f2932c492",
> "poolName" : "pool2",
> "clusterPercent" : 50.0
> },
> "eventStartTimestamp" : 1517607269660,
> "eventEndTimestamp" : 1517607269661,
> "eventType" : "GET",
> "elapsedTime" : 1
> }, {
> "wmTezSessionInfo" : {
> "sessionId" : "21f8a4ab-511e-4828-a2dd-1d5f2932c492",
> "poolName" : null,
> "clusterPercent" : 0.0
> },
> "eventStartTimestamp" : 1517607321663,
> "eventEndTimestamp" : 1517607321663,
> "eventType" : "RETURN",
> "elapsedTime" : 0
> } ],
> "appliedTriggers" : [ {
> "name" : "too_large_write_triger",
> "expression" : {
> "counterLimit" : {
> "limit" : 10240,
> "name" : "HDFS_BYTES_WRITTEN"
> },
> "predicate" : "GREATER_THAN"
> },
> "action" : {
> "type" : "MOVE_TO_POOL",
> "poolName" : "pool1"
> },
> "violationMsg" : null
> } ],
> "subscribedCounters" : [ "HDFS_BYTES_WRITTEN" ],
> "currentCounters" : {
> "HDFS_BYTES_WRITTEN" : 33306829
> },
> "elapsedTime" : 56284
> }
> {noformat}
> From the Workload Manager Event Summary it could seen that the 'MOVE' event
> didn't happen though the limit for counter (10240) HDFS_BYTES_WRITTEN was
> exceeded
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
