Questions tagged with Amazon Athena
Content language: English
Select up to 5 tags to filter
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
Hello,
I am storing some AWS Batch and CloudWatch logs on S3 in CSV format. I wrote a python script that gets data for the past 24 hours. With this data, I am going to use Athena to grab the data in...
2
answers
0
votes
328
views
asked 12 days agolg...
Athena query failed with error:
```
Amazon Athena experienced an internal error while executing this query. Please try submitting the query again and if the issue reoccurs, contact AWS support for...
1
answers
0
votes
81
views
asked 13 days agolg...
I have an int stored in my s3 file and the table has int as a type. However, randomly athena seems to be adding a .0 to the end of the int for some files and not others and returning the following...
Accepted AnswerAmazon Athena
1
answers
0
votes
64
views
asked 13 days agolg...
This was working before, as recently as a week or two ago but Athena now fails with "INVALID_PARAMETER_USAGE: Incorrect number of parameters: expected 207 but found 0." when the query has more than...
0
answers
0
votes
73
views
asked 14 days agolg...
I'm having the same issue. Data is stored in below format in s3 as JSON array with partitions
S3 path - s3://fleet-fuelcard-data-import-dev/lambda/fuelsoft-morgan/660306/2024/Apr/03-Apr-2024.json....
1
answers
0
votes
295
views
asked 20 days agolg...
I'm trying to execute queries in Athena that involve multiple tables using joins. However, when I attempted to run several queries simultaneously (8 queries), I encountered the error. To address this,...
1
answers
0
votes
105
views
asked 22 days agolg...
I have created Redshift data source from Athena Console using Lambda Connector.
while giving configurations in Lambda connector, we need to give Redshift JDBC URL which is supporting the following...
1
answers
0
votes
175
views
asked a month agolg...
Hi All,
Before adding this question i have seen couple of responses for similar use cases but could not figure out the answers as im beginner in SQL coding. Im trying to query the table...
1
answers
0
votes
382
views
asked a month agolg...
Apache Iceberg version
None
Query engine
Athena (engine v3)
Hello everyone, today my team incurred in a very strange bug using Iceberg via Athena. I'll descrive the steps we used to reproduce the...
0
answers
0
votes
389
views
asked a month agolg...
Hello, I am relatively new to Glue and encountering some challenges with Glue ETL.
Our setup involves a datalake that retrieves data from a backend database as its source. This datalake is...
1
answers
0
votes
273
views
asked a month agolg...
Is there a way for members of a datazone project to connect to Power BI and view the datasets they subscribed to?
0
answers
0
votes
49
views
asked a month agolg...
Is there any way to configure AWS Athena to add proper file extension?
Say `CTAS` query creates Parquet files but with no extension at all.
Accepted AnswerAmazon Athena
1
answers
0
votes
72
views
asked a month agolg...