wangyum commented on a change in pull request #32563:
URL: https://github.com/apache/spark/pull/32563#discussion_r637663948
##########
File path: sql/core/src/test/resources/sql-tests/results/show-tables.sql.out
##########
@@ -120,19 +120,9 @@ show_t3
-- !query
SHOW TABLE EXTENDED LIKE 'show_t*'
-- !query schema
-struct<namespace:string,tableName:string,isTemporary:boolean,information:string>
+struct<namespace:string,tableName:string,isTemporary:boolean,information:map<string,string>>
-- !query output
- show_t3 true Table: show_t3
Review comment:
`beeline` before:
```
0: jdbc:hive2://localhost:10000> set
spark.sql.legacy.keepCommandOutputSchema=true;
+-------------------------------------------+--------+
| key | value |
+-------------------------------------------+--------+
| spark.sql.legacy.keepCommandOutputSchema | true |
+-------------------------------------------+--------+
1 row selected (0.055 seconds)
0: jdbc:hive2://localhost:10000> SHOW TABLE EXTENDED LIKE '*';
+-----------+---------------+--------------+----------------------------------------------------+
| database | tableName | isTemporary | information
|
+-----------+---------------+--------------+----------------------------------------------------+
| default | test_parquet | false | CatalogTable(
Database: default
Table: test_parquet
Owner: yumwang
Created Time: Mon May 24 11:16:33 CST 2021
Last Access: UNKNOWN
Created By: Spark 3.2.0-SNAPSHOT
Type: MANAGED
Provider: hive
Table Properties: [transient_lastDdlTime=1621826201]
Statistics: 290 bytes
Location: file:/Users/yumwang/tmp/xxxx/spark/spark-warehouse/test_parquet
Serde Library: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
InputFormat: org.apache.hadoop.mapred.TextInputFormat
OutputFormat: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Storage Properties: [serialization.format=1]
Partition Provider: Catalog
Schema: root
|-- id: long (nullable = false)
)
|
+-----------+---------------+--------------+----------------------------------------------------+
1 row selected (0.086 seconds)
```
`beeline` after:
```
0: jdbc:hive2://localhost:10000> SHOW TABLE EXTENDED LIKE '*';
+------------+---------------+--------------+----------------------------------------------------+
| namespace | tableName | isTemporary | information
|
+------------+---------------+--------------+----------------------------------------------------+
| default | test_parquet | false | {"Created By":"Spark
3.2.0-SNAPSHOT","Created Time":"Mon May 24 11:16:33 CST
2021","Database":"default","InputFormat":"org.apache.hadoop.mapred.TextInputFormat","Last
Access":"UNKNOWN","Location":"file:/Users/yumwang/tmp/xxxx/spark/spark-warehouse/test_parquet","OutputFormat":"org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat","Owner":"yumwang","Partition
Provider":"Catalog","Provider":"hive","Schema":"root
|-- id: long (nullable = false)
","Serde
Library":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe","Statistics":"290
bytes","Storage Properties":"[serialization.format=1]","Table
Properties":"[transient_lastDdlTime=1621826201]","Table":"test_parquet","Type":"MANAGED"}
|
+------------+---------------+--------------+----------------------------------------------------+
1 row selected (0.903 seconds)
```
--
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.
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org
For additional commands, e-mail: reviews-h...@spark.apache.org
