Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id F311F200B72 for ; Fri, 22 Jul 2016 02:50:37 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id F21EB160A73; Fri, 22 Jul 2016 00:50:37 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 481F2160A7C for ; Fri, 22 Jul 2016 02:50:37 +0200 (CEST) Received: (qmail 99972 invoked by uid 500); 22 Jul 2016 00:50:36 -0000 Mailing-List: contact commits-help@drill.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: commits@drill.apache.org Delivered-To: mailing list commits@drill.apache.org Received: (qmail 99916 invoked by uid 99); 22 Jul 2016 00:50:36 -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; Fri, 22 Jul 2016 00:50:36 +0000 Received: by git1-us-west.apache.org (ASF Mail Server at git1-us-west.apache.org, from userid 33) id 2A188E35EB; Fri, 22 Jul 2016 00:50:36 +0000 (UTC) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: bridgetb@apache.org To: commits@drill.apache.org Date: Fri, 22 Jul 2016 00:50:36 -0000 Message-Id: <60ffe17645c2462e9b3975c2f86a63c8@git.apache.org> X-Mailer: ASF-Git Admin Mailer Subject: [1/3] drill git commit: fix link for CTAS statement in SQL commands page archived-at: Fri, 22 Jul 2016 00:50:38 -0000 Repository: drill Updated Branches: refs/heads/gh-pages 9754b79d9 -> 0602842d4 fix link for CTAS statement in SQL commands page Project: http://git-wip-us.apache.org/repos/asf/drill/repo Commit: http://git-wip-us.apache.org/repos/asf/drill/commit/d0de42c8 Tree: http://git-wip-us.apache.org/repos/asf/drill/tree/d0de42c8 Diff: http://git-wip-us.apache.org/repos/asf/drill/diff/d0de42c8 Branch: refs/heads/gh-pages Commit: d0de42c8e782997027be4c3e3cccdbd4155c7007 Parents: 9754b79 Author: Bridget Bevens Authored: Thu Jul 21 17:26:57 2016 -0700 Committer: Bridget Bevens Committed: Thu Jul 21 17:26:57 2016 -0700 ---------------------------------------------------------------------- _docs/sql-reference/sql-commands/005-supported-sql-commands.md | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/drill/blob/d0de42c8/_docs/sql-reference/sql-commands/005-supported-sql-commands.md ---------------------------------------------------------------------- diff --git a/_docs/sql-reference/sql-commands/005-supported-sql-commands.md b/_docs/sql-reference/sql-commands/005-supported-sql-commands.md index d1e5cbc..5a87073 100644 --- a/_docs/sql-reference/sql-commands/005-supported-sql-commands.md +++ b/_docs/sql-reference/sql-commands/005-supported-sql-commands.md @@ -1,6 +1,6 @@ --- title: Supported SQL Commands -date: +date: 2016-07-22 00:26:58 UTC parent: "SQL Commands" --- The following table provides a list of the SQL commands that Drill supports, @@ -12,7 +12,7 @@ with their descriptions and example syntax: | [ALTER SYSTEM SET]({{site.baseurl}}/docs/alter-system) | Changes a system setting. The new setting persists across all sessions. For a list of Drill options and their descriptions, see [Planning and Execution Options]{{site.baseurl/docs/planning-and-execution-options/}}. | ALTER SYSTEM SET \`option_name` = value; | | [ALTER SYSTEM RESET]({{site.baseurl}}/docs/alter-system) | Changes a system setting back to its default system setting. For a list of Drill options and their descriptions, see [Planning and Execution Options]{{site.baseurl/docs/planning-and-execution-options/}}. | ALTER SYSTEM RESET \`option_name`; | | [ALTER SYSTEM RESET ALL]({{site.baseurl}}/docs/alter-system) | Changes all system settings back to their default system values. For a list of Drill options and their descriptions, see [Planning and Execution Options]{{site.baseurl/docs/planning-and-execution-options/}}. | ALTER SYSTEM RESET ALL; | -| [CREATE TABLE AS(CTAS) ]({{site.baseurl}}/docs/create-table-as--ctas) | Creates a new table and populates the new table with rows returned from a SELECT query. Use the CREATE TABLE AS (CTAS) statement in place of INSERT INTO. | CREATE TABLE name AS query; | +| [CREATE TABLE AS(CTAS)]({{site.baseurl}}/docs/create-table-as-ctas/) | Creates a new table and populates the new table with rows returned from a SELECT query. Use the CREATE TABLE AS (CTAS) statement in place of INSERT INTO. | CREATE TABLE name AS query; | | [CREATE VIEW]({{site.baseurl}}/docs/create-view) | Creates a virtual structure for the result set of a stored query.- | CREATE [OR REPLACE] VIEW [workspace.]view_name [ (column_name [, ...]) ] AS query; | | [DESCRIBE ]({{site.baseurl}}/docs/describe) | Returns information about columns in a table or view. | DESCRIBE [workspace.]table_name | | [DROP VIEW]({{site.baseurl}}/docs/drop-view) | Removes a view. | DROP VIEW [workspace.]view_name ; |