[ https://issues.apache.org/jira/browse/KYLIN-1754?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
liyang updated KYLIN-1754: -------------------------- Summary: UPPER(constant) is not supported (was: UPPER method is not supported when query fact table) > 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 > > 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.3.4#6332)