sathesuraj commented on issue #2464: URL: https://github.com/apache/polaris/issues/2464#issuecomment-3236401723
@flyrain / @singhpk234 - I haven't tried using E2E tests yet. In CockroachDB, executing the schema SQL results in all INT types being created and stored as INT8. However, if you explicitly specify the type as INT4 in the SQL, the column is saved with the type alias as INT4, though it is still stored internally as INT8. To make it work with CockroachDB, I explicitly specified the type as INT4 in the SQL files and executed them before running the bootstrap process. This created an alias for those columns as INT4, even though they are internally stored as INT8. This approach allows the columns to be read as Integer in Java, enabling the use of CockroachDB as a metastore for Polaris. For example, the types were updated for columns in the "entities" table were - entity_version, type_code, sub_type_code, and grant_record_version. No code or config change was required. -- 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]
