discard_reduce_lambda.sql 318 B

123456789
  1. /* postgres can not */
  2. USE plato;
  3. $udf = YQL::@@(lambda '(key stream) (AsStruct
  4. '('key key) '('summ (Collect (Condense stream (Uint32 '0) (lambda '(item state) (Bool 'False)) (lambda '(item state) (Add state item)))))
  5. ))@@;
  6. --INSERT INTO Output
  7. DISCARD REDUCE Input1 ON key USING $udf(cast(value as uint32) ?? 0);