Athena spark delta format issue in ap-south-1 region

0

HI , I have data in delta format in s3 , created external table with following query .

CREATE EXTERNAL TABLE delta_mongo.transactions ( _id string , account_id bigint, bucket_end_date string, bucket_start_date string, transaction_count bigint, time string) ROW FORMAT SERDE 'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe' STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.SymlinkTextInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat' LOCATION 's3://****/test/lambda-mongodb/atlas/simple-analytics/transactions/curated/full-load/_symlink_format_manifest/' ;

Im able to create external table , when i query the table . i'm getting following error when i test in ap-south-1 region :

HIVE_UNKNOWN_ERROR: >com.amazonaws.services.lakeformation.model.InvalidInputException: Unsupported >vendor for Glue supported principal: arn:aws:iam::054709220113:root (Service: >AWSLakeFormation; Status Code: 400; Error Code: InvalidInputException; Request ID: >24c65ff9-e6dd-4393-9f01-2168b2849849; Proxy: null)

  • When i test this us-east-1 , im able to query the data . How do i resolve this in ap-south-1?
No Answers

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions