kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "fengbin"<feng...@didachuxing.com>
Subject 转发:Error result with this SQL
Date Fri, 20 Apr 2018 10:38:24 GMT
原始邮件
发件人:fengbinfengbin@didachuxing.com
收件人:dev@kylin.apache.org
发送时间:2018年4月20日(周五) 18:38
主题:Error result with this SQL


This SQL result is error.
SELECT COUNT(DISTINCT VIEW_TAXI_RIDE.PASSENGER_ID)
FROM VIEW_TAXI_RIDE
WHERE
VIEW_TAXI_RIDE.create_day = '2018-04-10'
AND VIEW_TAXI_RIDE.STATUS IN (6,7)
AND VIEW_TAXI_RIDE.PASSENGER_ID IN
( SELECT DISTINCT v.PASSENGER_ID FROM view_taxi_ride v WHERE v.create_day = '2018-04-11' AND
v.STATUS IN (6,7) )


Bug this SQL result is right.
select intersect_count(passenger_id, create_day, array['2018-04-10','2018-04-11']) from VIEW_TAXI_RIDE
where STATUS IN (6,7)
Mime
View raw message