FANNG1 commented on issue #4932:
URL: https://github.com/apache/gravitino/issues/4932#issuecomment-2361205549
I setup two hivemestatore with sperate hdfs cluster, and couldn't reproduce
this issue with following SQLs in both of the two catalogs.
```
create table a(a int) location
'hdfs://localhost:9000/user/hive/warehouse/t1.db/a';
```
```
show create table a;
CREATE TABLE t1.a (
a INT)
LOCATION 'hdfs://localhost:9000/user/hive/warehouse/t1.db/a'
TBLPROPERTIES (
'input-format' = 'org.apache.hadoop.mapred.TextInputFormat',
'output-format' =
'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat',
'serde-lib' = 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe',
'serde-name' = 'a',
'table-type' = 'MANAGED_TABLE',
'transient_lastDdlTime' = '1726756779')
```
```
explain show create table a;
explain show create table a
== Physical Plan ==
ShowCreateTable [createtab_stmt#36],
HiveTable(org.apache.spark.sql.SparkSession@7752f9fe,CatalogTable(
Database: t1
Table: a
Owner: hive
Created Time: Thu Sep 19 22:39:39 CST 2024
Last Access: UNKNOWN
Created By: Spark 2.2 or prior
Type: MANAGED
Provider: hive
Table Properties: [gravitino.identifier=gravitino.v1.uid1812375099371418513,
owner=hive, transient_lastDdlTime=1726756779]
Location: hdfs://localhost:9000/user/hive/warehouse/t1.db/a
Serde Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
InputFormat: org.apache.hadoop.mapred.TextInputFormat
OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Partition Provider: Catalog
Schema: root
|-- a: integer (nullable = true)
),org.apache.kyuubi.spark.connector.hive.HiveTableCatalog@61563a91)
```
--
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]
