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.
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
224
views
asked 7 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
286
views
asked 7 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
272
views
asked 7 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
308
views
asked 7 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
275
views
asked 7 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
85
views
asked 7 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
704
views
asked 7 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
119
views
asked 7 months agolg...
Hi. I am using Athena Pyspark notebooks that I would like to schedule for weekly automated runs. Is there a way to use Step Function Workflow Jobs to do this? In the documentation, it only mentions...
1
answers
0
votes
358
views
asked 8 months agolg...
My Glue 4.0 jobs have suddenly stopped working with error message below. As it is related to boto3, I am unable to make any changes to library config. Pls advise.
NB: I noticed that urllib3 released...
0
answers
0
votes
98
views
asked 8 months agolg...
Hi all,
We are having two queries fail on Athena. Here's a message that was in the Query Results section. Please let me know what additional information you need from me to resolve the issues....
1
answers
1
votes
355
views
asked 8 months agolg...
I have converted a json format file in parquet, I can see the parquet file and the columns, but while querying with Athena getting error.
HIVE_UNKNOWN_ERROR: Path is not absolute:...
1
answers
0
votes
276
views
asked 8 months agolg...