I am trying to overwrite an Hive table through spark job, but getting error as user does not have CREATETABLE privileges. When I run the same job through my personal id, it works fine. But for service id it is failing. I checked with hadoop admin team and they are saying that all privileges are granted for the service id. Not sure what is missing.
When I try to overwrite the same table through beeline, it works fine. Please suggest what is going wrong.
