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.
The way we have EXCEPT or MINUS in Redshift to know difference between two tables in Redshift - do we have something similar in Athena?
Accepted AnswerAmazon Athena
1
answers
0
votes
2360
views
asked 9 months agolg...
Hi,
New to AWS! I'm running a crawler through a folder in an s3 bucket of roughly 1000 files which are a mix of xlsx and csv. I want the crawler to pass the csv files into a table that I will...
1
answers
0
votes
223
views
asked 9 months agolg...
Recurring Issue with AWS Athena When Running Queries on Iceberg Table.
Description
I am trying to run queries on an Iceberg table using AWS Athena. The data is stored in S3, and I am using EMR...
1
answers
0
votes
639
views
asked 9 months agolg...
Hi all,
I have an error message when I want to query Waf logs with Athena following these procedures described here below
https://docs.aws.amazon.com/athena/latest/ug/waf-logs.html
I created a...
1
answers
0
votes
779
views
asked 9 months agolg...
Greetings
I hope you are having a great day.
We were trying to create a Data Wrangler on AWS SageMaker to retrieve our data from AWS Athena to AWS SageMaker. We had this error while specifying the...
1
answers
0
votes
233
views
asked 9 months agolg...
Hello,
I'm playing around with Session Manager and I enabled logging to S3 Bucket, however logs are sent to the S3 bucket in a raw format and that makes it unpossible to query through the Athena...
1
answers
0
votes
357
views
asked 9 months agolg...
Hello
I created a simple UDF and I am using it in the WHERE clause. It works only if the query has only one table. If I have a JOIN then query throws `GENERIC_INTERNAL_ERROR: Internal error` and no...
1
answers
0
votes
231
views
asked 9 months agolg...
DataSource.Error: ODBC: ERROR [HY000] [Simba][Athena] (1040) An error has been thrown from the AWSlg...
Hi all,
I am using the Power BI AWS Athena Connector with Simba Athena ODBC driver to import data in Power BI Desktop.
At this stage, I have connected to the data source with the following...
0
answers
0
votes
110
views
asked 9 months agolg...
I am trying to use Amazon Grafana with files on Amazon S3. For that, I need to change the date format of the original file to fit on Grafana. I use the following command :
SELECT...
1
answers
0
votes
296
views
asked 9 months agolg...
Getting error from Athena Redshift connector "Error: Runtime exited with error: signal: killed"lg...
Lambda dies after 25-30 seconds with no other messages than "Error: Runtime exited with error: signal: killed". Attempted to expand memory and storage limits for Lambda to the max, no luck. Please...
1
answers
0
votes
471
views
asked 9 months agolg...
Is there a way that we can troubleshoot or find some more info based on "x-amz-cf-id:" ?
Usually,I need to give this ID to support team and then they come up with the analysis.Is it possible from...
1
answers
0
votes
349
views
asked 9 months agolg...
Hi Team,
I have requirement to access S3 bucket which exists in AWS account (say Account A) from Account B using Athena. I had done following setup for this :-
In Account A:-
* Added bucket policy...
2
answers
0
votes
1230
views
asked 9 months agolg...