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'm experiencing an issue with AWS Athena when trying to compile a table from millions of small, partitioned S3 objects. I haven't specified where the table should be saved, and I'm encountering a...
1
answers
0
votes
167
views
asked 2 months agolg...
Hello,
I have a CSV file stored in the S3 bucket that is being updated daily. The CSV file has several tabs. each tab is a different table. I want to use this CSV file as a DB in QuickSight AWS.
I use...
2
answers
1
votes
170
views
asked 2 months agolg...
I have this table:
```
RetsIncomingTable:
Type: AWS::Glue::Table
Properties:
CatalogId: !Ref AWS::AccountId
DatabaseName: !Ref TheDatabase
TableInput:
Name:...
0
answers
0
votes
147
views
asked 2 months agolg...
Hello,
I have an Excel file stored in S3 bucket.
After running a crawler and creating a table I'm trying to see the table in Athena and getting this error:
COLUMN_NOT_FOUND: line 1:8: SELECT * not...
2
answers
0
votes
283
views
asked 2 months agolg...
I have an iceberg table defined like this:
CREATE TABLE IF NOT EXISTS staging (
id STRING,
staging_timestamp BIGINT,
... blah blah blah ...
)
PARTITIONED BY...
0
answers
0
votes
169
views
asked 2 months agolg...
Sample file:
{
"Messages":[
{"col1":"01",
"col2":["key":"02","value":"03"]
},
{"col1":"01",
"col2":["key":"01","value":"03"]
},
{"col1":"01",
...
1
answers
0
votes
582
views
asked 2 months agolg...
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
182
views
asked 2 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
186
views
asked 2 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
237
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
197
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
298
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
115
views
asked 2 months agolg...