[
https://issues.apache.org/jira/browse/KYLIN-1091?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Francesco Palmiotto updated KYLIN-1091:
---------------------------------------
Description:
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"
was:
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"
> 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 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
(v6.3.4#6332)
