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