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.
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
8
views
asked an hour 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
147
views
asked 13 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
35
views
asked 15 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
62
views
asked 16 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
75
views
asked 17 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
126
views
asked 23 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
54
views
asked 24 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
59
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
191
views
asked a month 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
342
views
asked a month agolg...
When excuting this sql in the AWS Management Console / Athena Query Editor
```
ALTER TABLE iceberg_table CHANGE COLUMN comment blog_comment string AFTER id
```
it should allow for...
0
answers
0
votes
172
views
asked a month agolg...
0
I'm encountering a NoSuchKey error while attempting to create an Athena Iceberg table using AWS Wrangler. Here's the anonymized error message:
{
"errorMessage": "GENERIC_INTERNAL_ERROR:...
0
answers
0
votes
242
views
asked a month agolg...