[
https://issues.apache.org/jira/browse/DRILL-7956?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
James Turton closed DRILL-7956.
-------------------------------
Resolution: Abandoned
> 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.20.10#820010)
