select EXCHANGE_NAME, count(*) from HUOBI_GLOBAL.HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY where HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY.EXCHANGE_NAME = 'b11' group by EXCHANGE_NAME
With Warm regards Billy Liu Yifei Wu <[email protected]> 于2019年1月30日周三 下午3:10写道： > > 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' > > > > > >
