[SPARK-3007][SQL]Add "Dynamic Partition" support to Spark Sql hive

a new PR base on new master.  changes are the same as https://github.com/apache/spark/pull/1919
Ah, please ignore the nonsense about `.clone()`. But we do need to inherit compression settings here.