sanel commented on pull request #2086:
URL: https://github.com/apache/drill/pull/2086#issuecomment-645847523
Here are few more suggestions
```diff
--- 060-querying-the-information-schema.md.old 2020-06-18
09:51:39.640215255 +0200
+++ 060-querying-the-information-schema.md 2020-06-18 09:51:50.553274730
+0200
@@ -74,11 +74,11 @@
The VIEWS table returns the name and definition for each view in your
databases. Note that file schemas are the canonical repository for views in
Drill. Depending on how you create a view, they may only be displayed in
Drill
-after it has been used.
+after being used.
## PARTITIONS
-The PARTITIONS table returns information about table partitions including
partition columns, partition keys, etc. for each table.
+The PARTITIONS table returns information about table partitions, including
partition columns, partition keys, etc. for each table.
## FILES
@@ -142,7 +142,7 @@
| DRILL | s3_years_bucket.root | <owner> | file | NO
|
+---------------+--------------------------+---------------+-------+-------------+
-Querying the FILES table and filtering on the SCHEMA_NAME provides
information about the files that exist within a workspace:
+Querying the FILES table and filtering on the SCHEMA_NAME provides
information about the files within a workspace:
**Note:** The word “files” is a reserved word in Drill and requires
backticks (``).
@@ -235,7 +235,7 @@
### TABLES Queries
Run an ``INFORMATION_SCHEMA.`TABLES` ``query to view all of the tables and
views
-
+within a database. TABLES is a reserved word in Drill and requires backticks
(`).
For example, the following query identifies all of the tables and views that
```
----------------------------------------------------------------
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]
