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

Fix identifiers in KSQL. #2589

Closed
big-andy-coates opened this issue Mar 20, 2019 · 4 comments
Closed

Fix identifiers in KSQL. #2589

big-andy-coates opened this issue Mar 20, 2019 · 4 comments
Assignees
Milestone

Comments

@big-andy-coates
Copy link
Contributor

KSQL can't handle some identifiers, (stream/table/topic/column names), e.g. this is because identifiers need to be valid Java identifiers, which is an avoidable restriction. To make matters worse, quoted identifiers aren't fully supported and we actually recommend NOT using them because of this.

This restricts the data KSQL can work with.

@apurvam
Copy link
Contributor

apurvam commented Mar 21, 2019

Related to #677

@big-andy-coates
Copy link
Contributor Author

closing, as covered by quoted identifiers work

@robcowart
Copy link

@big-andy-coates this issue and a few others that I have come across while trying to solve problems with fields name that are the same as KSQL keywords have been closed with the reason "closing, as covered by quoted identifiers work".

Can you please mention the issue IDs of this "quoted identifiers work", so other like myself don't hit dead ends like this?

Thanks.

@agavra
Copy link
Contributor

agavra commented Dec 9, 2019

@robcowart - I don't think there's a single ticket that describes all the work that was done (there are a ton of issues such as #677 #1287 #1446 #1537 #1765 #1888 #2121 #2171 etc...). Rather, if there's any issue you are running into where the statement doesn't allow you to use reserved names, you should add either double quotes " or backticks ` to your column name (e.g. CREATE STREAM foo ("STREAM" VARCHAR))

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

No branches or pull requests

5 participants