[jira] [Commented] (HIVE-11402) HS2 - disallow parallel query execution within a single Session

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

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

Hive QA commented on HIVE-11402:
--------------------------------



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

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

{color:red}ERROR:{color} -1 due to 7 failed/errored test(s), 10287 tests executed
*Failed tests:*
{noformat}
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_list_bucket_dml_12
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_stats_list_bucket
org.apache.hadoop.hive.cli.TestCliDriver.testCliDriver_subquery_multiinsert
org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver_vector_complex_all
org.apache.hadoop.hive.cli.TestMiniLlapCliDriver.testCliDriver_vector_complex_join
org.apache.hadoop.hive.llap.tezplugins.TestLlapTaskSchedulerService.testDelayedLocalityNodeCommErrorImmediateAllocation
org.apache.hive.spark.client.TestSparkClient.testJobSubmission
{noformat}

Test results: https://builds.apache.org/job/PreCommit-HIVE-MASTER-Build/335/testReport
Console output: https://builds.apache.org/job/PreCommit-HIVE-MASTER-Build/335/console
Test logs: http://ec2-50-18-27-0.us-west-1.compute.amazonaws.com/logs/PreCommit-HIVE-MASTER-Build-335/

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: 7 tests failed
{noformat}

This message is automatically generated.

ATTACHMENT ID: 12815513 - PreCommit-HIVE-MASTER-Build

> HS2 - disallow parallel query execution within a single Session
> ---------------------------------------------------------------
>
>                 Key: HIVE-11402
>                 URL: https://issues.apache.org/jira/browse/HIVE-11402
>             Project: Hive
>          Issue Type: Bug
>          Components: HiveServer2
>            Reporter: Thejas M Nair
>            Assignee: Sergey Shelukhin
>         Attachments: HIVE-11402.01.patch, HIVE-11402.02.patch, HIVE-11402.patch
>
>
> HiveServer2 currently allows concurrent queries to be run in a single session. However, every HS2 session has  an associated SessionState object, and the use of SessionState in many places assumes that only one thread is using it, ie it is not thread safe.
> There are many places where SesssionState thread safety needs to be addressed, and until then we should serialize all query execution for a single HS2 session. -This problem can become more visible with HIVE-4239 now allowing parallel query compilation.-
> Note that running queries in parallel for single session is not straightforward  with jdbc, you need to spawn another thread as the Statement.execute calls are blocking. I believe ODBC has non blocking query execution API, and Hue is another well known application that shares sessions for all queries that a user runs.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)