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

Aihua Xu commented on HIVE-14162:
---------------------------------

Such requirement can be achieved by the following configuration properties.

hive.server2.session.check.interval
hive.server2.idle.session.check.operation
hive.server2.idle.session.timeout

With those properties being set, a background thread will check if the session 
is idle for enough time and if there are no active/pending operations. 
HiveSession will get closed if it's true and the associated SparkSession also 
gets closed to release the resources. 

> Allow disabling of long running job on Hive On Spark On YARN
> ------------------------------------------------------------
>
>                 Key: HIVE-14162
>                 URL: https://issues.apache.org/jira/browse/HIVE-14162
>             Project: Hive
>          Issue Type: New Feature
>          Components: Spark
>            Reporter: Thomas Scott
>            Assignee: Aihua Xu
>            Priority: Minor
>         Attachments: HIVE-14162.1.patch
>
>
> Hive On Spark launches a long running process on the first query to handle 
> all queries for that user session. In some use cases this is not desired, for 
> instance when using Hue with large intervals between query executions.
> Could we have a property that would cause long running spark jobs to be 
> terminated after each query execution and started again for the next one?



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

Reply via email to