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 04:31:46 UTC
[GitHub] [incubator-paimon] macdoor opened a new issue, #1491: [Bug] Error in querying primary key table with row type column under trino
macdoor opened a new issue, #1491:
URL: https://github.com/apache/incubator-paimon/issues/1491
### Search before asking
- [X] I searched in the [issues](https://github.com/apache/incubator-paimon/issues) and found nothing similar.
### Paimon version
paimon-trino-393-0.5-20230704.000507-57.jar
### Compute Engine
trino
### Minimal reproduce step
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);
```
### What doesn't meet your expectations?
execute
`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
### 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] macdoor commented on issue #1491: [Bug] Error in querying primary key table with row type column under trino
Posted by "macdoor (via GitHub)" <gi...@apache.org>.
macdoor commented on issue #1491:
URL: https://github.com/apache/incubator-paimon/issues/1491#issuecomment-1681660350
@JingsongLi
[server.log-20230817.134144.zip](https://github.com/apache/incubator-paimon/files/12365899/server.log-20230817.134144.zip)
```
CREATE TABLE bb (
bizVersion string,
fileBody array<row<
request_msg string
>>,
fileHead row<
fileSeq string,
recCompanyID string,
sndCompanyID string
>,
fileTail row<
createTime string,
poOrderCnt string
>,
raw_rowtime timestamp(3),
dt string
)
PARTITIONED BY (dt) with (
'compaction.max.file-num'='100',
'full-compaction.delta-commits' = '50',
'continuous.discovery-interval' = '1s')
```
Query paimon table in Trino 423 and got error
```
[2023-08-17 13:43:21] 0 rows retrieved in 620 ms (execution: 299 ms, fetching: 321 ms)
[2023-08-17 13:43:21] [65536] Query failed (#20230817_054320_00021_7spqn): 'io.trino.spi.block.BlockBuilder io.trino.spi.block.BlockBuilder.beginBlockEntry()'
[2023-08-17 13:43:21] java.lang.NoSuchMethodError: 'io.trino.spi.block.BlockBuilder io.trino.spi.block.BlockBuilder.beginBlockEntry()'
```
paimon-trino-422-0.5-20230817.000424-24.jar
trino-server-423
Query same table in Trino 420 and success
paimon-trino-393-0.5-SNAPSHOT-07102100.jar
trino-server-420
--
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 #1491: [Bug] Error in querying primary key table with row type column under trino
Posted by "JingsongLi (via GitHub)" <gi...@apache.org>.
JingsongLi commented on issue #1491:
URL: https://github.com/apache/incubator-paimon/issues/1491#issuecomment-1623048553
> I have put paimon-trino-393-0.5-20230704.000507-57.jar in trino/plugins/paimon directory, and I can query other 2 paimon table without_row and with_row_append.
Do you have whole stack error message?
--
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] macdoor commented on issue #1491: [Bug] Error in querying primary key table with row type column under trino
Posted by "macdoor (via GitHub)" <gi...@apache.org>.
macdoor commented on issue #1491:
URL: https://github.com/apache/incubator-paimon/issues/1491#issuecomment-1621592035
I put paimon-trino-393-0.5-20230704.000507-57.jar in trino/plugin/paimon directory, and I can other 2 paimon table without_row and 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
[GitHub] [incubator-paimon] JingsongLi commented on issue #1491: [Bug] Error in querying primary key table with row type column under trino
Posted by "JingsongLi (via GitHub)" <gi...@apache.org>.
JingsongLi commented on issue #1491:
URL: https://github.com/apache/incubator-paimon/issues/1491#issuecomment-1621443037
It seems that you haven't copied the Paimon jar to the work node?
--
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
Re: [I] [Bug] Error in querying primary key table with row type column under trino [paimon]
Posted by "JingsongLi (via GitHub)" <gi...@apache.org>.
JingsongLi closed issue #1491: [Bug] Error in querying primary key table with row type column under trino
URL: https://github.com/apache/paimon/issues/1491
--
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] macdoor commented on issue #1491: [Bug] Error in querying primary key table with row type column under trino
Posted by "macdoor (via GitHub)" <gi...@apache.org>.
macdoor commented on issue #1491:
URL: https://github.com/apache/incubator-paimon/issues/1491#issuecomment-1619466663
Trino 420
--
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
Re: [I] [Bug] Error in querying primary key table with row type column under trino [paimon]
Posted by "JingsongLi (via GitHub)" <gi...@apache.org>.
JingsongLi commented on issue #1491:
URL: https://github.com/apache/paimon/issues/1491#issuecomment-2094150638
This is a version support issue. Please try latest paimon-trino.
--
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] macdoor commented on issue #1491: [Bug] Error in querying primary key table with row type column under trino
Posted by "macdoor (via GitHub)" <gi...@apache.org>.
macdoor commented on issue #1491:
URL: https://github.com/apache/incubator-paimon/issues/1491#issuecomment-1623424533
[server.log.zip](https://github.com/apache/incubator-paimon/files/11967218/server.log.zip)
Here is Trino log
--
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