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.
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
514
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
458
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
348
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
759
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
458
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
187
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
213
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
157
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
431
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
183
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
618
views
asked 3 months agolg...