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 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
232
views
asked 7 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
565
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
319
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
435
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
232
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
299
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
288
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
317
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
291
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
89
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
754
views
asked 8 months agolg...
I am using Glue Crawler to crawl for parquet files, partitioned by type/yyyy/mm/dd which has been working just great. However, we have just run into a scenario where we need to rename a column. Is it...
0
answers
0
votes
124
views
asked 8 months agolg...