I have a table in Athena and I am querying it to produce a json resultant file using CTAS queries. But the resultant json file is not maintaining the camel case of either the column name or the alias that was provided for the column name in the query. Please suggest how i can overcome this issue.
For ex:
{"email":"abc_def@ghi.com", "firstname": "abc", "lastname": "def"}
This should be coming up in the json file(result of the Athena query) as:
{"email":"abc_def@ghi.com", "firstName": "abc", "lastName": "def"}
Query that I have tried:
CREATE TABLE users WITH (
format = 'JSON',
bucket_count = 1,
bucketed_by = ARRAY [ 'lastName' ]
) AS
SELECT email,
firstname as "firstName",
lastname as "lastName"
from all_users;