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.
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
342
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
725
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
454
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
185
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
209
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
155
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
420
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
181
views
asked 3 months agolg...
Sample file:
{
"Messages":[
{"col1":"01",
"col2":["key":"02","value":"03"]
},
{"col1":"01",
"col2":["key":"01","value":"03"]
},
{"col1":"01",
...
1
answers
0
votes
612
views
asked 3 months agolg...
Athena backfillinglg...
Hello!
Would like to understand in case of any incidents, is there a good way to backfill data in Athena? Is there any guidance or existing script we can make use of?
Thanks!
1
answers
0
votes
210
views
asked 3 months agolg...
Directed from Andes table to Athena and query errors with
```
HIVE_UNKNOWN_ERROR: Can not create a Path from an empty string
This query ran against the "andes" database, unless qualified by the...
Accepted AnswerAmazon Athena
2
answers
0
votes
229
views
asked 3 months agolg...
At every 30 minutes it saying "ICEBERG_VACUUM_MORE_RUNS_NEEDED: Removed 20000 files in this round of vacuum" but when I calculate the my table metadata size it didn't changed before and after the...
2
answers
0
votes
436
views
asked 3 months agolg...