flyrain commented on PR #4456: URL: https://github.com/apache/iceberg/pull/4456#issuecomment-1092005839
Talked to @szehon-ho offline. We will give a default value for the HIVE_TABLE_PROPERTY_SIZE, while allowing user to configure it with different number due to a variety of HMS backends. > Oracle DB's varchar2 supports 32767 bytes now, by setting the configuration parameter MAX_STRING_SIZE to EXTENDED. ([source](http://docs.oracle.com/database/121/SQLRF/sql_elements001.htm#SQLRF55623)) > Postgres supports a max of 1GB for character datatype. ([source](http://www.postgresql.org/docs/8.3/static/datatype-character.html)) > MySQL can support upto 65535 bytes for the entire row. So long as the PARAM_KEY value + PARAM_VALUE is less than 65535, we should be good. ([source](http://dev.mysql.com/doc/refman/5.0/en/char.html)) > SQL Server's varchar max length is 8000 and can go beyond using "varchar(max)" with the same limitation as MySQL being 65535 bytes for the entire row. ([source](http://dev.mysql.com/doc/refman/5.0/en/char.html)) > Derby's varchar can be upto 32672 bytes. ([source](https://db.apache.org/derby/docs/10.7/ref/rrefsqlj41207.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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
