Unanswered 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 having the same issue. Data is stored in below format in s3 as JSON array with partitions
S3 path - s3://fleet-fuelcard-data-import-dev/lambda/fuelsoft-morgan/660306/2024/Apr/03-Apr-2024.json....
0
answers
0
votes
17
views
asked 8 hours agolg...
Apache Iceberg version
None
Query engine
Athena (engine v3)
Hello everyone, today my team incurred in a very strange bug using Iceberg via Athena. I'll descrive the steps we used to reproduce the...
0
answers
0
votes
137
views
asked 6 days agolg...
Is there a way for members of a datazone project to connect to Power BI and view the datasets they subscribed to?
0
answers
0
votes
26
views
asked 8 days agolg...
Hi,
I am querying an external partitioned table in redshift spectrum and it throws an error. The data is stored in S3, parquet files and one of the column is 'BINARY'. If i remove the partition column...
0
answers
0
votes
54
views
asked 9 days agolg...
I've imported a dataset of JSON objects that all have consistent schema. Glue crawler finished successfully and created a table. I can select * with a limit in Athena, but when I select all rows I get...
0
answers
1
votes
220
views
asked 10 days agolg...
Hi!
I am trying to use DataZone to share an Iceberg table from the Glue Data Catalog with another AWS account.
I have created the table with Athena in the source account like this:
```sql
CREATE...
0
answers
0
votes
67
views
asked 10 days agolg...
I hope this message finds you well. I'm reaching out because I require assistance with enabling embedding and anonymous access for the Amazon Grafana dashboard. My goal is to integrate the live Amazon...
0
answers
0
votes
58
views
asked 13 days agolg...
Hello, so I have my script that runs an Athena query and sends an email,
When I was testing in my machine in the terminal, running 'python3 name-file.py'. The script works fine, the query is run and...
0
answers
0
votes
121
views
asked 17 days agolg...
Hi, I'm trying to build a quite complex query that runs on some views and if i get a couple of join it ends in this error
[HY000][100071] [Simba][AthenaJDBC](100071) An error has been thrown from the...
0
answers
0
votes
48
views
asked 17 days agolg...
Trying to create an Athena table with the following query
```
CREATE TABLE IF NOT EXISTS current_energy_rates
WITH (table_type = 'ICEBERG', format='PARQUET', location='s3://pr-energy-lookup',...
0
answers
0
votes
56
views
asked 20 days agolg...
Hello AWS Community,
I'm facing a challenging issue with our AWS data pipeline that affects data visualization in Amazon QuickSight. Initially, our setup involved directly importing CSV data from S3...
0
answers
0
votes
168
views
asked 20 days agolg...
Actually i uploaded one JSON file into my s3 bucket which is having nested JSON data. and, created Athena table out of it by using glue crawler. after that when i was trying to query the table i am...
0
answers
0
votes
338
views
asked a month agolg...