https://community.databricks.com/t5/data-engineering/difference-in-support-for-partitions-between-hive-and-unity/m-p/68779#M33748 <P>The Unity migration guide (<A href="https://docs.databricks.com/en/data-governance/unity-catalog/migrate.html#before-you-begin" target="_blank" rel="noopener">https://docs.databricks.com/en/data-governance/unity-catalog/migrate.html#before-you-begin</A>) states the following:</P><P><EM>Unity Catalog manages partitions differently than Hive. Hive commands that directly manipulate partitions are not supported on tables managed by Unity Catalog.</EM></P><P>I'm unable to find documentation that elaborates on this statement.&nbsp; What specifically is different in the handling of partitions between Unity and hive?&nbsp; We have existing partitioned delta tables in our hive meta store that we are considering migrating to Unity.</P> Fri, 10 May 2024 23:57:45 GMT m208205 2024-05-10T23:57:45Z https://community.databricks.com/t5/data-engineering/difference-in-support-for-partitions-between-hive-and-unity/m-p/68779#M33748 <P>The Unity migration guide (<A href="https://docs.databricks.com/en/data-governance/unity-catalog/migrate.html#before-you-begin" target="_blank" rel="noopener">https://docs.databricks.com/en/data-governance/unity-catalog/migrate.html#before-you-begin</A>) states the following:</P><P><EM>Unity Catalog manages partitions differently than Hive. Hive commands that directly manipulate partitions are not supported on tables managed by Unity Catalog.</EM></P><P>I'm unable to find documentation that elaborates on this statement.&nbsp; What specifically is different in the handling of partitions between Unity and hive?&nbsp; We have existing partitioned delta tables in our hive meta store that we are considering migrating to Unity.</P> Fri, 10 May 2024 23:57:45 GMT https://community.databricks.com/t5/data-engineering/difference-in-support-for-partitions-between-hive-and-unity/m-p/68779#M33748 m208205 2024-05-10T23:57:45Z