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
