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.
Athena has started giving suggestions when you are typing, called typeahead, which can be switched on or off.
I would like these on as they are very useful, but every time you click on a suggestion...
1
answers
0
votes
153
views
asked 9 months agolg...
HI,
I have 2 AWS accounts.
I have enabled cross account access for S3 and Glue artifacts.
Acc A has data in S3 Buckets.
Acc B is reading the data using Athena.
I am using SSE with KMS (SSE-KMS)
I...
1
answers
0
votes
343
views
asked 9 months agolg...
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
611
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
804
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
2403
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
225
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
647
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
782
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
236
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
362
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
233
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...