[jira] [Updated] (KYLIN-1091) Support string functions like UPPER, LOWER, SUBSTRING in WHERE clause

["Shao Feng Shi (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/KYLIN-1091?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Shao Feng Shi updated KYLIN-1091:
---------------------------------
    Fix Version/s: Backlog

> Support string functions like UPPER, LOWER, SUBSTRING in WHERE clause
> ---------------------------------------------------------------------
>
>                 Key: KYLIN-1091
>                 URL: https://issues.apache.org/jira/browse/KYLIN-1091
>             Project: Kylin
>          Issue Type: Improvement
>          Components: Query Engine
>    Affects Versions: v1.1
>            Reporter: Francesco Palmiotto
>            Assignee: liyang
>            Priority: Major
>             Fix For: Backlog
>
>
> String functions are supported in the SELECT and GROUP BY clauses but not in the WHERE one.
> The exception being thrown is similar to the following:
> LOWER while executing SQL: "
> select lower(d.name), avg(f.my_measure) 
> from fact_table f 
> inner join dim_table d on f.fk_id = d.pk_id 
> where lower(d.name) = 'my_username' 
> group by lower(d.name) 
> LIMIT 50000"



--
This message was sent by Atlassian Jira
(v8.3.4#803005)