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 trying to setup PowerBI for our DynamoDB table. Using Athena with the DynamoDB Lambda connector. Smaller queries work fine, however the main import into PowerBI fails. When I play with the query...
2
answers
0
votes
276
views
asked 8 months agolg...
I have two accounts the source account A and the target account B.
I have granted account B access to the database and all its tables in account A with Super access including grant. and accepted this...
1
answers
0
votes
366
views
asked 8 months agolg...
i have a table in data catalog and when i query the table, all the data in that table are return in one column separated by commas. It's like its returning the CSV file exactly as it is without...
1
answers
0
votes
294
views
asked 8 months agolg...
Good afternoon fellow AWS users.
I'm trying to get data from Athena into a Lambda session. I've done this before with another dataset, with no problems, so I know the Python script is correctly...
1
answers
0
votes
792
views
asked 8 months agolg...
How can we integrate Athena UDF functions with Quicksight?
Is there any route for this?
0
answers
0
votes
126
views
asked 8 months agolg...
I need to build a solution that for a given Athena query, the output is inserted into RDS (Postgres). From what I have read, it makes sense to use Glue. However, I am not comprehending the exact...
2
answers
0
votes
235
views
asked 8 months agolg...
# Background
We were getting a "HIVE_CURSOR_ERROR: Failed to read Parquet file" when running trying to run an athena query using `SELECT * FROM mydb`. Our underlying data that we were querying was...
1
answers
0
votes
573
views
asked 8 months agolg...
Im saving data to JSON using `UNLOAD` Athena command. Some of non-string fields are empty. `UNLOAD` command puts `null`'s everywhere instead. Is there any way to tell Athena to skip serialization of...
1
answers
1
votes
326
views
asked 8 months agolg...
I am getting below error when running SELECT, INSERT, DELETE or any other statement on ICEBERG table
```
GENERIC_INTERNAL_ERROR:...
1
answers
0
votes
441
views
asked 8 months agolg...
Running show tables in Athena console is giving error: [ErrorCategory:USER_ERROR, ErrorCode:DDL_FAILED], Detail:FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask....
1
answers
0
votes
236
views
asked 8 months agolg...
I need to make an update to a table in athena called businesses. The table schema was updated in Github, Lamdba, Glue and the new fields appear in the table in Athena, however they appear empty, for...
1
answers
0
votes
305
views
asked 8 months agolg...
I create lambda function to be used in athena UDF.
```
USING EXTERNAL FUNCTION decrypt(variable1 VARBINARY)
RETURNS VARCHAR
LAMBDA 'LambdaFunctionName'
SELECT decrypt(amount) FROM...
1
answers
0
votes
292
views
asked 8 months agolg...