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

SQL error #50

Closed
krisajenkins opened this issue Oct 22, 2021 · 0 comments
Closed

SQL error #50

krisajenkins opened this issue Oct 22, 2021 · 0 comments

Comments

@krisajenkins
Copy link
Contributor

I'm getting this error when I run " FIND HIGH-VALUE STOCK TRADES FOR REVIEW":

2021-10-22 09:45:53.094 ERROR 62325 --- [nio-8080-exec-4] o.a.c.c.C.[.[.[/].[dispatcherServlet]    : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is java.util.concurrrent.ExecutionException: io.confluent.ksql.api.client.exception.KsqlClientException: Received 400 response from server: line 4:5: mismatched input 'U' expecting {',', 'FROM'}. Error code: 40001] with root cause

io.confluent.ksql.api.client.exception.KsqlClientException: Received 400 response from server: line 4:5: mismatched input 'U' expecting {',', 'FROM'}. Error code: 40001
        at io.confluent.ksql.api.client.impl.ClientImpl.lambda$handleErrorResponse$24(ClientImpl.java:607) ~[ksqldb-api-client-0.21.0.jar!/:na]
        at io.vertx.core.http.impl.HttpClientResponseImpl$BodyHandler.notifyHandler(HttpClientResponseImpl.java:292) ~[vertx-core-3.9.8.jar!/:3.9.8]
        at io.vertx.core.http.impl.HttpClientResponseImpl.lambda$bodyHandler$0(HttpClientResponseImpl.java:193) ~[vertx-core-3.9.8.jar!/:3.9.8]

Looks like a missing comma after the first column in the query:

SELECT U.ID USERID
    U.REGIONID REGION,

I'll see if I can fix it, but I'm logging it here first in case I don't get to it. :-)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant