You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "liyang (JIRA)" <ji...@apache.org> on 2016/06/07 08:59:20 UTC
[jira] [Commented] (KYLIN-1754) UPPER method is not supported when
query fact table
[ 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)