Let's continue discussion in the JIRA, KYLIN-1294.
On Thu, Jan 7, 2016 at 11:40 AM, 曾经 <1032195...@qq.com> wrote:
> 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 :
> SELECT "KYLIN_TV_DIM_AREA"."TV_AREA_NAME" AS "TV_AREA_NAME",
> SUM("KYLIN_VIEW_TVAD_SUMMARY"."INCOME") AS "sum_INCOME_ok",
> SUM(1) AS "sum_Number_of_Records_ok",
> SUM("KYLIN_VIEW_TVAD_SUMMARY"."VV") AS "sum_VV_ok"
> FROM "BD_WAREHOUSE"."KYLIN_VIEW_TVAD_SUMMARY" "KYLIN_VIEW_TVAD_SUMMARY"
> LEFT JOIN "BD_WAREHOUSE"."KYLIN_TV_DIM_AREA" "KYLIN_TV_DIM_AREA"
> ON ("KYLIN_VIEW_TVAD_SUMMARY"."AREA" =
> "KYLIN_TV_DIM_AREA"."TV_AREA_ID")
> WHERE (("KYLIN_TV_DIM_AREA"."TV_AREA_NAME" not IN ('美剧', 'a', '默认地区')))
> GROUP BY "KYLIN_TV_DIM_AREA"."TV_AREA_NAME";
>
>
>
>
>
> ------------------ 原始邮件 ------------------
> 发件人: "Li Yang";<liy...@apache.org>;
> 发送时间: 2016年1月7日(星期四) 中午11:28
> 收件人: "dev"<dev@kylin.apache.org>;
>
> 主题: 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.
> https://issues.apache.org/jira/browse/KYLIN-1294
>
> 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
> null.
>
> 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 <jh...@apache.org> 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
> > https://issues.apache.org/jira/browse/CALCITE-980 <
> > https://issues.apache.org/jira/browse/CALCITE-980>.
> >
> > Julian
> >
> > > On Jan 6, 2016, at 6:28 PM, 曾经 <1032195...@qq.com> 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.
> >
> >
>
