runningDifference/neighbor - deprecated

[Slach]

Need clickhouse-server version specific implementations for macros which apply windows function for macros if possible

[filimonov]

smth like

SELECT 
  t,
  groupArray([type,diff]) as cntDiff
FROM
(
  WITH
    lagInFrame(cnt) OVER (PARTITION BY type ORDER BY t ASC ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS prev_cnt,
    cnt - prev_cnt as diff
  SELECT
    t,
    type,
    diff
  FROM 
  (
    SELECT
      $timeSeries as t, 
      type,
      count() as cnt
    FROM $table 
    WHERE $timeFilter /* AND ... */
    GROUP BY t, type
  )
)
GROUP BY t
ORDER BY t