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 backfillinglg...
Hello!
Would like to understand in case of any incidents, is there a good way to backfill data in Athena? Is there any guidance or existing script we can make use of?
Thanks!
1
answers
0
votes
217
views
asked 3 months agolg...
Directed from Andes table to Athena and query errors with
```
HIVE_UNKNOWN_ERROR: Can not create a Path from an empty string
This query ran against the "andes" database, unless qualified by the...
Accepted AnswerAmazon Athena
2
answers
0
votes
235
views
asked 3 months agolg...
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
449
views
asked 3 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
250
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
389
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
149
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
678
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
181
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
516
views
asked 4 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
163
views
asked 4 months agolg...