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.
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
215
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
340
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
230
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
356
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
211
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
134
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
660
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
171
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
431
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
154
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
130
views
asked 3 months agolg...