[jira] [Commented] (HIVE-23802) “merge files” job was submited to default queue when set hive.merge.tezfiles to true

2024-04-10 Thread kongxianghe (Jira)


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

kongxianghe commented on HIVE-23802:


try this  hive.server2.tez.default.queues?

> “merge files” job was submited to default queue when set hive.merge.tezfiles 
> to true
> 
>
> Key: HIVE-23802
> URL: https://issues.apache.org/jira/browse/HIVE-23802
> Project: Hive
>  Issue Type: Bug
>  Components: HiveServer2
>Affects Versions: 3.1.0
>Reporter: gaozhan ding
>Assignee: gaozhan ding
>Priority: Major
>  Labels: pull-request-available
> Attachments: 15940042679272.png, HIVE-23802.patch
>
>  Time Spent: 0.5h
>  Remaining Estimate: 0h
>
> We use tez as the query engine. When hive.merge.tezfiles  set to true,merge 
> files task,  which followed by orginal task,  will be submit to default queue 
> rather then the queue same with orginal task.
> I study this issue for days and found that, every time starting a container, 
> "tez,queue.name" whill be unset in current session. Code are as below:
> {code:java}
> // TezSessionState.startSessionAndContainers()
> // sessionState.getQueueName() comes from cluster wide configured queue names.
>  // sessionState.getConf().get("tez.queue.name") is explicitly set by user in 
> a session.
>  // TezSessionPoolManager sets tez.queue.name if user has specified one or 
> use the one from
>  // cluster wide queue names.
>  // There is no way to differentiate how this was set (user vs system).
>  // Unset this after opening the session so that reopening of session uses 
> the correct queue
>  // names i.e, if client has not died and if the user has explicitly set a 
> queue name
>  // then reopened session will use user specified queue name else default 
> cluster queue names.
>  conf.unset(TezConfiguration.TEZ_QUEUE_NAME);
> {code}
> So after the orgin task was submited to yarn, "tez.queue.name" will be unset. 
> While starting merge file task, it will try use the same session with orgin 
> job, but get false due to tez.queue.name was unset. Seems like we could not 
> unset this property.
> {code:java}
> // TezSessionPoolManager.canWorkWithSameSession()
> if (!session.isDefault()) {
>   String queueName = session.getQueueName();
>   String confQueueName = conf.get(TezConfiguration.TEZ_QUEUE_NAME);
>   LOG.info("Current queue name is " + queueName + " incoming queue name is " 
> + confQueueName);
>   return (queueName == null) ? confQueueName == null : 
> queueName.equals(confQueueName);
> } else {
>   // this session should never be a default session unless something has 
> messed up.
>   throw new HiveException("The pool session " + session + " should have been 
> returned to the pool"); 
> }
> {code}
>    !15940042679272.png!
>  
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)


[jira] [Resolved] (HIVE-17462) hive_1.2.1 hiveserver2 memory leak

2020-09-21 Thread kongxianghe (Jira)


 [ 
https://issues.apache.org/jira/browse/HIVE-17462?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

kongxianghe resolved HIVE-17462.

Fix Version/s: 1.2.1
   Resolution: Won't Fix

won‘t fix.

> hive_1.2.1  hiveserver2  memory leak
> 
>
> Key: HIVE-17462
> URL: https://issues.apache.org/jira/browse/HIVE-17462
> Project: Hive
>  Issue Type: Bug
>Affects Versions: 1.2.1
> Environment: hive  version  1.2.1
>Reporter: gehaijiang
>Assignee: kongxianghe
>Priority: Major
> Fix For: 1.2.1
>
>
> hiveserver2  memory leak
> hive  use  third UDF  (vs-1.0.2-SNAPSHOT.jar , 
> alogdata-1.0.3-SNAPSHOT-jar-with-dependencies.jar  . and so on )
> lr-x-- 1 data data 64 Sep  5 18:37 964 -> 
> /tmp/9e38cc04-5693-474b-9c7d-bfdd978bcbb4_resources/vs-1.0.2-SNAPSHOT.jar 
> (deleted)
> lr-x-- 1 data data 64 Sep  6 10:41 965 -> 
> /tmp/188bbf2a-d8a5-48a7-81fc-b807f9ff201d_resources/alogdata-1.0.3-SNAPSHOT-jar-with-dependencies.jar
>  (deleted)
> lr-x-- 1 data data 64 Sep  6 17:41 97 -> 
> /home/data/programs/hadoop-2.7.1/share/hadoop/hdfs/lib/jsr305-3.0.0.jar
> lrwx-- 1 data data 64 Sep  5 18:37 975 -> socket:[1318353317]
> lr-x-- 1 data data 64 Sep  6 02:38 977 -> 
> /tmp/64e309dc-352f-4ba4-b871-1aa78fe05945_resources/alogdata-1.0.3-SNAPSHOT-jar-with-dependencies.jar
>  (deleted)
> lr-x-- 1 data data 64 Sep  6 17:41 98 -> 
> /home/data/programs/hadoop-2.7.1/share/hadoop/hdfs/lib/xml-apis-1.3.04.jar
> lrwx-- 1 data data 64 Sep  6 08:40 983 -> socket:[1299459344]
> lr-x-- 1 data data 64 Sep  5 19:37 987 -> 
> /tmp/c3054987-c9c6-468a-8b5c-6e20b1972e0b_resources/alogdata-1.0.3-SNAPSHOT-jar-with-dependencies.jar
>  (deleted)
> lr-x-- 1 data data 64 Sep  6 17:41 99 -> 
> /home/data/programs/hadoop-2.7.1/share/hadoop/hdfs/lib/guava-11.0.2.jar
> lr-x-- 1 data data 64 Sep  6 08:40 994 -> 
> /tmp/fc5c44b3-9bd8-4a32-a39a-66cd44032fee_resources/alogdata-1.0.3-SNAPSHOT-jar-with-dependencies.jar
>  (deleted)
> lr-x-- 1 data data 64 Sep  6 06:39 996 -> 
> /tmp/3b3c2bd6-0a0e-4599-b757-4a048a968457_resources/alogdata-1.0.3-SNAPSHOT-jar-with-dependencies.jar
>  (deleted)
> lr-x-- 1 data data 64 Sep  5 17:36 999 -> 
> /tmp/6ad76494-cdda-430b-b7d0-2213731655a8_resources/alogdata-1.0.3-SNAPSHOT-jar-with-dependencies.jar
>  (deleted)
>   PID USER  PR  NI  VIRT  RES  SHR S %CPU %MEMTIME+  COMMAND
> 20084 data  20   0 13.6g  11g 533m S 62.3  9.2   6619:16 java
> /home/data/programs/jdk/jdk-current/bin/java-Djava.net.preferIPv4Stack=true-Dhadoop.log.dir=/home/data/hadoop/logs-Dhadoop.log.file=hadoop.log-Dhadoop.home.dir=/home/data/programs/hadoop-2.7.1-Dhadoop.id.str=data-Dhadoop.root.logger=INFO,DRFA-Djava.library.path=/home/data/programs/hadoop-2.7.1/lib/native-Dhadoop.policy.file=hadoop-policy.xml-Djava.net.preferIPv4Stack=true-XX:+UseConcMarkSweepGC-Xms8g-Xmx8g-Dhadoop.security.logger=INFO,NullAppenderorg.apache.hadoop.util.RunJar/home/data/programs/hive-current/lib/hive-service-1.2.1.jarorg.apache.hive.service.server.HiveServer2--hiveconfhive.log.file=hiveserver2.log



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Assigned] (HIVE-17462) hive_1.2.1 hiveserver2 memory leak

