Skip to content

Support window function over global aggregation for UDA #520

@gangtao

Description

@gangtao

I am running a tumble window on a UDA output, which returns an error

Not implemented. Code: 48. DB::Exception: Streaming query doesn't support window func over a global aggregation. (NOT_IMPLEMENTED) (version 1.3.31).

image

Use case

In my case, I am running a tumble window on a output of UDA to caculate what is the throughput of the UDA.

Describe the solution you'd like
support query like this

WITH o AS
  (
    SELECT
      order_update(_tp_time, OrderId, Symbol, Side, OrderQty, OrderType, Price) AS Orders
    FROM
      Orders
  )
SELECT
  window_start, count(*)
FROM
  tumble(o, now(), 1s)
GROUP BY
  window_start

Describe alternatives you've considered

Additional context

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions