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 usecase where Athena, Glue catalog and database and s3 all exist in AccountB . and have an application running in EKS cluster in AccountA. I have provided root level access to AccountA in s3...
1
answers
0
votes
400
views
asked 10 months agolg...
The query is working on 1 table with a CSV source file. After adding 2 more columns to the same file it is giving me an error for the normal select query.
**HIVE_BAD_DATA: Error reading field value:...
0
answers
0
votes
251
views
asked 10 months agolg...
We are trying to use Glue to query and aggregate some Parquet files in S3.
We get this error related to schema mismatch:
```
An error occurred while calling o106.pyWriteDynamicFrame....
2
answers
0
votes
257
views
asked 10 months agolg...
I have two tables in Athena, both have the same schema (user_id - a string, items - an array of ASINs). One table records users in Week 1 and the other one in Week 2. Some users in both tables share...
0
answers
0
votes
46
views
asked 10 months agolg...
AlreadyExistsException from Athena when creating a table but I deleted the table from S3. Why does it think it still exists? Is there metadata somewhere that I can also delete?
Accepted AnswerAmazon Athena
1
answers
0
votes
256
views
asked 10 months agolg...
I successfully executed the Python query to convert the JSON format to Parquet format. The conversion was completed without any issues, and I can confirm the presence of the Parquet file and its...
1
answers
0
votes
385
views
asked 10 months agolg...
I have an existing org level CloudTrail but it is very slow when querying using Athena. I was thinking of using cloudtrail lake but I want to know how much would it cause me to use it? I don’t need...
3
answers
0
votes
1338
views
asked 10 months agolg...
Is there a way to create such a glue table using AWS python CDK ? have been trying with no success so far
`CREATE EXTERNAL TABLE
[db_name.]table_name
LOCATION...
1
answers
0
votes
852
views
asked 10 months agolg...
I am using glue to move data from s3 and redshift into a data lake. I would like to use a combination of AWS glue and Athena to create a source to target mapping report. The goal is to make the report...
1
answers
0
votes
277
views
asked 10 months agolg...
I would like to adopt Iceberg tables for easier data management in the data lake but we have a dependency on Redshift Spectrum and it seems that Amazon is not planning on supporting Iceberg in...
1
answers
0
votes
420
views
asked 10 months agolg...
I am looking to read data from Athena as input to Glue Studio. But I cant see any connector to Athena in Glue Studio. What would be my best approach to this? Perhaps I am missunderstanding this....
2
answers
0
votes
219
views
asked a year agolg...
I wanna fetch Athena SQL query results by using AWS SDK. I know that There are cost for querying on Athena and cost for results stored in S3. Then, If I want to fetch data by executing...
1
answers
0
votes
237
views
asked a year agolg...