Hi liwei?? Kylin v2.3.2 can not run on CDH6.0 directly and Kylin provides the binary package for CDH6.0 since v2.5.0. Maybe you can upgrade your Kylin to v2.5.2. ------------------ Best Regards, Chao Long
------------------ ???????? ------------------ ??????: "??????"<lianli...@huobi.com>; ????????: 2019??1??31??(??????) ????1:26 ??????: "dev@kylin.apache.org"<dev@kylin.apache.org>;"dev@kylin.apache.org"<dev@kylin.apache.org>; ????: Re: ?????????? ???? Cdh6.0.1????????kylin2.3.2?????? ???? Outlook for iOS<https://aka.ms/o0ukef> ________________________________ ??????: penphi than <dethr...@gmail.com> ????????: ??????, ???? 31, 2019 10:32 ??????: dev@kylin.apache.org ????: Re: ?????????? ??????????hive????????varchar????????????????trim?????? ???????????????????????? 11,4362,2012-01-01, ABIN,175750,0,12,10000096,218.14,668, TEST129 SELECT count(*) from test_kylin_fact where lstg_format_name = ' ABIN' ??????????????0?? ???????????????????????? 11,4362,2012-01-01,a ABIN,175750,0,12,10000096,218.14,668, TEST129 SELECT count(*) from test_kylin_fact where lstg_format_name = 'a ABIN' ??????????????1?? ????????????????????????????trim?????????????????????????? ????????????????trim???????????????????????????????????? On Thu, Jan 31, 2019 at 9:40 AM ?????? <lianli...@huobi.com> wrote: > ????????????????hive?????????????? ????????hive??select?????? > ????trim???????????? > > ???? Outlook for iOS<https://aka.ms/o0ukef> > > ________________________________ > ??????: penphi than <dethr...@gmail.com> > ????????: ??????, ???? 31, 2019 09:33 > ??????: dev@kylin.apache.org > ????: Re: ?????????? > > ??????????????????????????????SQL???????? > ??????????????????????????????????SQL???????????????????? > ?????????????????????????????????????????????? > > ???????????????????????????????????????????????????????????????????? > ??????DBA???????????????????????????????????????????????????????????????? > > ??????????????????????trim?????? > > On Thu, Jan 31, 2019 at 9:14 AM ?????? <lianli...@huobi.com> wrote: > > > ???? ??trim???????? ????????trim???? ???????? ???????????? > > > > ???? Outlook for iOS<https://aka.ms/o0ukef> > > > > ________________________________ > > ??????: penphi than <dethr...@gmail.com> > > ????????: ??????, ???? 31, 2019 09:00 > > ??????: dev@kylin.apache.org > > ????: Re: ?????????? > > > > trim(HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY.EXCHANGE_NAME) > > > > ?????????????????????????????? > > > > ???? Outlook for Android<https://aka.ms/ghei36> > > > > ________________________________ > > From: ?????? <lianli...@huobi.com> > > Sent: Thursday, January 31, 2019 8:47:02 AM > > To: dev@kylin.apache.org; dev@kylin.apache.org > > Subject: Re: ?????????? > > > > ????like?????????????? ??????????????????0 ???????????????????????????? > > > > ???? Outlook for iOS<https://aka.ms/o0ukef> > > > > ________________________________ > > ??????: penphi than <dethr...@gmail.com> > > ????????: ??????, ???? 31, 2019 01:01 > > ??????: dev@kylin.apache.org > > ????: Re: ?????????? > > > > ?????????? like `%b11%` ????????????b11 > > > > ???????????????? > > > > ???? Outlook for Android<https://aka.ms/ghei36> > > > > ________________________________ > > From: Billy Liu <billy...@apache.org> > > Sent: Wednesday, January 30, 2019 8:56:38 PM > > To: dev > > Subject: Re: ?????????? > > > > 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 <vafuler...@gmail.com> ??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????????????<lianli...@huobi.com> ????: > > > > > > 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 <li.f...@kyligence.io> > > > ????????: ??????, ???? 30, 2019 13:15 > > > ??????: dev@kylin.apache.org > > > ????: 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????????????<lianli...@huobi.com> ????: > > > > > > ?????????? ???????????? > > > > > > ???? Outlook for iOS<https://aka.ms/o0ukef> > > > > > > ________________________________ > > > ??????: ?????? <lianli...@huobi.com> > > > ????????: ??????, ???? 30, 2019 10:23 > > > ??????: dev@kylin.apache.org > > > ????: 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??<taojia...@gmail.com> ????: > > > > > > select > > > count(*) > > > from HUOBI_GLOBAL.HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY > > > where HUOBI_YUNYING_DW_KYLIN_USER_INDEX_DAILY.EXCHANGE_NAME = 'b11' > > > > > > > > > > > > > > > > > > > > >