kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ShaoFeng Shi <shaofeng...@apache.org>
Subject Re: A problem about retention rate analyze
Date Thu, 07 Dec 2017 14:53:15 GMT
Hi Sky,

What's the error you got when querying just one intersect_count? Besides,
what's your Kylin version?

2017-12-07 16:22 GMT+08:00 skyyws <skyyws@163.com>:

> Hi guys,
> I found that kylin supported retention rate analyze function, so I made
> some test for this function. The following SQL executed successful:
> ------------------------------------------------------------
> -----------------------------------------------------------
>
>
>
>
>
>
>
>
> *select city, version,intersect_count(uuid, dt, array['20161014']) as
> first_day,intersect_count(uuid, dt, array['20161015']) as
> second_day,intersect_count(uuid, dt, array['20161016']) as
> third_day,intersect_count(uuid, dt, array['20161014', '20161015']) as
> retention_oneday,intersect_count(uuid, dt, array['20161014', '20161015',
> '20161016']) as retention_twodayfrom visit_logwhere dt in ('2016104',
> '20161015', '20161016')group by city, version*
> ------------------------------------------------------------
> -----------------------------------------------------------
> but, other SQLs executed failed like this:
> ------------------------------------------------------------
> -----------------------------------------------------------
>
> *select city, version, intersect_count(uuid, dt, array['20161014',
> '20161015']) as retention_onedayfrom visit_log where dt in ('2016104',
> '20161015',) group by city, version*
> ------------------------------------------------------------
> -----------------------------------------------------------
>
> *select city, version,intersect_count(uuid, dt, array['20161014',
> '20161015', '20161016']) as retention_twodayfrom visit_log where dt in
> ('2016104', '20161015', '20161016') group by city, version*
> ------------------------------------------------------------
> -----------------------------------------------------------
> which means I cannot use just one intersect_count UDAF in a SQL, at lease
> two intersect_count, is this a bug or designed to do so?
>
> 2017-12-07
> ------------------------------
> skyyws
>



-- 
Best regards,

Shaofeng Shi 史少锋

Mime
View raw message