kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From alex wang <hello123...@gmail.com>
Subject kylin 'not in' returns the result is empty.
Date Fri, 29 Sep 2017 07:17:51 GMT
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-e01346fa7084-61] dict.TrieDictionary:182
: Not a valid value: none
2017-09-28 17:50:55,539 ERROR [Query 162a900a-9f11-4c22-b954-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


Mime
View raw message