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
359
views
asked a month 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
276
views
asked a month 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
394
views
asked a month 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
215
views
asked a month 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
380
views
asked a month 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
401
views
asked a month 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
151
views
asked a month 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
151
views
asked a month agolg...
I have this table:
```
RetsIncomingTable:
Type: AWS::Glue::Table
Properties:
CatalogId: !Ref AWS::AccountId
DatabaseName: !Ref TheDatabase
TableInput:
Name:...
0
answers
0
votes
139
views
asked a month 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
228
views
asked a month 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
160
views
asked a month agolg...
Sample file:
{
"Messages":[
{"col1":"01",
"col2":["key":"02","value":"03"]
},
{"col1":"01",
"col2":["key":"01","value":"03"]
},
{"col1":"01",
...
1
answers
0
votes
560
views
asked a month agolg...