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.
The query below on current AWS Athena version 3 gives a wrong result for the centroid, which lies way below the polygon (POINT (6.127790214246207 46.2084751184263)). The exact same query in PostGIS...
0
answers
0
votes
422
views
asked 4 months agolg...
How can I consume S3 data and make it as an asset in AWS DataZone ?
1
answers
0
votes
683
views
asked 4 months agolg...
I am trying to write a pyspark dataframe to S3 and the AWS data catalog using the Iceberg format and the pyspark.sql.DataFrameWriterV2 with the createOrReplace function. When I write the same...
1
answers
0
votes
631
views
asked 4 months agolg...
Can someone please help with this error? I have a csv file in an S3 bucket, created a crawler to update a table in glue, and the crawler runs but when I try to view the data in athena I get this...
1
answers
0
votes
567
views
asked 4 months agolg...
Hello, I would like to know if there is a way to query Iceberg tables (backed with S3 parquet files) cataloged within the AWS Glue Catalog using AWS Databrew. (maybe through Athena?).
Also, is it...
2
answers
0
votes
572
views
asked 4 months agolg...
Hi
Trying to craw connect logs create bad metadata with fields like this inside the table:
struct<connect\:Subtype:struct<ValueString:string>>
obvious running this struct inside athena result in a...
0
answers
0
votes
428
views
asked 4 months agolg...
We connected Timestream to Athena using the [Athena Timestream connector](https://docs.aws.amazon.com/athena/latest/ug/connectors-timestream.html). When running a federated query through Athena to...
2
answers
0
votes
773
views
asked 4 months agolg...
Hi all,
I'm recently introduced to AWS DataZone.
I'm have created 2 domain in a single account.
**df-test-1 and df-test-2**
Both domains do have data created by AWS Athena environment but I can...
3
answers
0
votes
679
views
asked 4 months agolg...
Hi,
I am trying to use Athena to query the s3 file which is in csv format and contains the json objects.
**S3 CSV file:**
```
Id, data, last_update
001, {"key1":"value1"}, 10-01-2024
002,...
1
answers
0
votes
575
views
asked 4 months agolg...
I am trying to connect to an external s3 bucket as a data source for a glue crawler. The bucket has the necessary arn permissions as i can connect to it via s3 browser as an external bucket. The...
1
answers
0
votes
625
views
asked 5 months agolg...
HIVE_BAD_DATA: Not valid Parquet file: s3://adp-to-aqt-dev/partition1/partition1.csv expected magic number: PAR1 got: ,,
This query ran against the "" database, unless qualified by the query.
1
answers
0
votes
480
views
asked 5 months agolg...
I've loaded some CSV files from an S3 bucket into tables in a Glue DB. I'm trying to query the tables using Athena, but I keep getting this...
1
answers
0
votes
396
views
asked 5 months agolg...