[
https://issues.apache.org/jira/browse/HIVE-21190?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
kongxianghe updated HIVE-21190:
-------------------------------
Description:
# cause by an error UDF function！time_waiting(Long sleepSeconds)
{code}
public class UDFTimeWaiting extends UDF throws Exception{
public String evaluate(Long sleepSeconds){
...
Thread.sleep(Long.parseLong(sleepSeconds) * 1000);
return "ok";
}
}
{code}
# in session_1:
{code}select time_waiting(100);{code}
# in session_2:
{code}select 1; or show tables;{code}
# session_2 will not have any response from thrift server util session_1
waiting 100 seconds!
this bug may cause hiveserver can into an available status!
was:
# cause by an error UDF function！time_waiting(Long sleepSeconds)
{code}
public class UDFTimeWaiting extends UDF throws Exception{
public String evaluate(Long sleepSeconds){
...
Thread.sleep(Long.parseLong(sleepSeconds) * 1000);
return "ok";
}
}
{code}
# in session_1:
{code}select time_waiting(100);{code}
# in session_2:
{code}select 1; or show tables;{code}
# session_2 will not have any response from thrift server util session_1
waiting 100 seconds!
this bug may cause hiveserver become to a not available status!
> hive thrift server may be blocked by session level waiting!
> -----------------------------------------------------------
>
> Key: HIVE-21190
> URL: https://issues.apache.org/jira/browse/HIVE-21190
> Project: Hive
> Issue Type: Bug
> Components: HiveServer2
> Environment: hdp ambari 26
> hive1.2.0
> Reporter: kongxianghe
> Assignee: kongxianghe
> Priority: Critical
>
> # cause by an error UDF function！time_waiting(Long sleepSeconds)
> {code}
> public class UDFTimeWaiting extends UDF throws Exception{
> public String evaluate(Long sleepSeconds){
> ...
> Thread.sleep(Long.parseLong(sleepSeconds) * 1000);
> return "ok";
> }
> }
> {code}
> # in session_1:
> {code}select time_waiting(100);{code}
> # in session_2:
> {code}select 1; or show tables;{code}
> # session_2 will not have any response from thrift server util session_1
> waiting 100 seconds!
> this bug may cause hiveserver can into an available status!
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
