Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

error in dropping partition in hive

avatar
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=}

1 REPLY 1

avatar

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?