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:00:48 UTC

[GitHub] [incubator-paimon-trino] macdoor opened a new issue, #18: Error in querying primary key table with row type column under trino

macdoor opened a new issue, #18:
URL: https://github.com/apache/incubator-paimon-trino/issues/18

   ref to https://github.com/apache/incubator-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.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Re: [I] Error in querying primary key table with row type column under trino [paimon-trino]

Posted by "JingsongLi (via GitHub)" <gi...@apache.org>.
JingsongLi closed issue #18: Error in querying primary key table with row type column under trino
URL: https://github.com/apache/paimon-trino/issues/18


-- 
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-trino] macdoor commented on issue #18: Error in querying primary key table with row type column under trino

Posted by "macdoor (via GitHub)" <gi...@apache.org>.
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


Re: [I] Error in querying primary key table with row type column under trino [paimon-trino]

Posted by "JingsongLi (via GitHub)" <gi...@apache.org>.
JingsongLi commented on issue #18:
URL: https://github.com/apache/paimon-trino/issues/18#issuecomment-2054332426

   Already fixed.


-- 
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