[
https://issues.apache.org/jira/browse/KYLIN-1024?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
nichunen resolved KYLIN-1024.
-----------------------------
Resolution: Fixed
> 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: luguosheng
> Priority: Minor
> Fix For: v3.0.0
>
>
> 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
(v8.3.4#803005)
