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.
How can we integrate Athena UDF functions with Quicksight?
Is there any route for this?
0
answers
0
votes
127
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
245
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
581
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
350
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
456
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
240
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
310
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
299
views
asked 8 months agolg...
I have a table that has sensitive information. TABLE_SENSITIVE
I created a view on top of the table that masks the sensitive columns - VIEW_NON_SENSITIVE
I want my user role to get access to the...
1
answers
0
votes
340
views
asked 8 months agolg...
Hi, I have a question about how athena columns listing works, since in my schema and my table I have for example a column called 'anonymousId' (and I can see it directly on the athena panel at the...
1
answers
0
votes
307
views
asked 8 months agolg...
I created an Athena table using Glue
```
import * as glue from '@aws-cdk/aws-glue-alpha'
const dataWarehouse = new glue.Table(this, `data_warehouse`, {
database: db,
tableName:...
0
answers
0
votes
91
views
asked 8 months agolg...
backgoround: querying cloudtrail logs via athena, however the database and table table is created using glue crawler but running into error
**HIVE_UNSUPPORTED_FORMAT: Unable to create input format**
1
answers
0
votes
789
views
asked 8 months agolg...