kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "ning.wang@ymm56.com" <ning.w...@ymm56.com>
Subject 回复: case when问题
Date Tue, 27 Aug 2019 08:13:45 GMT
报错信息:
No realization found for OLAPContext, CUBE_UNMATCHED_AGGREGATION[FunctionDesc [expression=SUM,
parameter=CASE(=($15, 1), $30, 0), returnType=null], FunctionDesc [expression=COUNT_DISTINCT,
parameter=CASE(=($15, 1), $21, null), returnType=null]], rel#928645:OLAPTableScan.OLAP.[](table=[DM_TRADE,
CARGO_MATCH_CARGO_TRANS_DI],ctx=,fields=[0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14,
15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37,
38, 39]) while executing SQL: "select count(distinct unduplication_id) duplication_cargo_count,
count(distinct case when is_24h_feedback=1 then unduplication_id else null end), sum(case
when is_24h_feedback=1 then is_deal else 0 end) from dm_trade.CARGO_MATCH_CARGO_TRANS_DI where
"DAY"=20190802 LIMIT 50000"



ning.wang@ymm56.com
 
发件人: ning.wang@ymm56.com
发送时间: 2019-08-27 15:29
收件人: user
主题: case when问题
我使用的kylin版本是2.5.0,发现case when语法无法使用,是因为我写的有问题还是kylin本身不支持
select 
count(distinct unduplication_id) duplication_cargo_count,
count(distinct case when is_24h_feedback=1 then unduplication_id else null end),
sum(case when is_24h_feedback=1 then is_deal else 0 end)
from dm_trade.CARGO_MATCH_CARGO_TRANS_DI where "DAY"=20190802;

其中is_24h_feedback是一个维度,

报错信息如下:



ning.wang@ymm56.com
Mime
View raw message