2020-09-21 Thread kongxianghe (Jira)


 [ 
https://issues.apache.org/jira/browse/HIVE-17462?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

kongxianghe reassigned HIVE-17462:
--

Assignee: kongxianghe

> hive_1.2.1  hiveserver2  memory leak
> 
>
> Key: HIVE-17462
> URL: https://issues.apache.org/jira/browse/HIVE-17462
> Project: Hive
>  Issue Type: Bug
>Affects Versions: 1.2.1
> Environment: hive  version  1.2.1
>Reporter: gehaijiang
>Assignee: kongxianghe
>Priority: Major
>
> hiveserver2  memory leak
> hive  use  third UDF  (vs-1.0.2-SNAPSHOT.jar , 
> alogdata-1.0.3-SNAPSHOT-jar-with-dependencies.jar  . and so on )
> lr-x-- 1 data data 64 Sep  5 18:37 964 -> 
> /tmp/9e38cc04-5693-474b-9c7d-bfdd978bcbb4_resources/vs-1.0.2-SNAPSHOT.jar 
> (deleted)
> lr-x-- 1 data data 64 Sep  6 10:41 965 -> 
> /tmp/188bbf2a-d8a5-48a7-81fc-b807f9ff201d_resources/alogdata-1.0.3-SNAPSHOT-jar-with-dependencies.jar
>  (deleted)
> lr-x-- 1 data data 64 Sep  6 17:41 97 -> 
> /home/data/programs/hadoop-2.7.1/share/hadoop/hdfs/lib/jsr305-3.0.0.jar
> lrwx-- 1 data data 64 Sep  5 18:37 975 -> socket:[1318353317]
> lr-x-- 1 data data 64 Sep  6 02:38 977 -> 
> /tmp/64e309dc-352f-4ba4-b871-1aa78fe05945_resources/alogdata-1.0.3-SNAPSHOT-jar-with-dependencies.jar
>  (deleted)
> lr-x-- 1 data data 64 Sep  6 17:41 98 -> 
> /home/data/programs/hadoop-2.7.1/share/hadoop/hdfs/lib/xml-apis-1.3.04.jar
> lrwx-- 1 data data 64 Sep  6 08:40 983 -> socket:[1299459344]
> lr-x-- 1 data data 64 Sep  5 19:37 987 -> 
> /tmp/c3054987-c9c6-468a-8b5c-6e20b1972e0b_resources/alogdata-1.0.3-SNAPSHOT-jar-with-dependencies.jar
>  (deleted)
> lr-x-- 1 data data 64 Sep  6 17:41 99 -> 
> /home/data/programs/hadoop-2.7.1/share/hadoop/hdfs/lib/guava-11.0.2.jar
> lr-x-- 1 data data 64 Sep  6 08:40 994 -> 
> /tmp/fc5c44b3-9bd8-4a32-a39a-66cd44032fee_resources/alogdata-1.0.3-SNAPSHOT-jar-with-dependencies.jar
>  (deleted)
> lr-x-- 1 data data 64 Sep  6 06:39 996 -> 
> /tmp/3b3c2bd6-0a0e-4599-b757-4a048a968457_resources/alogdata-1.0.3-SNAPSHOT-jar-with-dependencies.jar
>  (deleted)
> lr-x-- 1 data data 64 Sep  5 17:36 999 -> 
> /tmp/6ad76494-cdda-430b-b7d0-2213731655a8_resources/alogdata-1.0.3-SNAPSHOT-jar-with-dependencies.jar
>  (deleted)
>   PID USER  PR  NI  VIRT  RES  SHR S %CPU %MEMTIME+  COMMAND
> 20084 data  20   0 13.6g  11g 533m S 62.3  9.2   6619:16 java
> /home/data/programs/jdk/jdk-current/bin/java-Djava.net.preferIPv4Stack=true-Dhadoop.log.dir=/home/data/hadoop/logs-Dhadoop.log.file=hadoop.log-Dhadoop.home.dir=/home/data/programs/hadoop-2.7.1-Dhadoop.id.str=data-Dhadoop.root.logger=INFO,DRFA-Djava.library.path=/home/data/programs/hadoop-2.7.1/lib/native-Dhadoop.policy.file=hadoop-policy.xml-Djava.net.preferIPv4Stack=true-XX:+UseConcMarkSweepGC-Xms8g-Xmx8g-Dhadoop.security.logger=INFO,NullAppenderorg.apache.hadoop.util.RunJar/home/data/programs/hive-current/lib/hive-service-1.2.1.jarorg.apache.hive.service.server.HiveServer2--hiveconfhive.log.file=hiveserver2.log



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Comment Edited] (HIVE-17462) hive_1.2.1 hiveserver2 memory leak

