The location of a spark table does not take effect when creating a spark table

[yuqi1129]

When I try to create a Lance table via the following code

spark = SparkSession.builder \
    .appName("gcs_fielset_test") \
    .config("spark.sql.catalog.lance", "org.lance.spark.LanceNamespaceSparkCatalog") \
    .config("spark.sql.catalog.lance.impl", "dir") \
    .config("spark.executor.memory", "3g") \
    .config("spark.sql.catalog.lance.parent", "lance_catalog") \
    .config("spark.sql.defaultCatalog", "lance") \
    .getOrCreate()  

results = spark.sql("""
create table schema.t23(id int, score float) USING lance LOCATION '/tmp/schema/t23.lance/' TBLPROPERTIES  ('format' = 'lance')
""")
results.show()

The location /tmp/schema/t23.lance/ can't take effect.

[yuqi1129]

By the way, what's the real definition of createEmptyTable and registerTable? According the code, it seems that createEmptyTable only records the metadata of the table, such as location, properties, so it's the detail implementation that decides the value of the location of an empty table? What if users need to specify the location by themself as what has been showed above?

[yuqi1129]

When I try to create a Lance table via the following code

spark = SparkSession.builder \
    .appName("gcs_fielset_test") \
    .config("spark.sql.catalog.lance", "org.lance.spark.LanceNamespaceSparkCatalog") \
    .config("spark.sql.catalog.lance.impl", "dir") \
    .config("spark.executor.memory", "3g") \
    .config("spark.sql.catalog.lance.uri", "xxxx") \
    .config("spark.sql.catalog.lance.parent", "lance_catalog") \
    .config("spark.sql.defaultCatalog", "lance") \
    .getOrCreate()  

results = spark.sql("""
create table schema.t23(id int, score float) USING lance LOCATION '/tmp/schema/t23.lance/' TBLPROPERTIES  ('format' = 'lance')
""")
results.show()

The location /tmp/schema/t23.lance/ can't take effect.

@jackye1995 ,Is this by design that users can't specify the location by themself via SQL?