[Subtask] [spark connector] support hive table location properties

[FANNG1]

Describe the subtask

supports location properties, transform from Spark location to Gravitino location, please add UT to TestHivePropertiesConverter, add IT to SparkHiveCatalogIT.

CREATE TABLE xx LOCATION xxx

Parent issue

#1549

[FANNG1]

@Yangxuhao123 you could refer #2605

[Yangxuhao123]

Sorry, I've dealt with some things during this time. Have you completed this part of the work? @FANNG1

[FANNG1]

Sorry, I've dealt with some things during this time. Have you completed this part of the work? @FANNG1

No, I haven't finished it, do you have time to work on this?

[Yangxuhao123]

Ok, I will do it.

[charliecheng630]

May I take on this issue?

[FANNG1]

May I take on this issue?

@Yangxuhao123 is working on this

[Yangxuhao123]

May I take on this issue?

OK, you can do it, I can work on other issues in the future.

[charliecheng630]

@FANNG1 Should I support external property? CREATE EXTERNAL TABLE xxx LOCATION xxx

three testing scenario cases I thought:

1. put a file into HDFS first
   then CREATE EXTERNAL TABLE xxx LOCATION xxx
   checkTableReadWrite
   dropTable
   checkDataFileExists

2. CREATE EXTERNAL TABLE xxx LOCATION xxx
   checkTableReadWrite
   dropTable
   checkDataFileExists

3. CREATE TABLE xxx LOCATION xxx
   checkTableReadWrite
   dropTable
   checkDataFileExists

What are your thoughts?

[FANNG1]

For location property, the main target of the test is to check whether data is placed in the specified location, so I think we should test the following scenes for managed table and external table.

CREATE [EXTERNAL] TABLE xxx LOCATION xxx

1. checkTableReadWrite
2. checkTablelocation equals the specified location. please note that hive may change the location from /xxpath to hdfs://xx:xx/xxpath
3. checkDataFileExists

[charliecheng630]

@FANNG1 the key of location property in Gravitino is same as Spark, do we still need to modify the converter?

[FANNG1]

@FANNG1 the key of location property in Gravitino is same as Spark, do we still need to modify the converter?

I think it's necessary to transform it explicitly, they are happens to the same.