2020-09-21 Thread kongxianghe (Jira)


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

kongxianghe edited comment on HIVE-17462 at 9/21/20, 7:13 AM:
--

was fixed in https://issues.apache.org/jira/browse/HIVE-10453
you may use hdp-1.2.1000.2.6.1.0 or some other versions,this patch may be not 
added into it.
decompile your hive-exec-1.2.1xxx.jar  and find class SessionState.class .

{code}
public void close() throws IOException {
registry.clear();;
registry.clear();
if (txnMgr != null) txnMgr.closeTxnManager();
JavaUtils.closeClassLoadersTo(conf.getClassLoader(), parentLoader);
File resourceDir =
@@ -1493,7 +1493,7 @@ public class SessionState {
sparkSession = null;
  }
}

// this line might be lost!!
registry.closeCUDFLoaders();
dropSessionPaths(conf);
  }
{code}
registry.closeCUDFLoaders();
in hdp 2.6.1  hive-1.2.1  this line is missing and that might cause this 
problem .



was (Author: kongxianghe):
was fixed in https://issues.apache.org/jira/browse/HIVE-10453
you may use hdp-1.2.1000.2.6.1.0 or some other versions,this patch may be not 
added into it.
decompile your hive-exec-1.2.1xxx.jar  and find class SessionState.class .

{code}
public void close() throws IOException {
registry.clear();;
registry.clear();
if (txnMgr != null) txnMgr.closeTxnManager();
JavaUtils.closeClassLoadersTo(conf.getClassLoader(), parentLoader);
File resourceDir =
@@ -1493,7 +1493,7 @@ public class SessionState {
sparkSession = null;
  }
}

// this line might be lost!!
registry.closeCUDFLoaders();
dropSessionPaths(conf);
  }
{code}
registry.closeCUDFLoaders();
in hdp 2.6.1  hive-1.2.1  this line is missing,might clause this problem 

