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. > >
