Help Center> MapReduce Service> Component Operation Guide (Normal)> 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-09-15 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.