shivusondur commented on a change in pull request #25632:
[SPARK-28809][DOC][SQL]Document SHOW TABLE in SQL Reference
URL: https://github.com/apache/spark/pull/25632#discussion_r340242794
##########
File path: docs/sql-ref-syntax-aux-show-table.md
##########
@@ -18,5 +18,147 @@ license: |
See the License for the specific language governing permissions and
limitations under the License.
---
+### Description
-**This page is under construction**
+SHOW TABLE EXTENDED will show information for all tables matching the given
regular expression.
+Output includes basic table information and file system information like `Last
Access`,
+`Created By`, `Type`, `Provider`, `Table Properties`, `Location`, `Serde
Library`, `InputFormat`,
+`OutputFormat`, `Storage Properties`, `Partition Provider`, `Partition
Columns` and `Schema`.
+
+Users cannot use regular expression for table name if a partition
specification is present and it will output
+the given partition's file specific system information such as `Partition
Parameters` and `Partition Statistics`
+
+### Syntax
+{% highlight sql %}
+SHOW TABLE EXTENDED [IN|FROM database_name] LIKE 'identifier_with_wildcards'
[PARTITION(partition_spec)];
+{% endhighlight %}
+
+### Parameters
+<dl>
+ <dt><code><em>IN|FROM database_name</em></code></dt>
+ <dd>
+ Specifies database name. If not provided, will use the current database.
+ </dd>
+ <dt><code><em>LIKE string_pattern</em></code></dt>
+ <dd>
+ Specifies a string pattern that is used to match the table in the
database.
Review comment:
updated the details
----------------------------------------------------------------
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]
