kylin-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Li Yang <liy...@apache.org>
Subject Re: Question: The limit on the kylin web UI, what does it limit?
Date Sun, 10 Sep 2017 08:05:12 GMT
Seems a bug in limit handling. Could you open a JIRA to describe the
problem?

On Mon, Sep 4, 2017 at 1:43 PM, Mu Kong <kong.mu.biz@gmail.com> wrote:

> Hi all,
>
> The previous email seems to be blocked. So I'm re-send this email.
> I was running a group by query with subquery. Something like the follows:
>
> SELECT
>   SUM(col3) AS col4,
>   SUM(col5) AS total_col5,
>   col1
> FROM
> (
>   SELECT
>     col1,
>     col2,
>     MAX(col3) AS col3,
>     COUNT(*) AS col5
>   FROM db.table
>   WHERE col6 = 'somestring'
>   GROUP BY col1, col2
> )
> GROUP BY col1
>
> When I specify the limit as 50, the result has 19 records, and when I
> specify the limit as 500000, there are 90+ records in the result and each
> record has higher col4 and total_col5.
>
> Based on this phenomenon, does it mean the limit in the UI doesn't limit
> the number of the record of the query result, but the number of records
> that are queried against?
>
> Best regards,
> Mu
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message