Help Center/ MapReduce Service/ Component Operation Guide (ME-Abu Dhabi Region)/ Using CarbonData (for MRS 3.x or Later)/ CarbonData FAQ/ Why Missing Privileges Exception is Reported When I Perform Drop Operation on Databases?
Updated on 2022-02-22 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.