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.
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
597
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
432
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
793
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
720
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
598
views
asked 5 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
670
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
516
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
422
views
asked 5 months agolg...
Hello.
I am currently completing the AWS Industry Quest: Financial Industry but I'm unable to do so as 2 modules produce errors that prevent me from continuing. The modules "Securing a Banking Data...
1
answers
0
votes
476
views
asked 5 months agolg...
I'm converting my json files with dynamic schema to Parquet and used a Glue Crawler to create Glue Table to query using Athena. I got the below error as one column in my table got array<string> in one...
2
answers
0
votes
401
views
asked 5 months agolg...
When creating a QuickSight Dataset using CDK, we have to specify the input_columns parameter for physical_table_map. Is there a way to include all columns in the table without having to write out all...
1
answers
0
votes
461
views
asked 5 months agolg...
Hi
In Athena Notebooks,
```
df = spark.createDataFrame([
(2, "Alice"), (5, "Bob")], schema=["age", "name"])
t = df.collect()
%table t
```
the displayed table looks like a typical pandas...
Accepted AnswerAmazon Athena
1
answers
0
votes
442
views
asked 5 months agolg...