From commits-return-7666-archive-asf-public=cust-asf.ponee.io@trafodion.apache.org Mon Jun 4 13:19:53 2018 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id 41894180636 for ; Mon, 4 Jun 2018 13:19:53 +0200 (CEST) Received: (qmail 70367 invoked by uid 500); 4 Jun 2018 11:19:52 -0000 Mailing-List: contact commits-help@trafodion.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: commits@trafodion.apache.org Delivered-To: mailing list commits@trafodion.apache.org Received: (qmail 70358 invoked by uid 99); 4 Jun 2018 11:19:52 -0000 Received: from git1-us-west.apache.org (HELO git1-us-west.apache.org) (140.211.11.23) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 04 Jun 2018 11:19:52 +0000 Received: by git1-us-west.apache.org (ASF Mail Server at git1-us-west.apache.org, from userid 33) id 37C02DFA6D; Mon, 4 Jun 2018 11:19:52 +0000 (UTC) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: liuyu@apache.org To: commits@trafodion.apache.org Date: Mon, 04 Jun 2018 11:19:52 -0000 Message-Id: X-Mailer: ASF-Git Admin Mailer Subject: [1/4] trafodion git commit: Add Examples for *CONTROL QUERY DEFAULT Statement* in *Trafodion SQL Reference Manual* Repository: trafodion Updated Branches: refs/heads/master 3a89dbaee -> 288ed2103 Add Examples for *CONTROL QUERY DEFAULT Statement* in *Trafodion SQL Reference Manual* Project: http://git-wip-us.apache.org/repos/asf/trafodion/repo Commit: http://git-wip-us.apache.org/repos/asf/trafodion/commit/f5c28e96 Tree: http://git-wip-us.apache.org/repos/asf/trafodion/tree/f5c28e96 Diff: http://git-wip-us.apache.org/repos/asf/trafodion/diff/f5c28e96 Branch: refs/heads/master Commit: f5c28e9656b56c58f1009080448169f0be1503c3 Parents: 6b967b6 Author: liu.yu Authored: Thu May 24 16:54:17 2018 +0800 Committer: liu.yu Committed: Thu May 24 16:54:17 2018 +0800 ---------------------------------------------------------------------- .../src/asciidoc/_chapters/sql_statements.adoc | 13 +++++++++---- 1 file changed, 9 insertions(+), 4 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/trafodion/blob/f5c28e96/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc ---------------------------------------------------------------------- diff --git a/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc b/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc index 5a76ffb..ed3656e 100644 --- a/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc +++ b/docs/sql_reference/src/asciidoc/_chapters/sql_statements.adoc @@ -1484,16 +1484,21 @@ EXECUTE y; -- uses MYSCHEMA; [[control_query_default_examples]] === Examples of CONTROL QUERY DEFAULT -* Increase the cache refresh time for the histogram cache to two hours (7,200 minutes). +* This example changes the maximum degree of parallelism to 2 for a query. The value must be less than the number of CPUs in the cluster. + ``` -CONTROL QUERY DEFAULT CACHE_HISTOGRAMS_REFRESH_INTERVAL '7200'; +SQL>CONTROL QUERY DEFAULT PARALLEL_NUM_ESPS '2'; + +--- SQL operation complete. ``` -* Reset the CACHE_HISTOGRAMS_REFRESH_INTERVAL attribute to its initial value in the current process: +* This example resets the `PARALLEL_NUM_ESPS` attribute to its system value in the current process, +in this case, the compiler calculates the number of ESPs to be used. + ``` -CONTROL QUERY DEFAULT CACHE_HISTOGRAMS_REFRESH_INTERVAL RESET; +SQL>CONTROL QUERY DEFAULT PARALLEL_NUM_ESPS 'system'; + +--- SQL operation complete. ``` <<<