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.
How to create separate Glue Catalog table on single S3 bucket with various different types of fileslg...
Hi,
I have to create/generate a separate individual Glue Catalog tables by crawaling single S3 bucket based on different types of files.
Suppose, I have S3 bucket as...
2
answers
0
votes
631
views
asked 9 months agolg...
Hi,
I'm trying to query some data in parquet files in Athena, but I have two columns that are timestamp but they don't have mls. The date format is in varchar like: '2023-08-09 15:41:42'.
I'm trying...
1
answers
0
votes
822
views
asked 9 months agolg...
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
2531
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
228
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
671
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
794
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
244
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
372
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
236
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
301
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
515
views
asked 9 months agolg...