[
https://issues.apache.org/jira/browse/KYLIN-1754?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16050130#comment-16050130
]
sunzaizhi commented on KYLIN-1754:
----------------------------------
follow up
this issue seems not been fixed in version 1.6 and 2.0,as below:
{code:sql}
select USER_TYPE
from COHORT_TRANSITION_OPERATIONS
where UPPER(USER_TYPE) = UPPER('abcd')
limit 10
with error：Error while executing SQL "select USER_TYPE from
COHORT_TRANSITION_OPERATIONS where UPPER(USER_TYPE) = UPPER('abcd') limit 10":
null
{code}
> UPPER(constant) is not supported
> --------------------------------
>
> Key: KYLIN-1754
> URL: https://issues.apache.org/jira/browse/KYLIN-1754
> Project: Kylin
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: v1.5.2
> Environment: centos kylin 1.5.2
> Reporter: zhou degao
> Assignee: liyang
> Labels: newbie
>
> select count(*) from FACT_PV_DATA_TEST where
> UPPER(PRODUCT_NAME)=UPPER('blog');
> I got following error:
> Error while executing SQL "select count(*) from FACT_PV_DATA_TEST where
> UPPER(PRODUCT_NAME)=UPPER('blog') LIMIT 50000": null
> it will be successful if we query it like:
> select count(*) from FACT_PV_DATA_TEST where (PRODUCT_NAME)=('blog');
> And UPPER method is supported when query lookup table.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
