You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@paimon.apache.org by "macdoor (via GitHub)" <gi...@apache.org> on 2023/07/04 08:02:12 UTC
[GitHub] [incubator-paimon-trino] macdoor commented on issue #18: Error in querying primary key table with row type column under trino
macdoor commented on issue #18:
URL: https://github.com/apache/incubator-paimon-trino/issues/18#issuecomment-1619737588
create 3 tables
```
drop table if exists svc1_paimon_prod.dxx.with_row;
CREATE TABLE svc1_paimon_prod.dxx.with_row (
id string,
order_attrs row<
ordernum string,
paymentmode string
>,
skuNum string,
PRIMARY KEY (id,skuNum) NOT ENFORCED
)
PARTITIONED BY (skuNum);
drop table if exists svc1_paimon_prod.dxx.without_row;
CREATE TABLE svc1_paimon_prod.dxx.without_row (
id string,
skuNum string,
PRIMARY KEY (id,skuNum) NOT ENFORCED
)
PARTITIONED BY (skuNum);
drop table if exists svc1_paimon_prod.dxx.with_row_append;
CREATE TABLE svc1_paimon_prod.dxx.with_row_append (
id string,
order_attrs row<
ordernum string,
paymentmode string
>,
skuNum string
)
PARTITIONED BY (skuNum);
```
execute query
`SELECT t.* FROM with_row t `
throw exception
```
[2023-07-04 12:25:42] [65536] Query failed (#20230704_042542_00381_hzk4t): org.apache.paimon.codegen.GeneratedClass
[2023-07-04 12:25:42] java.lang.ClassNotFoundException: org.apache.paimon.codegen.GeneratedClass
```
There is no error in querying table without_row, with_row_append
--
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