Believe to be the same as https://issues.apache.org/jira/browse/KYLIN-2329
On Fri, Dec 30, 2016 at 5:01 PM, 汪胜 <[email protected]> wrote: > Hello， > I execute a sql below: > > > select PRODUCT_LOOKUP.PRODUCT_NAME,SUM(SALES_FACT.STORE_SALES) from > SALES_FACT > inner join PRODUCT_LOOKUP on PRODUCT_LOOKUP.PRODUCT_ID= > SALES_FACT.PRODUCT_ID > where PRODUCT_LOOKUP.PRODUCT_NAME like '%' || 'Label' || '%' > group by PRODUCT_LOOKUP.PRODUCT_NAME > > > And this is result: > > > Error while executing SQL "select > PRODUCT_LOOKUP.PRODUCT_NAME,SUM(SALES_FACT.STORE_SALES) > from SALES_FACT inner join PRODUCT_LOOKUP on > PRODUCT_LOOKUP.PRODUCT_ID=SALES_FACT.PRODUCT_ID > where PRODUCT_LOOKUP.PRODUCT_NAME like '%' || 'Label' || '%' group by > PRODUCT_LOOKUP.PRODUCT_NAME LIMIT 50000": null > > > I found there is a bug when I used "like '%' || 'Label' || '%'" in sql > sentence. But when I changed filter into "like '%Label%'", the result is > correct. > Kylin generated "BuildInFunctionTupleFilter" for " like '%' || 'Label' || > '%' ", and thus got a null column, and finally errored when used this null > column to get dict. > >
