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?