singhpk234 commented on PR #5006: URL: https://github.com/apache/iceberg/pull/5006#issuecomment-1153492893
@rdblue, Considering now we have register table stored-procedure in, was thinking if there is a pure SQL way to find this property. I had a migration use case (i.e migrate hive tables to glue), had to go to glue UI to find this path and then register it via SQL and also vice-versa went to hive table params to find it and register in glue. ``` MariaDB [hive]> SELECT * from TBLS where TBL_NAME='store_sales' MariaDB [hive]> SELECT * FROM TABLE_PARAMS where TBL_ID = xx ``` Apologies if there exists some other SQL way to find it, I thought that having this exposed in describe table could have helped me. I agree this is not a property of the table but a state of the table. This was my rationale behind putting a pr out for this change. Would love to know your thoughts about the same. Agree with you, there exists an alternative way for us to find this as well, so it's not like it can't be worked around : ```java Table table = Spark3Util.loadIcebergTable(spark, tableName); String metadataJson = ((HiveTableOperations) (((HasTableOperations) table).operations())).currentMetadataLocation(); ``` -- 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]
