Display Table Location in Spark SQL Properties

[RussellSpitzer]

I realized today that while you are able to set the location of an Iceberg Table in Spark3, you cannot then view that location using the standard SQL commands.

Maybe we should considering populating this in table properties?

[RussellSpitzer]

I would also tag this as "good first ticket" but I do not know how to add labels

[aokolnychyi]

I feel it will be useful.

[aokolnychyi]

@flyrain, would you be interested in working on this?

[aokolnychyi]

We need to check if this will have any possible implications.

[aokolnychyi]

As far as I see, Spark passes the location as a table property. I think we can fake it in SparkTable like we fake the provider and the current snapshot id.

[aokolnychyi]

I think we can simply adapt SparkTable$properties.

[RussellSpitzer]

Totally agree, I was worried about it being mis used somewhere, but I think this is the right thing to do, and of course we should add it to "reserved properties" too because currently you can set this but it has no effect

[flyrain]

Looking at this.

[somayaj]

Can this be worked?

[flyrain]

Hi @somayaj , the PR #2330 has been merged into the master branch. Please have a try.

[aokolnychyi]

Closing this one as it has been fixed.