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 have a service logs as below format
```
{"date":"2024-03-13T16:19:22.456430Z","stream":"stdout","log":"{\"level\":\"info\",\"message\":\"request arrived - method: GET url:...
0
answers
0
votes
537
views
asked 3 months agolg...
Hi AWS, I was querying Cost and Usage Reports (CURs) using Athena. By default a CloudFormation template gets created and it gets stored inside the bucket where the report is getting stored, however...
1
answers
0
votes
1014
views
asked 3 months agolg...
Is there any way around this?
```
SELECT * FROM event_data
JOIN event_index ON(
event_data.systemid = event_index.systemid AND
event_data.partition_day = event_index.partition_day)
limit...
2
answers
0
votes
540
views
asked 3 months agolg...
I have defined two tables:
```
CREATE EXTERNAL TABLE `event_data`(
`systemid` string COMMENT 'from deserializer',
`eventtime` string COMMENT 'from deserializer',
`eventtype` string COMMENT...
1
answers
0
votes
573
views
asked 3 months agolg...
When other AWS users are trying to access my bucket with their crawler, they are getting the below error.
"Crawler Error:
User does not have access to target s3://test-bucket-mis6389/evdata/"
My s3...
5
answers
0
votes
527
views
asked 3 months agolg...
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
426
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
511
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
441
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
462
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
337
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
719
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...