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/' ;
_id
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)
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.