> hive_1.2.1  hiveserver2  memory leak
> 
>
> Key: HIVE-17462
> URL: https://issues.apache.org/jira/browse/HIVE-17462
> Project: Hive
>  Issue Type: Bug
>Affects Versions: 1.2.1
> Environment: hive  version  1.2.1
>Reporter: gehaijiang
>Priority: Major
>
> hiveserver2  memory leak
> hive  use  third UDF  (vs-1.0.2-SNAPSHOT.jar , 
> alogdata-1.0.3-SNAPSHOT-jar-with-dependencies.jar  . and so on )
> lr-x-- 1 data data 64 Sep  5 18:37 964 -> 
> /tmp/9e38cc04-5693-474b-9c7d-bfdd978bcbb4_resources/vs-1.0.2-SNAPSHOT.jar 
> (deleted)
> lr-x-- 1 data data 64 Sep  6 10:41 965 -> 
> /tmp/188bbf2a-d8a5-48a7-81fc-b807f9ff201d_resources/alogdata-1.0.3-SNAPSHOT-jar-with-dependencies.jar
>  (deleted)
> lr-x-- 1 data data 64 Sep  6 17:41 97 -> 
> /home/data/programs/hadoop-2.7.1/share/hadoop/hdfs/lib/jsr305-3.0.0.jar
> lrwx-- 1 data data 64 Sep  5 18:37 975 -> socket:[1318353317]
> lr-x-- 1 data data 64 Sep  6 02:38 977 -> 
> /tmp/64e309dc-352f-4ba4-b871-1aa78fe05945_resources/alogdata-1.0.3-SNAPSHOT-jar-with-dependencies.jar
>  (deleted)
> lr-x-- 1 data data 64 Sep  6 17:41 98 -> 
> /home/data/programs/hadoop-2.7.1/share/hadoop/hdfs/lib/xml-apis-1.3.04.jar
> lrwx-- 1 data data 64 Sep  6 08:40 983 -> socket:[1299459344]
> lr-x-- 1 data data 64 Sep  5 19:37 987 -> 
> /tmp/c3054987-c9c6-468a-8b5c-6e20b1972e0b_resources/alogdata-1.0.3-SNAPSHOT-jar-with-dependencies.jar
>  (deleted)
> lr-x-- 1 data data 64 Sep  6 17:41 99 -> 
> /home/data/programs/hadoop-2.7.1/share/hadoop/hdfs/lib/guava-11.0.2.jar
> lr-x-- 1 data data 64 Sep  6 08:40 994 -> 
> /tmp/fc5c44b3-9bd8-4a32-a39a-66cd44032fee_resources/alogdata-1.0.3-SNAPSHOT-jar-with-dependencies.jar
>  (deleted)
> lr-x-- 1 data data 64 Sep  6 06:39 996 -> 
> /tmp/3b3c2bd6-0a0e-4599-b757-4a048a968457_resources/alogdata-1.0.3-SNAPSHOT-jar-with-dependencies.jar
>  (deleted)
> lr-x-- 1 data data 64 Sep  5 17:36 999 -> 
> /tmp/6ad76494-cdda-430b-b7d0-2213731655a8_resources/alogdata-1.0.3-SNAPSHOT-jar-with-dependencies.jar
>  (deleted)
>   PID USER  PR  NI  VIRT  RES  SHR S %CPU %MEMTIME+  COMMAND
> 20084 data  20   0 13.6g  11g 533m S 62.3  9.2   6619:16 java
> /home/data/programs/jdk/jdk-current/bin/java-Djava.net.preferIPv4Stack=true-Dhadoop.log.dir=/home/data/hadoop/logs-Dhadoop.log.file=hadoop.log-Dhadoop.home.dir=/home/data/programs/hadoop-2.7.1-Dhadoop.id.str=data-Dhadoop.root.logger=INFO,DRFA-Djava.library.path=/home/data/programs/hadoop-2.7.1/lib/native-Dhadoop.policy.file=hadoop-policy.xml-Djava.net.preferIPv4Stack=true-XX:+UseConcMarkSweepGC-Xms8g-Xmx8g-Dhadoop.security.logger=INFO,NullAppenderorg.apache.hadoop.util.RunJar/home/data/programs/hive-current/lib/hive-service-1.2.1.jarorg.apache.hive.service.server.HiveServer2--hiveconfhive.log.file=hiveserver2.log



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Commented] (HIVE-17462) hive_1.2.1 hiveserver2 memory leak

2020-09-21 Thread kongxianghe (Jira)


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

kongxianghe commented on HIVE-17462:


was fixed in https://issues.apache.org/jira/browse/HIVE-10453
you may use hdp-1.2.1000.2.6.1.0 or some other versions,this patch may be not 
added into it.
decompile your hive-exec-1.2.1xxx.jar  and find class SessionState.class .

{code}
public void close() throws IOException {
registry.clear();;
registry.clear();
if (txnMgr != null) txnMgr.closeTxnManager();
JavaUtils.closeClassLoadersTo(conf.getClassLoader(), parentLoader);
File resourceDir =
@@ -1493,7 +1493,7 @@ public class SessionState {
sparkSession = null;
  }
}

// this line might be lost!!
registry.closeCUDFLoaders();
dropSessionPaths(conf);
  }
{code}
registry.closeCUDFLoaders();
in hdp 2.6.1  hive-1.2.1  this line is missing,might clause this problem 

