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?
Keine Antworten

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen