Support Questions

Find answers, ask questions, and share your expertise
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

error in dropping partition in hive

New Contributor

Alter table [tablename] DROP IF EXISTS partition(DATETIME<> '') PURGE;
Error:Error while compiling statement.Failed Execution(state 08S01,code=40000)
Partition spec is incorrect{datetime=}


Expert Contributor

HI @shivam0408 ,

Can you clarify what CDH/HDP/CDP version are you using and what is the datatype of the "DATETIME" column? 

What is the desired end result of this command? To drop all the partitions?

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.