You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by Xixin <zx...@163.com> on 2018/03/01 07:07:41 UTC
Re: Questions about query: cache, jdbc driver.
Hi Yang,
I met the similar problem
sql:"select distinct uid from table where daytime=? limit 700000"
ps.setString(1,"2018-01-03")
store the result to ArrayList, and print the size of ArrayList.
when I set the daytime to different dates, the same result I got.
I changed the sql, just change limit value for example
sql:"select distinct uid from table where daytime=? limit *60*0000"
then I got the right value the same like query from GUI:count (distinct uid)
is it a bug? or something I query in a wrong way?
Thanks in advance!
--
Sent from: http://apache-kylin.74782.x6.nabble.com/
Re: Questions about query: cache, jdbc driver.
Posted by Billy Liu <bi...@apache.org>.
Will release this fix in 2.3.1
With Warm regards
Billy Liu
2018-03-18 2:35 GMT-07:00 Li Yang <li...@apache.org>:
> Thanks for reporting. We are able to reproduce and fix. Thanks a lot!
>
> On Mon, Mar 5, 2018 at 10:29 AM, Xixin <zx...@163.com> wrote:
>
>> Hi Yang,
>> Please find the KYLIN-3276
>> <https://issues.apache.org/jira/browse/KYLIN-3276?jql=
>> project%20%3D%20KYLIN%20AND%20resolution%20%3D%20Unresolved%20ORDER%20BY%
>> 20priority%20DESC%2C%20updated%20DESC>
>> If some other informations you need please do not hesitate to let me know.
>> Thanks.
>>
>> BR
>> Xixin
>>
>> --
>> Sent from: http://apache-kylin.74782.x6.nabble.com/
>>
Re: Questions about query: cache, jdbc driver.
Posted by Li Yang <li...@apache.org>.
Thanks for reporting. We are able to reproduce and fix. Thanks a lot!
On Mon, Mar 5, 2018 at 10:29 AM, Xixin <zx...@163.com> wrote:
> Hi Yang,
> Please find the KYLIN-3276
> <https://issues.apache.org/jira/browse/KYLIN-3276?jql=
> project%20%3D%20KYLIN%20AND%20resolution%20%3D%20Unresolved%20ORDER%20BY%
> 20priority%20DESC%2C%20updated%20DESC>
> If some other informations you need please do not hesitate to let me know.
> Thanks.
>
> BR
> Xixin
>
> --
> Sent from: http://apache-kylin.74782.x6.nabble.com/
>
Re: Questions about query: cache, jdbc driver.
Posted by Xixin <zx...@163.com>.
Hi Yang,
Please find the KYLIN-3276
<https://issues.apache.org/jira/browse/KYLIN-3276?jql=project%20%3D%20KYLIN%20AND%20resolution%20%3D%20Unresolved%20ORDER%20BY%20priority%20DESC%2C%20updated%20DESC>
If some other informations you need please do not hesitate to let me know.
Thanks.
BR
Xixin
--
Sent from: http://apache-kylin.74782.x6.nabble.com/
Re: Questions about query: cache, jdbc driver.
Posted by Li Yang <li...@apache.org>.
This seems a bug to me. Guess the caching check didn't consider the dynamic
parameter. Could you open a JIRA?
Cheers
Yang
On Thu, Mar 1, 2018 at 3:07 PM, Xixin <zx...@163.com> wrote:
> Hi Yang,
> I met the similar problem
> sql:"select distinct uid from table where daytime=? limit 700000"
> ps.setString(1,"2018-01-03")
> store the result to ArrayList, and print the size of ArrayList.
> when I set the daytime to different dates, the same result I got.
>
> I changed the sql, just change limit value for example
> sql:"select distinct uid from table where daytime=? limit *60*0000"
> then I got the right value the same like query from GUI:count (distinct
> uid)
>
> is it a bug? or something I query in a wrong way?
> Thanks in advance!
>
> --
> Sent from: http://apache-kylin.74782.x6.nabble.com/
>