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"
