This is an automated email from the ASF dual-hosted git repository.
lzljs3620320 pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/paimon.git
The following commit(s) were added to refs/heads/master by this push:
new 2ead6a5721 [doc] Add doc for spark drop column with hive catalog
2ead6a5721 is described below
commit 2ead6a57218b0a88156b215e84f5629064a41929
Author: Jingsong <[email protected]>
AuthorDate: Thu Dec 19 15:38:38 2024 +0800
[doc] Add doc for spark drop column with hive catalog
---
docs/content/spark/sql-alter.md | 4 ++++
1 file changed, 4 insertions(+)
diff --git a/docs/content/spark/sql-alter.md b/docs/content/spark/sql-alter.md
index 359b118729..149975ef93 100644
--- a/docs/content/spark/sql-alter.md
+++ b/docs/content/spark/sql-alter.md
@@ -174,6 +174,10 @@ The following SQL drops a nested column `f2` from a struct
type, which is the va
ALTER TABLE my_table DROP COLUMN v.value.f2;
```
+For hive catalog, you need to disable
`'hive.metastore.disallow.incompatible.col.type.changes'`, otherwise this
+operation may fail, throws an exception like `'The following columns have
types incompatible with the existing columns
+ in their respective positions'`.
+
## Dropping Partitions
The following SQL drops the partitions of the paimon table. For spark sql, you
need to specify all the partition columns.
