Huang Hua created KYLIN-1024:
--------------------------------
Summary: UPPER not support in Kylin
Key: KYLIN-1024
URL: https://issues.apache.org/jira/browse/KYLIN-1024
Project: Kylin
Issue Type: Sub-task
Components: Query Engine
Affects Versions: v0.7.1, v0.7.2, v1.0
Reporter: Huang Hua
Assignee: liyang
Priority: Minor
UPPER function doesn't work in WHERE clause,
"org.apache.kylin.rest.exception.InternalErrorException: UPPER while executing
SQL":
select "MONDRIAN_REGION"."REGION_PROVINCE" as "c0",
"MONDRIAN_REGION"."REGION_COUNTRY" as "c1"
from "MONDRIAN_REGION" as "MONDRIAN_REGION"
where ("MONDRIAN_REGION"."REGION_COUNTRY" = '??') and
UPPER("MONDRIAN_REGION"."REGION_PROVINCE") = UPPER('??')
group by "MONDRIAN_REGION"."REGION_PROVINCE",
"MONDRIAN_REGION"."REGION_COUNTRY"
order by CASE WHEN "MONDRIAN_REGION"."REGION_PROVINCE" IS NULL THEN 0 ELSE 1
END, "MONDRIAN_REGION"."REGION_PROVINCE" ASC
LIMIT 50000
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
