[ 
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 become to a not 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:
{coed}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 become to a not available status!  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Reply via email to