CaiNiao-DemandForecast-StoragePlaning icon indicating copy to clipboard operation
CaiNiao-DemandForecast-StoragePlaning copied to clipboard

为什么是取得1,2,3,5,7,9,14天内的累计数据?而不是第1,2,3,5,7,9,14天的单独一天的数据

Open Tongzhenguo opened this issue 7 years ago • 2 comments

为什么是取得1,2,3,5,7,9,14天内的累计数据?而不是第1,2,3,5,7,9,14天的单独一天的数据 代码片段大概是这个样子: SELECT a.* FROM( SELECT a.,DATEDIFF('2015/12/14',DATE)AS days FROM( SELECT a.,FLOOR((DATEDIFF('2015/12/28',DATE)-1)/14) AS watch FROM( SELECT * FROM item_feature )a)a WHERE watch=1)a WHERE days<=3

Tongzhenguo avatar Apr 23 '17 05:04 Tongzhenguo

累计的分层特征更有判别性啊,取单独第i天的特征也不是不可以,效果可能差些,最直接的就是拿数据验证一下

wepe avatar Apr 23 '17 11:04 wepe

恩恩,明白了;多谢大神指教

Tongzhenguo avatar Apr 23 '17 14:04 Tongzhenguo