You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Great library! I've been using it to execute and capture the results of a variety of Athena SQL commands. They all work apart from the CREATE TABLE AS.
When I execute the following I get a NoSuchKey: The specified key does not exist. error.
Further investigation is suggesting that the NoSuchKey is an attempt to read output from the S3 bucket that was defined when the athena-client was configured. Normally that would be possible since the execution of athena commands triggers the output of results into that bucket. However, a CTAS command does not work in the same way - its results are the table it created. That table could be created anywhere. Therefore attempts to use the result.queryExecution.ResultConfiguration.OutputLocation variable wont be successful as the file is not created.
@mathoshek Sorry I was not able to get it to work directly. Instead I played with a route where I wrote the output to a bucket. I then created an athena external table from that bucket and re-read the data.
Unfortunately that doesn't really improve the performance :(
Great library! I've been using it to execute and capture the results of a variety of Athena SQL commands. They all work apart from the CREATE TABLE AS.
When I execute the following I get a
NoSuchKey: The specified key does not exist.
error.The text was updated successfully, but these errors were encountered: