maropu commented on a change in pull request #28151: [SPARK-31383][SQL][DOC]
Clean up the SQL documents in docs/sql-ref*
URL: https://github.com/apache/spark/pull/28151#discussion_r405990002
##########
File path: docs/sql-ref-syntax-aux-show-table.md
##########
@@ -61,123 +64,123 @@ SHOW TABLE EXTENDED [ IN | FROM database_name ] LIKE
'identifier_with_wildcards'
</code>
</dd>
</dl>
+
### Examples
+
{% highlight sql %}
-- Assumes `employee` table created with partitioned by column `grade`
--- +-------+--------+--+
--- | name | grade |
--- +-------+--------+--+
--- | sam | 1 |
--- | suj | 2 |
--- +-------+--------+--+
+CREATE TABLE employee(name STRING, grade INT) PARTITIONED BY (grade);
+INSERT INTO employee PARTITION (grade = 1) VALUES ('sam');
+INSERT INTO employee PARTITION (grade = 2) VALUES ('suj');
-- Show the details of the table
-SHOW TABLE EXTENDED LIKE `employee`;
-+--------+---------+-----------+---------------------------------------------------------------
-|database|tableName|isTemporary| information
-+--------+---------+-----------+---------------------------------------------------------------
-|default |employee |false |Database: default
- Table: employee
- Owner: root
- Created Time: Fri Aug 30 15:10:21 IST 2019
- Last Access: Thu Jan 01 05:30:00 IST 1970
- Created By: Spark 3.0.0-SNAPSHOT
- Type: MANAGED
- Provider: hive
- Table Properties:
[transient_lastDdlTime=1567158021]
- Location:
file:/opt/spark1/spark/spark-warehouse/employee
- 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
- Partition Columns: [`grade`]
- Schema: root
- |-- name: string (nullable = true)
- |-- grade: integer (nullable = true)
-
-+--------+---------+-----------+---------------------------------------------------------------
+SHOW TABLE EXTENDED LIKE 'employee';
+
+--------+---------+-----------+--------------------------------------------------------------+
+ |database|tableName|isTemporary| information
|
+
+--------+---------+-----------+--------------------------------------------------------------+
+ |default |employee |false |Database: default
+ Table: employee
+ Owner: root
+ Created Time: Fri Aug 30 15:10:21 IST 2019
+ Last Access: Thu Jan 01 05:30:00 IST 1970
+ Created By: Spark 3.0.0-SNAPSHOT
+ Type: MANAGED
+ Provider: hive
+ Table Properties:
[transient_lastDdlTime=1567158021]
+ Location:
file:/opt/spark1/spark/spark-warehouse/employee
+ 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
+ Partition Columns: [`grade`]
+ Schema: root
+ |-- name: string (nullable = true)
+ |-- grade: integer (nullable = true)
+
+
+--------+---------+-----------+--------------------------------------------------------------+
Review comment:
Yea right, but the information cell itself assumes to be left-aligned, so I
left it as it is. Probably, this is an exception case.
----------------------------------------------------------------
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]
With regards,
Apache Git Services
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
