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 <[email protected]> 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 > >
