Help Center/ MapReduce Service/ Component Operation Guide (LTS)/ Using CarbonData/ CarbonData FAQ/ Why Missing Privileges Exception is Reported When I Perform Drop Operation on Databases?
Updated on 2022-11-18 GMT+08:00

Why Missing Privileges Exception is Reported When I Perform Drop Operation on Databases?

Question

Why drop database cascade is throwing the following exception?

Error: org.apache.spark.sql.AnalysisException: Missing Privileges;(State=,code=0)

Answer

This error is thrown when the owner of the database performs drop database <database_name> cascade which contains tables created by other users.