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.
athena query errorlg...
Hi Team,
When iam run querry facing error, Kindly support anyone please
SELECT * not allowed from relation that has no columns
This query ran against the "penguin-landing-data" database, unless...
Accepted AnswerAmazon Athena
1
answers
0
votes
320
views
asked 8 months agolg...
Glue table recreation causes GENERIC_INTERNAL_ERROR: io.trino.spi.block.VariableWidthBlockBuilderlg...
It seems like there is an issue with the management of glue tables under the hood?
We have data pipelines that have recently started failing on all our raw glue tables, where downstream tables...
1
answers
1
votes
269
views
asked 8 months agolg...
Hi,
I'have deployed dashboards and trying to mapping account id with names. I'm following this...
1
answers
0
votes
486
views
asked 8 months agolg...
I'm following the Well Architected Lab religiously: https://www.wellarchitectedlabs.com/cost/200_labs/200_cloud_intelligence/cost-usage-report-dashboards/
When trying the create the CUDOS dashboards...
1
answers
0
votes
279
views
asked 8 months agolg...
I am working on a view in Athena, which requires being able to do the following, identify the time of each work experience, using the number of months, days and count how many jobs you have had in...
1
answers
0
votes
285
views
asked 8 months agolg...
I want to disable the 'Copy' button in Athena for an IAM role.
The Download permission is already denied for this role using 'aws:calledViaLast' condition. But the user can still copy data using the...
Accepted AnswerAmazon Athena
1
answers
0
votes
267
views
asked 8 months agolg...
I am testing a Glue data source for Athena has been configured to point to the catalog ID of the same account (i.e. in AccountA I have "Data-Lake" that points to catalog id: AccountA).
When querying...
0
answers
0
votes
100
views
asked 8 months agolg...
We have a coupe instances of DocumentDB running and we are wanting to be able to visualize the data in Quicksight. We started down the path of using Athena Federated query outlined in this article:...
1
answers
0
votes
392
views
asked 8 months agolg...
If I have an athena table built on top of a s3 bucket whose objects are in the intelligent tiering storage class, is there anything to keep in mind? Will it still work?
1
answers
0
votes
752
views
asked 8 months agolg...
Hi,
The environment is, there are multiple JSON files in a S3 bucket. I would like to add all of them to the Athena Table with the filtered values. I used the ChatGPT for the Athena query to create...
2
answers
0
votes
2816
views
asked 8 months agolg...
Say I have a s3 bucket with json files in the following format:`s3://bucket_name/logs/region={region}/year={year}/month={month}/day={day}/hour={hour}/`
I would like to use partition projection on...
1
answers
0
votes
667
views
asked 8 months agolg...
Hello
I am getting a timeout when trying to connect to Athena through JDBC (I am using squirrel client)
java.util.concurrent.TimeoutException
at...
1
answers
0
votes
229
views
asked 9 months agolg...