????: ??????????boolean??????bug, ??????fix

[Na Zhai]

Hi, S*ST????????

Is the type of ??IS_SUC_CONSUME?? boolean? Does that you mean the query result 
is wrong with boolean? Can you try this on Kylin v2.6.1?

?????? Windows 10 ??????<https://go.microsoft.com/fwlink/?LinkId=550986>????

________________________________
??????: S*ST???????? <85318...@qq.com>
????????: Wednesday, March 6, 2019 10:33:32 PM
??????: user
????: ??????????boolean??????bug, ??????fix

kylin 2.3




 SELECT
     count(*)
 FROM
     (select *
     ,VW_FACT_ALLMERGE.PART_SETTLE_DT
     ,VW_FACT_ALLMERGE.IS_SUC_CONSUME
     from INTG.VW_FACT_ALLMERGE as VW_FACT_ALLMERGE )t
 where TRUE
 AND IS_SUC_CONSUME = true
 AND PART_SETTLE_DT='2019-03-01'

????+ boolean+????????, ??????0??????

 SELECT
     count(*)
 FROM
     (select *
     ,VW_FACT_ALLMERGE.PART_SETTLE_DT
     ,VW_FACT_ALLMERGE.IS_SUC_CONSUME
     from INTG.VW_FACT_ALLMERGE as VW_FACT_ALLMERGE )t
 where TRUE
 AND IS_SUC_CONSUME = false
 AND PART_SETTLE_DT='2019-03-01'

=false, ??????: 118448819

 SELECT
     count(*)
 FROM
     (select *
     ,VW_FACT_ALLMERGE.PART_SETTLE_DT
     ,VW_FACT_ALLMERGE.IS_SUC_CONSUME
     from INTG.VW_FACT_ALLMERGE as VW_FACT_ALLMERGE )t
 where TRUE
 AND IS_SUC_CONSUME <> false
 AND PART_SETTLE_DT='2019-03-01'

<>false, ??????: 161496637

 SELECT
     count(*)
 FROM
     (select *
     ,VW_FACT_ALLMERGE.PART_SETTLE_DT
     ,VW_FACT_ALLMERGE.IS_SUC_CONSUME
     from INTG.VW_FACT_ALLMERGE as VW_FACT_ALLMERGE )t
 where TRUE
 AND ORG_TBL = 1
 AND PART_SETTLE_DT='2019-03-01'
 ?6?7

????+??boolean????, ??????261896325

 SELECT
     count(*)
 FROM
     (select *
     ,VW_FACT_ALLMERGE.PART_SETTLE_DT
     ,VW_FACT_ALLMERGE.IS_SUC_CONSUME
     from INTG.VW_FACT_ALLMERGE as VW_FACT_ALLMERGE )t
 where TRUE
 AND IS_SUC_CONSUME = true
 --????????????, ????PART_SETTLE_DT='2019-03-01' ????????

????+??boolean, ??????464169675

 SELECT
     count(*)
 FROM
     (select *
     from INTG.VW_FACT_ALLMERGE as VW_FACT_ALLMERGE )t
 where TRUE
 AND IS_SUC_CONSUME = true
 AND PART_SETTLE_DT='2019-03-01'

??????????+where True, java.lang.String cannot be cast to 
org.apache.kylin.common.util.ByteArray while executing SQL: "SELECT count(*) 
FROM (select * from INTG.VW_FACT_ALLMERGE as VW_FACT_ALLMERGE )t where TRUE AND 
IS_SUC_CONSUME = true AND PART_SETTLE_DT='2019-03-01' LIMIT 50000"

 SELECT
     count(*)
 FROM
     INTG.VW_FACT_ALLMERGE
 where IS_SUC_CONSUME = true
 AND VW_FACT_ALLMERGE.PART_SETTLE_DT='2019-03-01'

??????+??where true + boolean +????????, ??????161496637

 SELECT
     count(*)
 FROM
     INTG.VW_FACT_ALLMERGE
 where True
 AND IS_SUC_CONSUME = true
 AND VW_FACT_ALLMERGE.PART_SETTLE_DT='2019-03-01'

??????+where true, java.lang.String cannot be cast to 
org.apache.kylin.common.util.ByteArray while executing SQL: "SELECT count(*) 
FROM (select * from INTG.VW_FACT_ALLMERGE as VW_FACT_ALLMERGE )t where TRUE AND 
IS_SUC_CONSUME = true AND PART_SETTLE_DT='2019-03-01' LIMIT 50000"