KYIN查询时间粒度需要按自然周周一统计本周的数据
已有mysql查询语句,不知道怎么转为KYLIN,求助
注:kylin内的按周统计方法是统计的上一周的数据,并且日期超过一年的时候会出现错乱
mysql
SELECT
CASE
WHEN mod (
datediff('2018-12-17', '1920-01-01') - 3,
7
) = 0 THEN
date_sub('2018-12-17', INTERVAL 6 DAY)
ELSE
date_sub(
'2018-12-17',
INTERVAL mod (
datediff('2018-12-17', '1920-01-01') - 3,
7
) - 1 DAY
)
END;
Hive
本周的周一:
case when pmod(datediff(from_unixtime(unix_timestamp(),'yyyy-MM-dd'), '1920-01-01') - 3, 7)=0
then date_sub(from_unixtime(unix_timestamp(),'yyyy-MM-dd'),pmod(datediff(from_unixtime(unix_timestamp(),'yyyy-MM-dd'), '1920-01-01') - 3, 7)+6)
else date_sub(from_unixtime(unix_timestamp(),'yyyy-MM-dd'),pmod(datediff(from_unixtime(unix_timestamp(),'yyyy-MM-dd'), '1920-01-01') - 3, 7)-1) end