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.
At every 30 minutes it saying "ICEBERG_VACUUM_MORE_RUNS_NEEDED: Removed 20000 files in this round of vacuum" but when I calculate the my table metadata size it didn't changed before and after the...
2
answers
0
votes
227
views
asked 2 months agolg...
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
192
views
asked 2 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
286
views
asked 2 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
113
views
asked 2 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
190
views
asked 2 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...
0
answers
0
votes
110
views
asked 2 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
638
views
asked 2 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
150
views
asked 2 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
287
views
asked 2 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
131
views
asked 2 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
110
views
asked 2 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
133
views
asked 2 months agolg...