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";<[email protected]>;
????????: 2016??1??7??(??????) ????11:28
??????: "dev"<[email protected]>;
????: 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 <[email protected]> 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, ???? <[email protected]> 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.
>
>
