You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@kylin.apache.org by "nichunen (Jira)" <ji...@apache.org> on 2019/10/29 11:45:00 UTC

[jira] [Resolved] (KYLIN-1024) UPPER not support in Kylin

     [ 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)