kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ShaoFeng Shi <shaofeng...@apache.org>
Subject Re: What to do when facing coprocessor timeout when doing fuzzy query?
Date Mon, 16 Jul 2018 05:58:54 GMT
In this case, you may need to check the hbase region server's log to see
what happened in storage layer.

2018-07-09 9:01 GMT+08:00 彭鱼宴 <461292639@qq.com>:

> Hi,
>
> I built a cube with over 10 million source records successfully, and I
> could use the cube to do some SQL query. However, when I want to do fuzzy
> query, I have to face such errors:
> 1.coprocessor timeout after scanning 318500 rows while executing SQL:
> "select * from dns_table where dns like '0027%' LIMIT 50000",
> 2.org.apache.hadoop.hbase.DoNotRetryIOException: Coprocessor passed
> deadline! Maybe server is overloaded at
>
> To solve the problem, I have changed the value of "kylin.storage.hbase.coprocessor-timeout-seconds"
> from 0 to 300, but all I did didn't work well. Do you have any advice to
> solve the problem, or, optimize the cube building?
>
> Looking forward to your reply and help.
>
> Best wishes,
> Zhefu Peng
>



-- 
Best regards,

Shaofeng Shi 史少锋

Mime
View raw message