Could not determine output schema for query due to error

Hello community,
I get an error response when I just try to use the ksql example from the confluent page:

CREATE TABLE foo AS
SELECT * FROM bar
WINDOW TUMBLING (size 10 seconds)
EMIT CHANGES;

Response:
"Could not determine output schema for query due to error: Line: 3, Col: 8: WINDOW clause requires a GROUP BY clause. "

Why do I net a group by clause there?

Thank you in advance!

Seems the error message is bad… (Could you file a ticket on Github about it?)

If you use WINDOW TUMBLING you also need to use GROUP BY clause. Windowing is an aggregation feature.

This topic was automatically closed after 30 days. New replies are no longer allowed.