> hive_1.2.1  hiveserver2  memory leak
> 
>
> Key: HIVE-17462
> URL: https://issues.apache.org/jira/browse/HIVE-17462
> Project: Hive
>  Issue Type: Bug
>Affects Versions: 1.2.1
> Environment: hive  version  1.2.1
>Reporter: gehaijiang
>Priority: Major
>
> hiveserver2  memory leak
> hive  use  third UDF  (vs-1.0.2-SNAPSHOT.jar , 
> alogdata-1.0.3-SNAPSHOT-jar-with-dependencies.jar  . and so on )
> lr-x-- 1 data data 64 Sep  5 18:37 964 -> 
> /tmp/9e38cc04-5693-474b-9c7d-bfdd978bcbb4_resources/vs-1.0.2-SNAPSHOT.jar 
> (deleted)
> lr-x-- 1 data data 64 Sep  6 10:41 965 -> 
> /tmp/188bbf2a-d8a5-48a7-81fc-b807f9ff201d_resources/alogdata-1.0.3-SNAPSHOT-jar-with-dependencies.jar
>  (deleted)
> lr-x-- 1 data data 64 Sep  6 17:41 97 -> 
> /home/data/programs/hadoop-2.7.1/share/hadoop/hdfs/lib/jsr305-3.0.0.jar
> lrwx-- 1 data data 64 Sep  5 18:37 975 -> socket:[1318353317]
> lr-x-- 1 data data 64 Sep  6 02:38 977 -> 
> /tmp/64e309dc-352f-4ba4-b871-1aa78fe05945_resources/alogdata-1.0.3-SNAPSHOT-jar-with-dependencies.jar
>  (deleted)
> lr-x-- 1 data data 64 Sep  6 17:41 98 -> 
> /home/data/programs/hadoop-2.7.1/share/hadoop/hdfs/lib/xml-apis-1.3.04.jar
> lrwx-- 1 data data 64 Sep  6 08:40 983 -> socket:[1299459344]
> lr-x-- 1 data data 64 Sep  5 19:37 987 -> 
> /tmp/c3054987-c9c6-468a-8b5c-6e20b1972e0b_resources/alogdata-1.0.3-SNAPSHOT-jar-with-dependencies.jar
>  (deleted)
> lr-x-- 1 data data 64 Sep  6 17:41 99 -> 
> /home/data/programs/hadoop-2.7.1/share/hadoop/hdfs/lib/guava-11.0.2.jar
> lr-x-- 1 data data 64 Sep  6 08:40 994 -> 
> /tmp/fc5c44b3-9bd8-4a32-a39a-66cd44032fee_resources/alogdata-1.0.3-SNAPSHOT-jar-with-dependencies.jar
>  (deleted)
> lr-x-- 1 data data 64 Sep  6 06:39 996 -> 
> /tmp/3b3c2bd6-0a0e-4599-b757-4a048a968457_resources/alogdata-1.0.3-SNAPSHOT-jar-with-dependencies.jar
>  (deleted)
> lr-x-- 1 data data 64 Sep  5 17:36 999 -> 
> /tmp/6ad76494-cdda-430b-b7d0-2213731655a8_resources/alogdata-1.0.3-SNAPSHOT-jar-with-dependencies.jar
>  (deleted)
>   PID USER  PR  NI  VIRT  RES  SHR S %CPU %MEMTIME+  COMMAND
> 20084 data  20   0 13.6g  11g 533m S 62.3  9.2   6619:16 java
> /home/data/programs/jdk/jdk-current/bin/java-Djava.net.preferIPv4Stack=true-Dhadoop.log.dir=/home/data/hadoop/logs-Dhadoop.log.file=hadoop.log-Dhadoop.home.dir=/home/data/programs/hadoop-2.7.1-Dhadoop.id.str=data-Dhadoop.root.logger=INFO,DRFA-Djava.library.path=/home/data/programs/hadoop-2.7.1/lib/native-Dhadoop.policy.file=hadoop-policy.xml-Djava.net.preferIPv4Stack=true-XX:+UseConcMarkSweepGC-Xms8g-Xmx8g-Dhadoop.security.logger=INFO,NullAppenderorg.apache.hadoop.util.RunJar/home/data/programs/hive-current/lib/hive-service-1.2.1.jarorg.apache.hive.service.server.HiveServer2--hiveconfhive.log.file=hiveserver2.log



