You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hawq.apache.org by yo...@apache.org on 2017/01/20 16:41:44 UTC
[5/7] incubator-hawq-docs git commit: HAWQ-1272 Modify code sample to
use standard SQL syntax (closes #87)
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 <jb...@pivotal.io>
Authored: Mon Jan 16 15:15:14 2017 -0800
Committer: David Yozie <yo...@apache.org>
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;
```