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 dynamodb table design to store several types of data relationships (single table design). It stores "Projects" and also stores "tasks" and "updates on projects", "updates on tasks", "users"...
2
answers
0
votes
247
views
asked 3 months agolg...
Hello, im new to aws and im studying data engineering na dim facing a problem.
Ive created a parquet file that is on my bucket.
I also created a database that contains this parquet file.
When i try...
4
answers
0
votes
373
views
asked 3 months agolg...
hi all,
I am running my athena script, in athena console and got this error,
`GENERIC_INTERNAL_ERROR: io.airlift.bytecode.CompilationException: Error compiling class:...
0
answers
0
votes
122
views
asked 3 months agolg...
Hi,
we have a situation where an application running in a k8 environment of a different account have to access the athena and the glue data catalog in a different account.
since these two accounts...
1
answers
0
votes
215
views
asked 3 months agolg...
The files in the bucket have json arrays in a single line separated by comma like below:
[{"key" : 20}, {"key" : 30}, {"key" : 40}]
When i create table with this, only the first record is being...
1
answers
0
votes
147
views
asked 3 months agolg...
According to the insights on the Cudos dashboard, we were making a monthly saving of $12k when switching to standard-ia in this table.
We made the transition on January 31st, and even now, we can see...
2
answers
0
votes
672
views
asked 3 months agolg...
S3 LOCATION INvalidlg...
HI, Having problem w my query. It says "S3 location provided to save your query results is invalid". Can you help me with this?
1
answers
0
votes
177
views
asked 3 months agolg...
I have 2 AWS accounts, Account "A" contain AWS Redshift and Account "B" has external data that crawler from S3.
## What I have done
#### Account A
1. Attached spectrum role to Redshift
![spectrum...
1
answers
0
votes
483
views
asked 3 months agolg...
GENERIC_INTERNAL_ERROR: SchemaParseException thrown initializing deserializer io.trino.plugin.hive.avro.TrinoAvroSerDe. Cause: com.fasterxml.jackson.core.JsonParseException: Illegal unquoted character...
1
answers
0
votes
162
views
asked 3 months agolg...
Time stamp errorlg...
I want to filter by time stamp but i keep getting i try cast it as a time stamp; Please...
1
answers
0
votes
133
views
asked 3 months agolg...
Hi there,
I ran a workload on Athena's capacity reservation setup which completed successfully but didn't utilize the entire resource in the reserved capacity. It only used 78% percent of it...
1
answers
0
votes
173
views
asked 3 months agolg...
I have an external Iceberg REST Catalog implementation and I need to use that with Athena. Do we currently support this use case? If so, are there any documentation on how to do this?
The closest use...
2
answers
0
votes
291
views
asked 3 months agolg...