You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Cong Luo (Jira)" <ji...@apache.org> on 2021/07/02 10:44:00 UTC
[jira] [Commented] (DRILL-7956) Web interface hangs afte execute
too many queries
[ https://issues.apache.org/jira/browse/DRILL-7956?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17373430#comment-17373430 ]
Cong Luo commented on DRILL-7956:
---------------------------------
[~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)