You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@iceberg.apache.org by GitBox <gi...@apache.org> on 2022/06/14 03:10:46 UTC

[GitHub] [iceberg] noneback opened a new issue, #5027: JDBC Catalog create table DDL is not compatible for MYSQL 8.0.29

noneback opened a new issue, #5027:
URL: https://github.com/apache/iceberg/issues/5027

   env: Ubuntu 20.04LTS, MYSQL 8.0.29 with InnoDB, Iceberg-flink-runtime built from the main branch, Flink1.15.
   
   I am trying to use JDBC as the catalog in flink with iceberg, and I cannot create those `iceberg_namespace_properties` table because the attributes are too long as an index key.  
   
   Ref: #5014 
   
   [MySQL 8.0 Reference Manual](https://dev.mysql.com/doc/refman/8.0/en/innodb-limits.html)


-- 
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@iceberg.apache.org.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org


[GitHub] [iceberg] danielcweeks closed issue #5027: JDBC Catalog create table DDL is not compatible for MYSQL 8.0.29

Posted by GitBox <gi...@apache.org>.
danielcweeks closed issue #5027: JDBC Catalog create table DDL is not compatible for MYSQL 8.0.29
URL: https://github.com/apache/iceberg/issues/5027


-- 
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@iceberg.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org


[GitHub] [iceberg] Kontinuation commented on issue #5027: JDBC Catalog create table DDL is not compatible for MYSQL 8.0.29

Posted by GitBox <gi...@apache.org>.
Kontinuation commented on issue #5027:
URL: https://github.com/apache/iceberg/issues/5027#issuecomment-1209300544

   `NAMESPACE_PROPERTY_KEY` [was defined as `VARCHAR(5500)`](https://github.com/apache/iceberg/blob/apache-iceberg-0.14.0/core/src/main/java/org/apache/iceberg/jdbc/JdbcUtil.java#L91), it may not have to be that long. Some value less than 500 is good enough I guess?


-- 
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@iceberg.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org


[GitHub] [iceberg] nastra commented on issue #5027: JDBC Catalog create table DDL is not compatible for MYSQL 8.0.29

Posted by GitBox <gi...@apache.org>.
nastra commented on issue #5027:
URL: https://github.com/apache/iceberg/issues/5027#issuecomment-1333676057

   @noneback are you able to increase the limit on MySql? Usually different databases impose different limits, but I'll see if we can lower namespace properties from 5500.


-- 
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@iceberg.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org


[GitHub] [iceberg] nastra commented on issue #5027: JDBC Catalog create table DDL is not compatible for MYSQL 8.0.29

Posted by GitBox <gi...@apache.org>.
nastra commented on issue #5027:
URL: https://github.com/apache/iceberg/issues/5027#issuecomment-1333969840

   I have created to https://github.com/apache/iceberg/pull/6338 to make this less of an issue with MySql


-- 
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@iceberg.apache.org

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


---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@iceberg.apache.org
For additional commands, e-mail: issues-help@iceberg.apache.org