Re: 查询无结果

Yifei Wu Tue, 29 Jan 2019 23:11:02 -0800

Hi, liwei,
It sounds like a Kylin Query bug, could you open a jira to describe this 
question and how to reproduce this question in detail, for it be very helpful 
for 
Locating the root cause.


BR
Yifei Wu 


在 2019/1/30 下午2:49，“廉立伟”<[email protected]> 写入:

    select
    
    count(*),EXCHANGE_NAME
    
    from HUOBI_GLOBAL.HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY
    
    group by EXCHANGE_NAME
    
    order by EXCHANGE_NAME
    这样的话有结果   有b11  但是where的时候就没有
    
    获取 Outlook for iOS<https://aka.ms/o0ukef>
    
    ________________________________
    收件人: Li Feng <[email protected]>
    发送时间: 星期三, 一月 30, 2019 13:15
    收件人: [email protected]
    主题: Re: 查询无结果
    
    Hi Liwei
    Try
    select
    count(*),EXCHANGE_NAME
    from HUOBI_GLOBAL.HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY
    group by EXCHANGE_NAME
    order by EXCHANGE_NAME
    and check whether there exists 'b11' value.
    BR,
    Lee
    在 19/1/30 下午1:08，“廉立伟”<[email protected]> 写入:
    
    怎么没结果 你们解决下呀
    
    获取 Outlook for iOS<https://aka.ms/o0ukef>
    
    ________________________________
    收件人: 廉立伟 <[email protected]>
    发送时间: 星期三, 一月 30, 2019 10:23
    收件人: [email protected]
    主题: Re: 查询无结果
    
    这样查询结果为0，但是我的数据中确实有EXCHANGE_NAME = 'b11'，怎么查不出来呢
    select
    count(*)
    from HUOBI_GLOBAL.HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY
    where HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY.EXCHANGE_NAME = 'b11'
    
    
    在 2019/1/30 上午10:21，“JiaTao Tao”<[email protected]> 写入:
    
    select
    count(*)
    from HUOBI_GLOBAL.HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY
    where HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY.EXCHANGE_NAME = 'b11'

Re: 查询无结果

Reply via email to