Can i have resolution for this....   All permissions are perfect but still i could not able to create the External table as a specific user.   ... View more

Hi,   Im trying to create a table as mentioned below. I have all the read/write/execute permissions for the mentioned users.   CREATE EXTERNAL TABLE stage_rtra_transaction_ext_1( attemptid string, trns_sur_key string, sender_gi string, payee_gi string, success_flag string, atch_que_name string, transactionstate string, pay_mtcn_nr string, swb_zone string, swb_zone_pay string, que_name string, moneyordertype string, trns_ts string, ext_seq_no string, field_name string, field_value string) PARTITIONED BY ( year int, month int, day int) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\u0001' STORED AS RCFILE LOCATION 'hdfs://nameservice1/compliance/compliancehadoop/data/stage/rtra/STAGE_RTRA_TRANSACTION_EXT/';   while running in beeline im getting the below error.   Error: Error while compiling statement: FAILED: SemanticException No valid privileges User compliance does not have privileges for CREATETABLE The required privileges: Server=server1->URI=hdfs://nameservice1/compliance/compliancehadoop/data/stage/rtra/STAGE_RTRA_TRANSACTION_EXT->action=*; (state=42000,code=40000)   On removing the LOCATION line, the query works fine.   Please anyone help me to sort out this.   Thanks, Mjoy ... View more