[jira] [Created] (KYLIN-1754) UPPER method is not supported when query fact table

[zhou degao (JIRA)]

zhou degao created KYLIN-1754:
---------------------------------

             Summary: 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)