You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@kylin.apache.org by Li Yang <li...@apache.org> on 2017/10/08 07:17:29 UTC

Re: kylin 'not in' returns the result is empty.

I recall this is a fixed issue, but cannot find the exact JIRA somehow.

Could you verify again using Kylin 2.1? Test case like this
<https://github.com/apache/kylin/blob/2.1.x/kylin-it/src/test/resources/query/sql/query101.sql>
has been verified.

Cheers
Yang

On Fri, Sep 29, 2017 at 3:17 PM, alex wang <he...@gmail.com> wrote:

> Hi all:
> SQL: select sum(TABLE_VISIT.column1) from TABLE_VISIT  where
> TABLE_VISIT.column2 not in ('none','None') ;
>
> I use kylin 1.6,
> When there is no value of 'none' or 'None' in the field
> TABLE_VISIT.column2,
> Will report the following error. And the query results return empty.
>
> 2017-09-28 17:50:55,539 ERROR [Query 162a900a-9f11-4c22-b954
> <https://maps.google.com/?q=9f11-4c22-b954&entry=gmail&source=g>-e01346fa7084-61]
> dict.TrieDictionary:182 : Not a valid value: none
> 2017-09-28 17:50:55,539 ERROR [Query 162a900a-9f11-4c22-b954
> <https://maps.google.com/?q=9f11-4c22-b954&entry=gmail&source=g>-e01346fa7084-61]
> dict.TrieDictionary:182 : Not a valid value: None
>
> If the field TABLE_VISIT.column2 has a value of 'none' and 'None', it
> returns correctly.
>
>
> How to solve?
>
>
>
> Sincerely,
> Alex
>
>