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

Posted to dev@kylin.apache.org by Li Yang <li...@apache.org> on 2017/01/07 02:25:18 UTC

Re: Query Error When Use Like in Where Clause

Believe to be the same as https://issues.apache.org/jira/browse/KYLIN-2329

On Fri, Dec 30, 2016 at 5:01 PM, 汪胜 <sk...@163.com> 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.
>
>