Created on 05-31-2022 02:59 AM - last edited on 05-31-2022 07:27 AM by VidyaSargur
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=}
Created 06-22-2022 02:41 AM
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?