Re: select * clause still case all regionserver crash

2016-12-10 Thread hongbin ma
Hi, are you "qstar" from https://issues.apache.org/jira/browse/KYLIN-1936?focusedCommentId=15727422=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#comment-15727422 ? Just want to make sure whether it's a individual case or common case On Thu, Dec 8, 2016 at 10:00 AM, alaleiwang

Re: select * clause still case all regionserver crash

2016-12-07 Thread alaleiwang
about v1.5.4,"select * from table limit N" clause seems not to crash regionserver,but meantime no result return for the clause -- View this message in context: http://apache-kylin.74782.x6.nabble.com/select-clause-still-cause-all-regionserver-crash-tp6474p6535.html Sent from the Apache Kylin

Re: select * clause still case all regionserver crash

2016-12-04 Thread roger shi
It’s not recommend to select * without limit. Query server cannot handle too many records got from storage. On 05/12/2016, 10:25 AM, "alaleiwang" wrote: thanks a lot,i will check KYLIN-1936 and try v1.5.4 to find if it will solve our problem by use "select *

Re: select * clause still case all regionserver crash

2016-12-04 Thread roger shi
According to hongbin’s comments in JIRA KYLIN-1936, it fixed limit push down issue when dealing with multiple segments. On 04/12/2016, 7:01 PM, "Alberto Ramón" wrote: about KYLIN-1936: what make this change ? (keep in mind groups by? keep in mind

Re: select * clause still case all regionserver crash

2016-12-04 Thread 35925138
-- Original -- From: "alaleiwang";<alaleiw...@sohu-inc.com>; Date: Mon, Dec 5, 2016 10:25 AM To: "dev"<dev@kylin.apache.org>; Subject: Re: select * clause still case all regionserver crash thanks a lot,i will check KYLIN-1936 and try v1.

Re: select * clause still case all regionserver crash

2016-12-04 Thread alaleiwang
thanks a lot,i will check KYLIN-1936 and try v1.5.4 to find if it will solve our problem by use "select * from table limit N" i am still afraid the case the user will use "select *" clause even without "limit",how can we deal with this one? -- View this message in context:

Re: select * clause still case all regionserver crash

2016-12-04 Thread roger shi
The limit push down issue is completely resolved in JIRA KYLIN-1936, which is applied in 1.5.4. So please try kylin 1.5.4. On 02/12/2016, 5:51 PM, "ShaoFeng Shi" wrote: I remember hongbin has further optimization on the limit push down after 1.5.3; @hongbin, can

Re: select * clause still case all regionserver crash

2016-12-02 Thread Alberto Ramón
:) We have some similiar problem with non-IT "Why do you want a result table of 1 Millon of rows ¿? " I don't Know any solution. The Q is: this is a problem/bug/issue of Kylin ? I think NO, the target of this is protect to coprocesor (is mandatory) Select * is not addecuate for Kylin

Re: select * clause still case all regionserver crash

2016-12-02 Thread ShaoFeng Shi
I remember hongbin has further optimization on the limit push down after 1.5.3; @hongbin, can you confirm this? 2016-12-02 17:02 GMT+08:00 alaleiwang : > i can see each regionserver scan over 2000+ > > the query "select *" is called from tableau used by

Re: select * clause still case all regionserver crash

2016-12-01 Thread Alberto Ramón
About select * from :Kylin 1792 v1.5.3 Can you check if you see this error: "*Scan row count exceeded threshold: 100, please add filter condition to narrow down backend scan range, like where clause*" With Queries like this:

Re: select * clause still case all regionserver crash

2016-12-01 Thread alaleiwang
KYLIN-1787 say fixed in v1.5.3,but it still happened from v1.5.1 to v1.5.3 -- View this message in context: http://apache-kylin.74782.x6.nabble.com/select-clause-still-cause-all-regionserver-crash-tp6474p6476.html Sent from the Apache Kylin mailing list archive at Nabble.com.

Re: select * clause still case all regionserver crash

2016-12-01 Thread Alberto Ramón
not crash > regionserver > > > > -- > View this message in context: http://apache-kylin.74782.x6. > nabble.com/select-clause-still-case-all-regionserver-crash-tp6474.html > Sent from the Apache Kylin mailing list archive at Nabble.com. >

select * clause still case all regionserver crash

2016-12-01 Thread alaleiwang
more to be added: select * from tablename where aa=bb limit 10 do work,and will not crash regionserver -- View this message in context: http://apache-kylin.74782.x6.nabble.com/select-clause-still-case-all-regionserver-crash-tp6474.html Sent from the Apache Kylin mailing li