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 am in query editor, and found my 6 query files were gone, how to recover the query i saved in my account ?
1
answers
0
votes
434
views
asked 3 months agolg...
Currently I'm trying to get data source from Athena in AWS Grafana.
Under the section - Apps/AWS Data Sources/Data sources, I selected Service as 'Athena' and when i select the Regions as 'Asia...
0
answers
0
votes
515
views
asked 3 months agolg...
I need to replicate an iceberg datalake stored in S3 from one bucket to another. However, multi-region access point doesn't work with Athena table. And I don't see any pyspark procedure that could...
1
answers
0
votes
461
views
asked 3 months agolg...
When creating a table with a leading space in the name, AWS Glue does not display any error during the creation process. However, upon checking the API logs, I noticed that the space is present in the...
1
answers
0
votes
470
views
asked 3 months agolg...
Why does this query fail in Athena:
```
`SELECT COUNT (title) FROM "s3_library_data" WHERE s3_library_data.genre = "Science Fiction"`
```
but this one works?
```
`SELECT COUNT (title) FROM...
Accepted AnswerAmazon Athena
1
answers
0
votes
351
views
asked 3 months agolg...
I use athena to do direct query in quicksight, I have a table in dynamodb called history and in that table I have a column called "management", it was added recently but my athena does not reflect...
3
answers
0
votes
765
views
asked 3 months agolg...
Hello, I am trying to use Bedrock **Titan Express** model to convert text2sql using langchain. I am able to generate **an almost valid** sql statement but except string literal are being...
2
answers
0
votes
460
views
asked 3 months agolg...
I'm experiencing an issue with AWS Athena when trying to compile a table from millions of small, partitioned S3 objects. I haven't specified where the table should be saved, and I'm encountering a...
1
answers
0
votes
188
views
asked 3 months agolg...
Hello,
I have a CSV file stored in the S3 bucket that is being updated daily. The CSV file has several tabs. each tab is a different table. I want to use this CSV file as a DB in QuickSight AWS.
I use...
2
answers
1
votes
217
views
asked 3 months agolg...
I have this table:
```
RetsIncomingTable:
Type: AWS::Glue::Table
Properties:
CatalogId: !Ref AWS::AccountId
DatabaseName: !Ref TheDatabase
TableInput:
Name:...
0
answers
0
votes
159
views
asked 3 months agolg...
Hello,
I have an Excel file stored in S3 bucket.
After running a crawler and creating a table I'm trying to see the table in Athena and getting this error:
COLUMN_NOT_FOUND: line 1:8: SELECT * not...
2
answers
0
votes
437
views
asked 3 months agolg...
I have an iceberg table defined like this:
CREATE TABLE IF NOT EXISTS staging (
id STRING,
staging_timestamp BIGINT,
... blah blah blah ...
)
PARTITIONED BY...
0
answers
0
votes
184
views
asked 3 months agolg...