Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

KSQL 5.4 Error message needs clarifying #3524

Closed
rmoff opened this issue Oct 10, 2019 · 0 comments · Fixed by #3540
Closed

KSQL 5.4 Error message needs clarifying #3524

rmoff opened this issue Oct 10, 2019 · 0 comments · Fixed by #3540

Comments

@rmoff
Copy link
Contributor

rmoff commented Oct 10, 2019

The example given in this error is not precise enough:

ksql> SELECT * FROM CUSTOMERS;
Table 'CUSTOMERS' is not materialized. KSQL currently only supports static queries on materialized aggregate tables. i.e. those created by a 'CREATE TABLE AS SELECT <fields> FROM <sources> GROUP BY <key>' style statement.

ksql> CREATE TABLE FOO AS SELECT ID, FIRST_NAME FROM CUSTOMERS_REKEYED GROUP BY ID, FIRST_NAME;
GROUP BY requires columns using aggregate functions in SELECT clause.
ksql>

We should replace the text in the message:

CREATE TABLE AS SELECT <fields> FROM <sources> GROUP BY <key>

with

CREATE TABLE AS SELECT <fields>,<aggregate_functions> FROM <sources> GROUP BY <key>
big-andy-coates added a commit to big-andy-coates/ksql that referenced this issue Oct 11, 2019
@big-andy-coates big-andy-coates self-assigned this Oct 11, 2019
@big-andy-coates big-andy-coates added this to To do in Pull Queries via automation Oct 25, 2019
@big-andy-coates big-andy-coates moved this from To do to Done in Pull Queries Oct 25, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
Pull Queries
  
Done
Development

Successfully merging a pull request may close this issue.

2 participants