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.
I wrote a python code that uploads data to S3 in csv format daily. I formatted the file name like this: 'some_data_YY_MM_DD.csv'. Using Athena, I want to query from the past 7 days of data.
1. Is...
3
answers
0
votes
651
views
asked 13 days agolg...
Facing the following error when using 2 jobs and 1 crawler:
Job 1: changing the schema and saving the csv file as parquet in S3.
Job 2: ETL Process
Crawler: Saving it in the AWs Glue Datacatalog...
1
answers
0
votes
607
views
asked 13 days agolg...
I have creat the grafana dashbaord ,but when i tying to use time series getting was showing Data is missing a number field .
Present iam using the python code i will update every minute new data to...
1
answers
0
votes
284
views
asked 14 days agolg...
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
346
views
asked 17 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
84
views
asked 17 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
67
views
asked 18 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
74
views
asked 18 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
306
views
asked 25 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
117
views
asked a month 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
180
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
390
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
393
views
asked a month agolg...