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

Support lower case fieldNames in partitioning for s3 #836

Open
mam8270 opened this issue Feb 27, 2022 · 0 comments
Open

Support lower case fieldNames in partitioning for s3 #836

mam8270 opened this issue Feb 27, 2022 · 0 comments

Comments

@mam8270
Copy link

mam8270 commented Feb 27, 2022

Issue Guidelines

Amazon s3 partition structure requires lowercase names when used with athena, but there is a not an easy way to achieve this.
https://docs.aws.amazon.com/athena/latest/ug/partitions.html#partitions-considerations-limitations

Based on the documentation I would expect something like this to work:
SELECT userId AS 'userid' PARTITIONBY 'userid'

This doesn't seem to work and publishes the uppercase field name. There actually doesn't seem to be any good way when using partionby and a json document to partition on the lower case version of the field.

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

2 participants