[DRILL-7956] Web interface hangs afte execute too many queries

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Abandoned
• Affects Version/s: 1.18.0
• Component/s: Client - HTTP
• Assignee: Unassigned
• Reporter: Hanoch Yang
• Created: 25/Jun/21 10:32
• Updated: 14/Jul/22 11:28
• Resolved: 14/Jul/22 11:28

Description

I used 1.18.0 to install the drill locally and installed an hbase storage plugin. When I executed the query continuously, when the fifth query was submitted, the REST API started to become unresponsive and the web page could not be accessed. After a few minutes, everything returned to normal. However, during this period of time, the REST API was unavailable, and the logs and system monitoring did not find any abnormalities. Why?

Every sigle query will spent 7min to execute

start command :

/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.232.b09-0.el7_7.x86_64/jre/bin/java -Xms4G -Xmx4G -XX:MaxDirectMemorySize=8G -XX:ReservedCodeCacheSize=1G -Ddrill.exec.enable-epoll=false -Dlog.path=/usr/local/apache-drill-1.18.0/log/sqlline.log -Dlog.query.path=/usr/local/apache-drill-1.18.0/log/sqlline_queries.json -Dorg.jline.terminal.dumb=true -cp /usr/local/apache-drill-1.18.0/conf:/usr/local/apache-drill-1.18.0/jars/:/usr/local/apache-drill-1.18.0/jars/ext/:/usr/local/apache-drill-1.18.0/jars/3rdparty/:/usr/local/apache-drill-1.18.0/jars/classb/:/usr/local/apache-drill-1.18.0/jars/3rdparty/linux/* sqlline.SqlLine -ac org.apache.drill.exec.client.DrillSqlLineApplication --color=true -u jdbc:drill:zk=local

 

This is hbase config:

 

{
"type": "hbase",
"config":

{ "hbase.zookeeper.quorum": "ip,ip,ip,ip", "hbase.zookeeper.property.clientPort": "2181" }

,
"size.calculator.enabled": false,
"enabled": true
}

This is the query statement:
select * from `hbase`.`qqq` where CONVERT_FROM(`qqq`.c1.ip,'UTF8') = '10.38.12.94' and CONVERT_FROM(`qqq`.c1.`time`,'UTF8') >= '1621785600000' and CONVERT_FROM(`qqq`.c1.`time`,'UTF8') <= '1624464000000'