--
This message was sent by Atlassian Jira
(v8.3.4#803005)


[jira] [Updated] (HIVE-21190) hive thrift server may be blocked by session level waiting,caused by udf!

2019-02-02 Thread kongxianghe (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21190?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

kongxianghe updated HIVE-21190:
---
Description: 
# caused by an error UDF function!time_waiting(Long sleepSeconds)
{code}
public class UDFTimeWaiting extends UDF throws Exception{
  public String evaluate(String 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 until  session_1  
waiting 100 seconds!

this bug may cause hiveserver come into an unavailable status!  



# session_1 run waiting 200s,
 !session_1.jpg! 
# session_2 run at the same time ,but blocked by session_1 , see the 
pic,waiting 197s after session_1 returned then returned
 !session_2.jpg! 



# if someone want to attack or do sth ,hiveserver will not be down,but not 
available again!


  was:
# caused by an error UDF function!time_waiting(Long sleepSeconds)
{code}
public class UDFTimeWaiting extends UDF throws Exception{
  public String evaluate(String 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 come into an unavailable status!  



# session_1 run waiting 200s,
 !session_1.jpg! 
# session_2 run at the same time ,but blocked by session_1 , see the 
pic,waiting 197s after session_1 returned then returned
 !session_2.jpg! 



# if someone want to attack or do sth ,hiveserver will not be down,but not 
available again!



> hive thrift server may be blocked by session level waiting,caused by udf!
> -
>
> 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
>Priority: Critical
> Attachments: session_1.jpg, session_2.jpg
>
>
> # caused by an error UDF function!time_waiting(Long sleepSeconds)
> {code}
> public class UDFTimeWaiting extends UDF throws Exception{
>   public String evaluate(String 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 until  session_1  
> waiting 100 seconds!
> this bug may cause hiveserver come into an unavailable status!  
> 
> # session_1 run waiting 200s,
>  !session_1.jpg! 
> # session_2 run at the same time ,but blocked by session_1 , see the 
> pic,waiting 197s after session_1 returned then returned
>  !session_2.jpg! 
> 
> # if someone want to attack or do sth ,hiveserver will not be down,but not 
> available again!



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


[jira] [Updated] (HIVE-21190) hive thrift server may be blocked by session level waiting,caused by udf!

2019-01-30 Thread kongxianghe (JIRA)


 [ 
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 come into an available status!  



# session_1 run waiting 200s,
 !session_1.jpg! 
# session_2 run at the same time ,but blocked by session_1 , see the 
pic,waiting 197s after session_1 returned then returned
 !session_2.jpg! 



# if someone want to attack or do sth ,hiveserver will not be down,but not 
available again!


  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 come into an available status!  

# session_1 run waiting 200s,
 !session_1.jpg! 
# session_2 run at the same time ,but blocked by session_1 , see the 
pic,waiting 197s after session_1 returned then returned
 !session_2.jpg! 

if someone want to attack or do sth ,hiveserver will not be down,but not 
available again!



> hive thrift server may be blocked by session level waiting,caused by udf!
> -
>
> 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: Josh Elser
>Priority: Critical
> Attachments: session_1.jpg, session_2.jpg
>
>
> # 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 come into an available status!  
> 
> # session_1 run waiting 200s,
>  !session_1.jpg! 
> # session_2 run at the same time ,but blocked by session_1 , see the 
> pic,waiting 197s after session_1 returned then returned
>  !session_2.jpg! 
> 
> # if someone want to attack or do sth ,hiveserver will not be down,but not 
> available again!



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


[jira] [Updated] (HIVE-21190) hive thrift server may be blocked by session level waiting,caused by udf!

2019-01-30 Thread kongxianghe (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21190?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

kongxianghe updated HIVE-21190:
---
Description: 
# caused by an error UDF function!time_waiting(Long sleepSeconds)
{code}
public class UDFTimeWaiting extends UDF throws Exception{
  public String evaluate(String 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 come into an unavailable status!  



# session_1 run waiting 200s,
 !session_1.jpg! 
# session_2 run at the same time ,but blocked by session_1 , see the 
pic,waiting 197s after session_1 returned then returned
 !session_2.jpg! 



# if someone want to attack or do sth ,hiveserver will not be down,but not 
available again!


  was:
# caused by an error UDF function!time_waiting(Long sleepSeconds)
{code}
public class UDFTimeWaiting extends UDF throws Exception{
  public String evaluate(StringsleepSeconds){
 ...
 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 come into an unavailable status!  



# session_1 run waiting 200s,
 !session_1.jpg! 
# session_2 run at the same time ,but blocked by session_1 , see the 
pic,waiting 197s after session_1 returned then returned
 !session_2.jpg! 



# if someone want to attack or do sth ,hiveserver will not be down,but not 
available again!



> hive thrift server may be blocked by session level waiting,caused by udf!
> -
>
> 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: Josh Elser
>Priority: Critical
> Attachments: session_1.jpg, session_2.jpg
>
>
> # caused by an error UDF function!time_waiting(Long sleepSeconds)
> {code}
> public class UDFTimeWaiting extends UDF throws Exception{
>   public String evaluate(String 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 come into an unavailable status!  
> 
> # session_1 run waiting 200s,
>  !session_1.jpg! 
> # session_2 run at the same time ,but blocked by session_1 , see the 
> pic,waiting 197s after session_1 returned then returned
>  !session_2.jpg! 
> 
> # if someone want to attack or do sth ,hiveserver will not be down,but not 
> available again!



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


[jira] [Updated] (HIVE-21190) hive thrift server may be blocked by session level waiting,caused by udf!

2019-01-30 Thread kongxianghe (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21190?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

kongxianghe updated HIVE-21190:
---
Description: 
# caused by an error UDF function!time_waiting(Long sleepSeconds)
{code}
public class UDFTimeWaiting extends UDF throws Exception{
  public String evaluate(StringsleepSeconds){
 ...
 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 come into an unavailable status!  



# session_1 run waiting 200s,
 !session_1.jpg! 
# session_2 run at the same time ,but blocked by session_1 , see the 
pic,waiting 197s after session_1 returned then returned
 !session_2.jpg! 



# if someone want to attack or do sth ,hiveserver will not be down,but not 
available again!


  was:
# caused 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 come into an unavailable status!  



# session_1 run waiting 200s,
 !session_1.jpg! 
# session_2 run at the same time ,but blocked by session_1 , see the 
pic,waiting 197s after session_1 returned then returned
 !session_2.jpg! 



# if someone want to attack or do sth ,hiveserver will not be down,but not 
available again!



> hive thrift server may be blocked by session level waiting,caused by udf!
> -
>
> 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: Josh Elser
>Priority: Critical
> Attachments: session_1.jpg, session_2.jpg
>
>
> # caused by an error UDF function!time_waiting(Long sleepSeconds)
> {code}
> public class UDFTimeWaiting extends UDF throws Exception{
>   public String evaluate(StringsleepSeconds){
>  ...
>  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 come into an unavailable status!  
> 
> # session_1 run waiting 200s,
>  !session_1.jpg! 
> # session_2 run at the same time ,but blocked by session_1 , see the 
> pic,waiting 197s after session_1 returned then returned
>  !session_2.jpg! 
> 
> # if someone want to attack or do sth ,hiveserver will not be down,but not 
> available again!



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


[jira] [Updated] (HIVE-21190) hive thrift server may be blocked by session level waiting,caused by udf!

2019-01-30 Thread kongxianghe (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21190?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

kongxianghe updated HIVE-21190:
---
Description: 
# caused 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 come into an unavailable status!  



# session_1 run waiting 200s,
 !session_1.jpg! 
# session_2 run at the same time ,but blocked by session_1 , see the 
pic,waiting 197s after session_1 returned then returned
 !session_2.jpg! 



# if someone want to attack or do sth ,hiveserver will not be down,but not 
available again!


  was:
# caused 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 come into an available status!  



# session_1 run waiting 200s,
 !session_1.jpg! 
# session_2 run at the same time ,but blocked by session_1 , see the 
pic,waiting 197s after session_1 returned then returned
 !session_2.jpg! 



# if someone want to attack or do sth ,hiveserver will not be down,but not 
available again!



> hive thrift server may be blocked by session level waiting,caused by udf!
> -
>
> 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: Josh Elser
>Priority: Critical
> Attachments: session_1.jpg, session_2.jpg
>
>
> # caused 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 come into an unavailable status!  
> 
> # session_1 run waiting 200s,
>  !session_1.jpg! 
> # session_2 run at the same time ,but blocked by session_1 , see the 
> pic,waiting 197s after session_1 returned then returned
>  !session_2.jpg! 
> 
> # if someone want to attack or do sth ,hiveserver will not be down,but not 
> available again!



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


[jira] [Updated] (HIVE-21190) hive thrift server may be blocked by session level waiting,caused by udf!

2019-01-30 Thread kongxianghe (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21190?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

kongxianghe updated HIVE-21190:
---
Description: 
# caused 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 come into an available status!  



# session_1 run waiting 200s,
 !session_1.jpg! 
# session_2 run at the same time ,but blocked by session_1 , see the 
pic,waiting 197s after session_1 returned then returned
 !session_2.jpg! 



# if someone want to attack or do sth ,hiveserver will not be down,but not 
available again!


  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 come into an available status!  



# session_1 run waiting 200s,
 !session_1.jpg! 
# session_2 run at the same time ,but blocked by session_1 , see the 
pic,waiting 197s after session_1 returned then returned
 !session_2.jpg! 



# if someone want to attack or do sth ,hiveserver will not be down,but not 
available again!



> hive thrift server may be blocked by session level waiting,caused by udf!
> -
>
> 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: Josh Elser
>Priority: Critical
> Attachments: session_1.jpg, session_2.jpg
>
>
> # caused 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 come into an available status!  
> 
> # session_1 run waiting 200s,
>  !session_1.jpg! 
> # session_2 run at the same time ,but blocked by session_1 , see the 
> pic,waiting 197s after session_1 returned then returned
>  !session_2.jpg! 
> 
> # if someone want to attack or do sth ,hiveserver will not be down,but not 
> available again!



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


[jira] [Updated] (HIVE-21190) hive thrift server may be blocked by session level waiting,caused by udf!

2019-01-30 Thread kongxianghe (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21190?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

kongxianghe updated HIVE-21190:
---
Summary: hive thrift server may be blocked by session level waiting,caused 
by udf!  (was: hive thrift server may be blocked by session level waiting!)

> hive thrift server may be blocked by session level waiting,caused by udf!
> -
>
> 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)


[jira] [Updated] (HIVE-21190) hive thrift server may be blocked by session level waiting,caused by udf!

2019-01-30 Thread kongxianghe (JIRA)


 [ 
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 come into an available status!  
===
# session_1 run waiting 200s,
 !session_1.jpg! 
# session_2 run at the same time ,but blocked by session_1 , see the 
pic,waiting 197s after session_1 returned then returned
 !session_2.jpg! 

===
if someone want to attack or do sth ,hiveserver will not be down,but not 
available again!


  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 come into an available status!  
===
# session_1 run waiting 200s,
 !session_1.jpg! 
# session_2 run at the same time ,but blocked by session_1 , see the 
pic,waiting 197s after session_1 returned then returned
 !session_2.jpg! 

===
if someone want to attack or do sth ,hiveserver will not be down,but not 
available again!



> hive thrift server may be blocked by session level waiting,caused by udf!
> -
>
> 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: Josh Elser
>Priority: Critical
> Attachments: session_1.jpg, session_2.jpg
>
>
> # 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 come into an available status!  
> ===
> # session_1 run waiting 200s,
>  !session_1.jpg! 
> # session_2 run at the same time ,but blocked by session_1 , see the 
> pic,waiting 197s after session_1 returned then returned
>  !session_2.jpg! 
> ===
> if someone want to attack or do sth ,hiveserver will not be down,but not 
> available again!



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


[jira] [Updated] (HIVE-21190) hive thrift server may be blocked by session level waiting,caused by udf!

2019-01-30 Thread kongxianghe (JIRA)


 [ 
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 come into an available status!  

# session_1 run waiting 200s,
 !session_1.jpg! 
# session_2 run at the same time ,but blocked by session_1 , see the 
pic,waiting 197s after session_1 returned then returned
 !session_2.jpg! 

if someone want to attack or do sth ,hiveserver will not be down,but not 
available again!


  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 come into an available status!  
===
# session_1 run waiting 200s,
 !session_1.jpg! 
# session_2 run at the same time ,but blocked by session_1 , see the 
pic,waiting 197s after session_1 returned then returned
 !session_2.jpg! 

===
if someone want to attack or do sth ,hiveserver will not be down,but not 
available again!



> hive thrift server may be blocked by session level waiting,caused by udf!
> -
>
> 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: Josh Elser
>Priority: Critical
> Attachments: session_1.jpg, session_2.jpg
>
>
> # 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 come into an available status!  
> 
> # session_1 run waiting 200s,
>  !session_1.jpg! 
> # session_2 run at the same time ,but blocked by session_1 , see the 
> pic,waiting 197s after session_1 returned then returned
>  !session_2.jpg! 
> 
> if someone want to attack or do sth ,hiveserver will not be down,but not 
> available again!



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


[jira] [Updated] (HIVE-21190) hive thrift server may be blocked by session level waiting,caused by udf!

2019-01-30 Thread kongxianghe (JIRA)


 [ 
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 come into an available status!  
===
# session_1 run waiting 200s,
 !session_1.jpg! 
# session_2 run at the same time ,but blocked by session_1 , see the 
pic,waiting 197s after session_1 returned then returned
 !session_2.jpg! 

===
if someone want to attack or do sth ,hiveserver will not be down,but not 
available again!


  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 can into an available status!  
===
# session_1 run waiting 200s,
 !session_1.jpg! 
# session_2 run at the same time ,but blocked by session_1 , see the 
pic,waiting 197s after session_1 returned then returned
 !session_2.jpg! 

===
if someone want to attack or do sth ,hiveserver will not be down,but not 
available again!



> hive thrift server may be blocked by session level waiting,caused by udf!
> -
>
> 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: Josh Elser
>Priority: Critical
> Attachments: session_1.jpg, session_2.jpg
>
>
> # 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 come into an available status!  
> ===
> # session_1 run waiting 200s,
>  !session_1.jpg! 
> # session_2 run at the same time ,but blocked by session_1 , see the 
> pic,waiting 197s after session_1 returned then returned
>  !session_2.jpg! 
> ===
> if someone want to attack or do sth ,hiveserver will not be down,but not 
> available again!



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


[jira] [Updated] (HIVE-21190) hive thrift server may be blocked by session level waiting,caused by udf!

2019-01-30 Thread kongxianghe (JIRA)


 [ 
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!  
===
# session_1 run waiting 200s,
 !session_1.jpg! 
# session_2 run at the same time ,but blocked by session_1 , see the 
pic,waiting 197s after session_1 returned then returned
 !session_2.jpg! 

===
if someone want to attack or do sth ,hiveserver will not be down,but not 
available again!


  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 can into an available status!  
 !session_1.jpg! 

 !session_2.jpg! 


> hive thrift server may be blocked by session level waiting,caused by udf!
> -
>
> 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: Josh Elser
>Priority: Critical
> Attachments: session_1.jpg, session_2.jpg
>
>
> # 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!  
> ===
> # session_1 run waiting 200s,
>  !session_1.jpg! 
> # session_2 run at the same time ,but blocked by session_1 , see the 
> pic,waiting 197s after session_1 returned then returned
>  !session_2.jpg! 
> ===
> if someone want to attack or do sth ,hiveserver will not be down,but not 
> available again!



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


[jira] [Updated] (HIVE-21190) hive thrift server may be blocked by session level waiting,caused by udf!

2019-01-30 Thread kongxianghe (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21190?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

kongxianghe updated HIVE-21190:
---
Attachment: session_1.jpg
session_2.jpg

> hive thrift server may be blocked by session level waiting,caused by udf!
> -
>
> 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: Josh Elser
>Priority: Critical
> Attachments: session_1.jpg, session_2.jpg
>
>
> # 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)


[jira] [Updated] (HIVE-21190) hive thrift server may be blocked by session level waiting,caused by udf!

2019-01-30 Thread kongxianghe (JIRA)


 [ 
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!  
 !session_1.jpg! 

 !session_2.jpg! 

  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 can into an available status!  


> hive thrift server may be blocked by session level waiting,caused by udf!
> -
>
> 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: Josh Elser
>Priority: Critical
> Attachments: session_1.jpg, session_2.jpg
>
>
> # 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!  
>  !session_1.jpg! 
>  !session_2.jpg! 



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


[jira] [Assigned] (HIVE-21190) hive thrift server may be blocked by session level waiting,caused by udf!

2019-01-30 Thread kongxianghe (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21190?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

kongxianghe reassigned HIVE-21190:
--

Assignee: Josh Elser  (was: kongxianghe)

> hive thrift server may be blocked by session level waiting,caused by udf!
> -
>
> 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: Josh Elser
>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)


[jira] [Updated] (HIVE-21190) hive thrift server may be blocked by session level waiting!

2019-01-30 Thread kongxianghe (JIRA)


 [ 
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)


[jira] [Updated] (HIVE-21190) hive thrift server may be blocked by session level waiting!

2019-01-30 Thread kongxianghe (JIRA)


 [ 
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:
{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!  

  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:
##  select time_waiting(100);
# in session_2:
## select 1;  or show tables;
# 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:
> {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!  



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


[jira] [Updated] (HIVE-21190) hive thrift server may be blocked by session level waiting!

2019-01-30 Thread kongxianghe (JIRA)


 [ 
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)


[jira] [Updated] (HIVE-21190) hive thrift server may be blocked by session level waiting!

2019-01-30 Thread kongxianghe (JIRA)


 [ 
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:
##  select time_waiting(100);
# in session_2:
## select 1;  or show tables;
# 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}


> 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:
> ##  select time_waiting(100);
> # in session_2:
> ## select 1;  or show tables;
> # 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)


[jira] [Assigned] (HIVE-21190) hive thrift server may be blocked by session level waiting!

2019-01-30 Thread kongxianghe (JIRA)


 [ 
https://issues.apache.org/jira/browse/HIVE-21190?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

kongxianghe reassigned HIVE-21190:
--


> 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}



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