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