HIVE_UNKNOWN_ERROR: Error creating an instance of com.facebook.presto.hive.lakeformation.CachingLakeFormationCredentialsProvider
After running a simple select query in Athena, I get an error - HIVE_UNKNOWN_ERROR: Error creating an instance of com.facebook.presto.hive.lakeformation.CachingLakeFormationCredentialsProvider. Athena query is supposed to run agains a LF database within the same S3 bucket (data source and query destination are split into two folders inside the bucket). Any idea what could be the issue?
could you confirm that your database , table or columns names respect the limitations indicated in the documentation?
The only acceptable characters for database names, table names, and column names are lowercase letters, numbers, and the underscore character.
I have seen the error you mention in case this is not followed. as also mentioned in this stackoverflow question.
If you do not have this situation, could you, please, share some additional details on your table?
hope this helps, Fabrizio
Athena permission error running a query
Charged $1.00 After Creating An Instance In EC2asked 5 months ago
Error on Dashboard "An error occurred" and unable to create instance due to "Error loading AMI data".asked 5 days ago
Help in creating the most simple Athena UDF
Can i execute an Athena saved query from lambda?Accepted AnswerMODERATORasked 3 years ago
HIVE_CANNOT_OPEN_SPLIT Error from Athena queryasked 2 months ago
After making an image and creating a bundle I get a repeated errorasked 5 months ago
HIVE_UNKNOWN_ERROR: Error creating an instance of com.facebook.presto.hive.lakeformation.CachingLakeFormationCredentialsProviderasked a month ago
Error msg when running query in aws athenaasked a month ago
I cannot use current_date + interval in Athena boto3 query in LambdaAccepted Answerasked 3 months ago