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 have data that I collect from AWS Batch and CloudWatch. I made a lambda function that runs every day that collects those data daily and saves the result to S3. I have a folder called 'logs' and the...
0
answers
0
votes
39
views
asked 4 hours agolg...
We have enabled the lake formation for some POC and we are unable to disable it and get default setting. The problem we have is if I create a db in athena and to create table in same database using...
0
answers
0
votes
29
views
asked 4 hours agolg...
I'm experimenting with Amazon DataZone and encountered something unexpected. I have a simple setup with one AWS account and one DataZone domain, which includes:
1 Glue Table
1 S3 bucket with my...
0
answers
0
votes
66
views
asked a day agolg...
This was working before, as recently as a week or two ago but Athena now fails with "INVALID_PARAMETER_USAGE: Incorrect number of parameters: expected 207 but found 0." when the query has more than...
0
answers
0
votes
55
views
asked 7 days 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
223
views
asked 20 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
45
views
asked 22 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
70
views
asked 23 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
84
views
asked 24 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
131
views
asked a month 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
60
views
asked a month 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
60
views
asked a month 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
193
views
asked a month agolg...