Francesco Palmiotto created KYLIN-1091:
------------------------------------------
Summary: 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
String functions are supported in the SELECT and GROUP BY clauses but not in
the WHERE one.
The exception been 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
(v6.3.4#6332)
