[jira] [Comment Edited] (DRILL-7956) Web interface hangs afte execute too many queries

["Cong Luo (Jira)" <ji...@apache.org>]

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

Cong Luo edited comment on DRILL-7956 at 7/3/21, 6:17 AM:
----------------------------------------------------------

[~Homaebic] Hi, Have you tried the release 1.19? The 1.19 included an enhanced feature for the RESTful queries (support the streaming read)


was (Author: luoc):
[~Homaebic] Hi, Have you tried the release 1.19? The 1.19 included an enhanced feature for the RESTful querise (support the streaming read)

> Web interface hangs afte execute too many queries
> -------------------------------------------------
>
>                 Key: DRILL-7956
>                 URL: https://issues.apache.org/jira/browse/DRILL-7956
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Client - HTTP
>    Affects Versions: 1.18.0
>            Reporter: Hanoch Yang
>            Priority: Major
>         Attachments: 1561.jstack
>
>
> 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'
>  
>  



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