wangyum commented on a change in pull request #32563:
URL: https://github.com/apache/spark/pull/32563#discussion_r637662935
##########
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:
`spark-sql` Before:
```
spark-sql> set spark.sql.legacy.keepCommandOutputSchema=true;
spark.sql.legacy.keepCommandOutputSchema true
Time taken: 0.012 seconds, Fetched 1 row(s)
spark-sql> SHOW TABLE EXTENDED LIKE '*';
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)
)
Time taken: 0.031 seconds, Fetched 1 row(s)
```
`spark-sql` After:
```
spark-sql> SHOW TABLE EXTENDED LIKE '*';
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"}
Time taken: 0.043 seconds, Fetched 1 row(s)
```
--
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:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
