Unanswered 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.
Hi All, I have created a cloudtrail log to read any s3 dataevent. I see in s3 location, logs have started building. But when I try to query this data in S3 , it's failing with error ...
0
answers
0
votes
91
views
asked 5 months agolg...
According to https://docs.aws.amazon.com/athena/latest/ug/querying-iceberg-evolving-table-schema.html
> Drop – Removes an existing column from a table or nested struct.
However in...
0
answers
0
votes
75
views
asked 5 months agolg...
Issue while querying the cloudfront logs using Athena. All the resources are being created successfully when I run a basic sql query to fetch last 100 logs it fails with below error. verified the...
0
answers
0
votes
63
views
asked 5 months agolg...
Hello,
I want to run a query where the table name is a parameter, so the query is something like
`select * from :table_name`
I am getting this error ' mismatched input' as table name contains...
0
answers
0
votes
70
views
asked 5 months agolg...
I'm looking for an open-source solution that can help us make our python API more accessible.
For simplicity's sake, the data is accessed using Athena and has three string fields A, B, C.
Every...
0
answers
0
votes
139
views
asked 6 months agolg...
I'm trying to create a new Athena/Iceberg table in my existing S3 directory structure. The location contains equal signs, e.g. `country=all/data`. These equal signs are escaped by Athena, which...
0
answers
0
votes
113
views
asked 6 months agolg...
1. I am trying to understand how to estimate the end result of pricing for Glue crawlers for data being ingested by AWS Kinesis Firehose service with the max possible buffer setting while glue...
0
answers
0
votes
169
views
asked 6 months agolg...
I have an athena query that runs in around 3 secs both from console and even is called using pyathena. I have added the query execution into a step function as I need to perform some pre and post...
0
answers
0
votes
138
views
asked 6 months agolg...
I have a Glue table created from schema in Glue schema registry that is in JSON draft 07 format.
I tried setting up a Firehose that converts incoming JSON data into Parquet as it saves it into S3,...
0
answers
0
votes
190
views
asked 6 months agolg...
Athena Query Id: 48b0a8cc-13ce-4c90-8295-c69c682e7f11
When doing a SELECT statement for a table it returns an INTERNAL_ERROR_QUERY_ENGINE error when we have a lot of `AND ((attr1 = 'value' AND attr2...
0
answers
0
votes
167
views
asked 6 months agolg...
If I want to extract specific properties from a JSON array using SQL, for example, if the requestparameters structure is as follows:
```
{
'gree': [
{
'Grantee': {
'xsi:type':...
0
answers
0
votes
86
views
asked 6 months agolg...
How can we integrate Athena UDF functions with Quicksight?
Is there any route for this?
0
answers
0
votes
119
views
asked 7 months agolg...