[ https://issues.apache.org/jira/browse/KYLIN-1754?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15318175#comment-15318175 ]
liyang commented on KYLIN-1754: ------------------------------- This should work. UPPER(constant) currently is not supported but is easy to work around. select count( * ) from FACT_PV_DATA_TEST where UPPER(PRODUCT_NAME)='BLOG' > UPPER method is not supported when query fact table > --------------------------------------------------- > > 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)