HAWQ-1272 Modify code sample to use standard SQL syntax (closes #87)
Project: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/commit/87328a58 Tree: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/tree/87328a58 Diff: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/diff/87328a58 Branch: refs/heads/release/2.1.0.0-incubating Commit: 87328a58b029aae030ab7542a5862d4d664ff6fb Parents: de32485 Author: Jane Beckman <[email protected]> Authored: Mon Jan 16 15:15:14 2017 -0800 Committer: David Yozie <[email protected]> Committed: Mon Jan 16 15:15:14 2017 -0800 ---------------------------------------------------------------------- markdown/reference/toolkit/hawq_toolkit.html.md.erb | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/87328a58/markdown/reference/toolkit/hawq_toolkit.html.md.erb ---------------------------------------------------------------------- diff --git a/markdown/reference/toolkit/hawq_toolkit.html.md.erb b/markdown/reference/toolkit/hawq_toolkit.html.md.erb index ac5db66..b898061 100644 --- a/markdown/reference/toolkit/hawq_toolkit.html.md.erb +++ b/markdown/reference/toolkit/hawq_toolkit.html.md.erb @@ -101,9 +101,9 @@ The `hawq_size_*` family of views can be used to determine the disk space usage The table and index sizing views list the relation by object ID (not by name). To check the size of a table or index by name, you must look up the relation name (`relname`) in the `pg_class` table. For example: ``` pre -SELECT relname as name, sotdsize as size, sotdtoastsize as -toast, sotdadditionalsize as other -FROM hawq_size_of_table_disk as sotd, pg_class +SELECT relname AS name, sotdsize AS size, sotdtoastsize AS +toast, sotdadditionalsize AS other +FROM hawq_size_of_table_disk AS sotd, pg_class WHERE sotd.sotdoid=pg_class.oid ORDER BY relname; ```
