alter table table_name drop partition with a empty string will drop the whole table

    val spark = SparkSession
      .builder
      .appName("PartitionDropTest")
      .master("local[2]").enableHiveSupport()
      .getOrCreate()
    val sentenceData = spark.createDataFrame(Seq(
      (0, "a"),
      (1, "b"),
      (2, "c")))
      .toDF("id", "name")
    spark.sql("drop table if exists licllocal.partition_table")
    sentenceData.write.mode(SaveMode.Overwrite).partitionBy("id").saveAsTable("licllocal.partition_table")
    spark.sql("alter table licllocal.partition_table drop partition(id='')")
    spark.table("licllocal.partition_table").show()

|name| id|
+----+---+
+----+---+