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'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
98
views
asked 16 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
172
views
asked 20 days 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
198
views
asked 20 days 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
216
views
asked 20 days 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
262
views
asked 22 days 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
45
views
asked 22 days 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
67
views
asked 22 days agolg...
Hi,
I am querying an external partitioned table in redshift spectrum and it throws an error. The data is stored in S3, parquet files and one of the column is 'BINARY'. If i remove the partition column...
0
answers
0
votes
70
views
asked 23 days agolg...
Hello,
I have parquets files in S3 that i parse using Glue Crawler and query in Athena. I found that some files have two columns "x" and "y" that have a type **int64** while other files have them as...
1
answers
0
votes
219
views
asked 23 days agolg...
I've imported a dataset of JSON objects that all have consistent schema. Glue crawler finished successfully and created a table. I can select * with a limit in Athena, but when I select all rows I get...
1
answers
1
votes
290
views
asked 23 days agolg...
I'm trying to update iceberg table with Athena Client in AWS lambda but getting COMMIT error.
My query runs about 100 queries at a time, and the time interval for generating a query is within 1 to 2...
1
answers
0
votes
150
views
asked 24 days agolg...
I've been getting a slew of INSUFFICIENT errors from CloudFront in the last week.
I'm attempting to use Athena to discover what is happening with these 5xx Error Rates. I have a database already...
3
answers
0
votes
109
views
asked 24 days agolg...