You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@paimon.apache.org by "wangyayuan18 (via GitHub)" <gi...@apache.org> on 2023/05/25 06:56:52 UTC
[GitHub] [incubator-paimon] wangyayuan18 opened a new issue, #1231: [Bug]
wangyayuan18 opened a new issue, #1231:
URL: https://github.com/apache/incubator-paimon/issues/1231
### Search before asking
- [X] I searched in the [issues](https://github.com/apache/incubator-paimon/issues) and found nothing similar.
### Paimon version
[paimon-flink-1.17-0.5-SNAPSHOT.jar](https://repository.apache.org/snapshots/org/apache/paimon/paimon-flink-1.17/0.5-SNAPSHOT/)
### Compute Engine
Flink SQL CLI Client
### Minimal reproduce step
Start by adding the unknown field
ALTER TABLE my_table ADD unknown STRING AFTER mt;
mt field is my partition field
Problems that arise
### What doesn't meet your expectations?
Field cannot be deleted
### Anything else?
_No response_
### Are you willing to submit a PR?
- [ ] I'm willing to submit a PR!
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@paimon.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-paimon] zhuangchong commented on issue #1231: Field cannot be deleted
Posted by "zhuangchong (via GitHub)" <gi...@apache.org>.
zhuangchong commented on issue #1231:
URL: https://github.com/apache/incubator-paimon/issues/1231#issuecomment-1577906941
set hive.metastore.disallow.incompatible.col.type.changes false in hive-site.xml, and restart hive. See [HIVE-17832](https://issues.apache.org/jira/browse/HIVE-17832).
At the same time, I have added the test case of alter table when flink sql uses hive catalog.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@paimon.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-paimon] zhangjun0x01 commented on issue #1231: Field cannot be deleted
Posted by "zhangjun0x01 (via GitHub)" <gi...@apache.org>.
zhangjun0x01 commented on issue #1231:
URL: https://github.com/apache/incubator-paimon/issues/1231#issuecomment-1563693719
I try it in my computer,it is ok .
could you provide more information？
```
Flink SQL>
> CREATE CATALOG paimon_hive_catalog WITH (
> 'type' = 'paimon',
> 'metastore' = 'hive',
> 'table.type' = 'external',
> 'uri' = 'thrift://localhost:9083',
> 'warehouse' = 'hdfs://localhost/user/hive/warehouse'
> );
[INFO] Execute statement succeed.
Flink SQL> use catalog paimon_hive_catalog;
[INFO] Execute statement succeed.
Flink SQL> use zhangjun;
[INFO] Execute statement succeed.
Flink SQL> drop table mytable;
[INFO] Execute statement succeed.
Flink SQL> CREATE TABLE mytable (
> user_id BIGINT,
> item_id BIGINT,
> behavior STRING,
> dt STRING,
> hh STRING,
> PRIMARY KEY (dt, hh, user_id) NOT ENFORCED
> ) PARTITIONED BY (dt, hh);
[INFO] Execute statement succeed.
Flink SQL> alter table mytable add aaa string after dt;
[INFO] Execute statement succeed.
Flink SQL> desc mytable;
+----------+--------+-------+----------------------+--------+-----------+
| name | type | null | key | extras | watermark |
+----------+--------+-------+----------------------+--------+-----------+
| user_id | BIGINT | FALSE | PRI(dt, hh, user_id) | | |
| item_id | BIGINT | TRUE | | | |
| behavior | STRING | TRUE | | | |
| dt | STRING | FALSE | PRI(dt, hh, user_id) | | |
| aaa | STRING | TRUE | | | |
| hh | STRING | FALSE | PRI(dt, hh, user_id) | | |
+----------+--------+-------+----------------------+--------+-----------+
6 rows in set
Flink SQL> alter table mytable drop (aaa);
[INFO] Execute statement succeed.
Flink SQL>
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@paimon.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-paimon] JingsongLi commented on issue #1231: Field cannot be deleted
Posted by "JingsongLi (via GitHub)" <gi...@apache.org>.
JingsongLi commented on issue #1231:
URL: https://github.com/apache/incubator-paimon/issues/1231#issuecomment-1564010017
What is your hive metastore version?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@paimon.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [incubator-paimon] JingsongLi closed issue #1231: Field cannot be deleted
Posted by "JingsongLi (via GitHub)" <gi...@apache.org>.
JingsongLi closed issue #1231: Field cannot be deleted
URL: https://github.com/apache/incubator-paimon/issues/1231
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: issues-unsubscribe@paimon.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org