You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@impala.apache.org by "meijies@yandex.com" <me...@yandex.com> on 2018/08/01 07:46:25 UTC

What means if the sql statements append "limit 0" automatically?

Hi, Every One

Impala version 2.11

During press test, I  found many join sql statement like blew append "limit 0" automatically. is there any  resource limit reached? 

execute sql statement:
select count(1) cnt from kudu_session_7 s left join kudu_event_detail_7 e on e.uuid = s.uuid and e.st = s.st group by s.browser order by cnt desc limit 1000;

the related sql  statement at impala log:
select count(1) cnt from kudu_session_7 s left join kudu_event_detail_7 e on e.uuid = s.uuid and e.st = s.st group by s.browser order by cnt desc limit 1000;



meijies@yandex.com

Re: What means if the sql statements append "limit 0" automatically?

Posted by "meijies@yandex.com" <me...@yandex.com>.
this case didn't occur after I disable PreparedMetaLimitZero feture of impala jdbc. 

Thanks



meijies@yandex.com
 
From: Jeszy
Date: 2018-08-01 15:48
To: user
Subject: Re: What means if the sql statements append "limit 0" automatically?
Impala shouldn't append limit 0 automatically. It's probably done by
the tool you use to submit the queries. Do you observe the same issue
with impala-shell?
 
Thanks!
 
On 1 August 2018 at 09:46, meijies@yandex.com <me...@yandex.com> wrote:
> Hi, Every One
>
> Impala version 2.11
>
> During press test, I  found many join sql statement like blew append "limit
> 0" automatically. is there any  resource limit reached?
>
> execute sql statement:
> select count(1) cnt from kudu_session_7 s left join kudu_event_detail_7 e on
> e.uuid = s.uuid and e.st = s.st group by s.browser order by cnt desc limit
> 1000;
>
> the related sql  statement at impala log:
> select count(1) cnt from kudu_session_7 s left join kudu_event_detail_7 e on
> e.uuid = s.uuid and e.st = s.st group by s.browser order by cnt desc limit
> 1000;
>
> ________________________________
> meijies@yandex.com

Re: What means if the sql statements append "limit 0" automatically?

Posted by Jeszy <je...@gmail.com>.
Impala shouldn't append limit 0 automatically. It's probably done by
the tool you use to submit the queries. Do you observe the same issue
with impala-shell?

Thanks!

On 1 August 2018 at 09:46, meijies@yandex.com <me...@yandex.com> wrote:
> Hi, Every One
>
> Impala version 2.11
>
> During press test, I  found many join sql statement like blew append "limit
> 0" automatically. is there any  resource limit reached?
>
> execute sql statement:
> select count(1) cnt from kudu_session_7 s left join kudu_event_detail_7 e on
> e.uuid = s.uuid and e.st = s.st group by s.browser order by cnt desc limit
> 1000;
>
> the related sql  statement at impala log:
> select count(1) cnt from kudu_session_7 s left join kudu_event_detail_7 e on
> e.uuid = s.uuid and e.st = s.st group by s.browser order by cnt desc limit
> 1000;
>
> ________________________________
> meijies@yandex.com