You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@kylin.apache.org by 廉立伟 <li...@huobi.com> on 2019/02/11 09:18:45 UTC

查询结果为0

你好
    select

     count(*)

     from HUOBI_GLOBAL.HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY

    where HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY.EXCHANGE_NAME = 'b11'
我这样查询有结果
但是where条件中为中文结果为0，这个怎么解决呢
    select

     count(*)

     from HUOBI_GLOBAL.HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY

    where HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY.EXCHANGE_NAME = '中国'

结果为0

答复: 查询结果为0

Posted by Na Zhai <na...@kyligence.io>.

Hi，廉立伟.



What’s your Kylin version? There is an issue about Chinese characters: https://issues.apache.org/jira/browse/KYLIN-3705. If your Kylin version is lower than 2.5.2, I advise you to upgrade to the latest Kylin version.



Here are some tips for getting more useful info: check the “Here are some tips for you when encountering problems with Kylin” in this page http://kylin.apache.org/docs/gettingstarted/faq.html



Best wishes!



发送自 Windows 10 版邮件<https://go.microsoft.com/fwlink/?LinkId=550986>应用



________________________________
发件人: 廉立伟 <li...@huobi.com>
发送时间: Monday, February 11, 2019 5:18:45 PM
收件人: dev@kylin.apache.org
主题: 查询结果为0

你好
    select

     count(*)

     from HUOBI_GLOBAL.HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY

    where HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY.EXCHANGE_NAME = 'b11'
我这样查询有结果
但是where条件中为中文结果为0，这个怎么解决呢
    select

     count(*)

     from HUOBI_GLOBAL.HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY

    where HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY.EXCHANGE_NAME = '中国'

结果为0