kylin-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "曾经" <>
Subject Re: A problem,maybe a bug, when querying in kylin using not in
Date Thu, 07 Jan 2016 03:40:35 GMT
In the case you give lstg_format_name does not contain null, I tested in my cube, and it's
also OK.
While, when I execute the following sql, where "a" is not a member of "KYLIN_TV_DIM_AREA"."TV_AREA_NAME",
the "TV_AREA_NAME" of "默认地区" will still appear in the result set. I think this is
also a related problem in the bug.
The sql is :
       SUM(1) AS "sum_Number_of_Records_ok",
 WHERE (("KYLIN_TV_DIM_AREA"."TV_AREA_NAME" not IN ('美剧', 'a', '默认地区')))

------------------ 原始邮件 ------------------
发件人: "Li Yang";<>;
发送时间: 2016年1月7日(星期四) 中午11:28
收件人: "dev"<>; 

主题: Re: A problem,maybe a bug, when querying in kylin using not in

Confirm this is a bug. Not sure of the root cause, but I can reproduce on
2.x and 1.x branch though they yield different exceptions.

Open a JIRA for further investigation.

Meanwhile worth note that this test query did pass with no problem, giving
('FP-GTC', 'ABIN') are valid values and lstg_format_name does not contain

select lstg_format_name, sum(price) as GMV
 from test_kylin_fact
 where lstg_format_name not in ('FP-GTC', 'ABIN')
 group by lstg_format_name

On Thu, Jan 7, 2016 at 10:54 AM, Julian Hyde <> wrote:

> Yes, it looks as if you have a data correctness issue. If I were you I’d
> look at the plan and see if it makes sense.
> Your second case, the NullPointerException issue, looks a lot like
> <
> Julian
> > On Jan 6, 2016, at 6:28 PM, 曾经 <> wrote:
> >
> > Thank you very much for answering.
> > In my result ,not only null in H_CODE is skipped, but also the lines
> where H_CODE is 'B' and 'O' are all skipped. I think this.
> > I think this is not only a prolem of null.
  • Unnamed multipart/alternative (inline, 8-Bit, 0 bytes)
View raw message