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:
users@infra.apache.org
|