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 json-per-line files in S3 that look like this:
{ "eventTimestamp": "...", "eventType": "...", "eventPayload": { complex object of unknown schema } }
How can I define an Athena table that...
1
answers
0
votes
475
views
asked 4 months agolg...
Hello,
While trying to run this command `DELETE FROM "datasets"."us_spending"` in Athena, on a table from AWS Data Catalog, I had this error:
```
NOT_SUPPORTED: Cannot delete from non-managed Hive...
1
answers
0
votes
753
views
asked 4 months agolg...
[Simba][AthenaJDBC](100131) An error has been thrown from the AWS SDK client. Unable to load AWS credentials from any provider in the chain: [EnvironmentVariableCredentialsProvider: Unable to load AWS...
0
answers
0
votes
426
views
asked 5 months agolg...
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 5 months agolg...
How can I consume S3 data and make it as an asset in AWS DataZone ?
1
answers
0
votes
707
views
asked 5 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
656
views
asked 5 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
583
views
asked 5 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
585
views
asked 5 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
430
views
asked 5 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
787
views
asked 5 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
704
views
asked 5 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
589
views
asked 5 months agolg...