Return-Path: X-Original-To: apmail-drill-commits-archive@www.apache.org Delivered-To: apmail-drill-commits-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 8048E1879E for ; Mon, 18 May 2015 23:36:25 +0000 (UTC) Received: (qmail 58595 invoked by uid 500); 18 May 2015 23:36:25 -0000 Delivered-To: apmail-drill-commits-archive@drill.apache.org Received: (qmail 58505 invoked by uid 500); 18 May 2015 23:36:25 -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 57922 invoked by uid 99); 18 May 2015 23:36:25 -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, 18 May 2015 23:36:25 +0000 Received: by git1-us-west.apache.org (ASF Mail Server at git1-us-west.apache.org, from userid 33) id 17A22E0A05; Mon, 18 May 2015 23:36:25 +0000 (UTC) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: tshiran@apache.org To: commits@drill.apache.org Date: Mon, 18 May 2015 23:36:47 -0000 Message-Id: <60242f6b0ad54378809f8d03150b6086@git.apache.org> In-Reply-To: <408f81be21da42ada717f5460685b641@git.apache.org> References: <408f81be21da42ada717f5460685b641@git.apache.org> X-Mailer: ASF-Git Admin Mailer Subject: [24/31] drill git commit: add BB's clause pages, renamed sql command pages http://git-wip-us.apache.org/repos/asf/drill/blob/9700ff63/_data/docs.json ---------------------------------------------------------------------- diff --git a/_data/docs.json b/_data/docs.json index 6f8cde1..7fa1345 100644 --- a/_data/docs.json +++ b/_data/docs.json @@ -17,7 +17,7 @@ "title": "2014 Q1 Drill Report", "url": "/docs/2014-q1-drill-report/" }, - "ALTER SESSION Command": { + "ALTER SESSION": { "breadcrumbs": [ { "title": "SQL Commands", @@ -29,16 +29,16 @@ } ], "children": [], - "next_title": "ALTER SYSTEM Command", - "next_url": "/docs/alter-system-command/", + "next_title": "ALTER SYSTEM", + "next_url": "/docs/alter-system/", "parent": "SQL Commands", "previous_title": "Supported SQL Commands", "previous_url": "/docs/supported-sql-commands/", - "relative_path": "_docs/sql-reference/sql-commands/010-alter-session-command.md", - "title": "ALTER SESSION Command", - "url": "/docs/alter-session-command/" + "relative_path": "_docs/sql-reference/sql-commands/010-alter-session.md", + "title": "ALTER SESSION", + "url": "/docs/alter-session/" }, - "ALTER SYSTEM Command": { + "ALTER SYSTEM": { "breadcrumbs": [ { "title": "SQL Commands", @@ -50,14 +50,14 @@ } ], "children": [], - "next_title": "CREATE TABLE AS (CTAS) Command", - "next_url": "/docs/create-table-as-ctas-command/", + "next_title": "CREATE TABLE AS (CTAS)", + "next_url": "/docs/create-table-as-ctas/", "parent": "SQL Commands", - "previous_title": "ALTER SESSION Command", - "previous_url": "/docs/alter-session-command/", + "previous_title": "ALTER SESSION", + "previous_url": "/docs/alter-session/", "relative_path": "_docs/sql-reference/sql-commands/020-alter-system.md", - "title": "ALTER SYSTEM Command", - "url": "/docs/alter-system-command/" + "title": "ALTER SYSTEM", + "url": "/docs/alter-system/" }, "AOL Search": { "breadcrumbs": [ @@ -555,7 +555,7 @@ "title": "CASE", "url": "/docs/case/" }, - "CREATE TABLE AS (CTAS) Command": { + "CREATE TABLE AS (CTAS)": { "breadcrumbs": [ { "title": "SQL Commands", @@ -567,16 +567,16 @@ } ], "children": [], - "next_title": "CREATE VIEW Command", - "next_url": "/docs/create-view-command/", + "next_title": "CREATE VIEW", + "next_url": "/docs/create-view/", "parent": "SQL Commands", - "previous_title": "ALTER SYSTEM Command", - "previous_url": "/docs/alter-system-command/", - "relative_path": "_docs/sql-reference/sql-commands/030-create-table-as-command.md", - "title": "CREATE TABLE AS (CTAS) Command", - "url": "/docs/create-table-as-ctas-command/" + "previous_title": "ALTER SYSTEM", + "previous_url": "/docs/alter-system/", + "relative_path": "_docs/sql-reference/sql-commands/030-create-table-as.md", + "title": "CREATE TABLE AS (CTAS)", + "url": "/docs/create-table-as-ctas/" }, - "CREATE VIEW Command": { + "CREATE VIEW": { "breadcrumbs": [ { "title": "SQL Commands", @@ -588,14 +588,14 @@ } ], "children": [], - "next_title": "DESCRIBE Command", - "next_url": "/docs/describe-command/", + "next_title": "DROP VIEW", + "next_url": "/docs/drop-view/", "parent": "SQL Commands", - "previous_title": "CREATE TABLE AS (CTAS) Command", - "previous_url": "/docs/create-table-as-ctas-command/", - "relative_path": "_docs/sql-reference/sql-commands/050-create-view-command.md", - "title": "CREATE VIEW Command", - "url": "/docs/create-view-command/" + "previous_title": "CREATE TABLE AS (CTAS)", + "previous_url": "/docs/create-table-as-ctas/", + "relative_path": "_docs/sql-reference/sql-commands/050-create-view.md", + "title": "CREATE VIEW", + "url": "/docs/create-view/" }, "Compiling Drill from Source": { "breadcrumbs": [ @@ -1684,7 +1684,7 @@ "title": "Custom Function Interfaces", "url": "/docs/custom-function-interfaces/" }, - "DESCRIBE Command": { + "DESCRIBE": { "breadcrumbs": [ { "title": "SQL Commands", @@ -1696,14 +1696,35 @@ } ], "children": [], - "next_title": "EXPLAIN Commands", - "next_url": "/docs/explain-commands/", + "next_title": "EXPLAIN", + "next_url": "/docs/explain/", "parent": "SQL Commands", - "previous_title": "CREATE VIEW Command", - "previous_url": "/docs/create-view-command/", - "relative_path": "_docs/sql-reference/sql-commands/060-describe-command.md", - "title": "DESCRIBE Command", - "url": "/docs/describe-command/" + "previous_title": "DROP VIEW", + "previous_url": "/docs/drop-view/", + "relative_path": "_docs/sql-reference/sql-commands/060-describe.md", + "title": "DESCRIBE", + "url": "/docs/describe/" + }, + "DROP VIEW": { + "breadcrumbs": [ + { + "title": "SQL Commands", + "url": "/docs/sql-commands/" + }, + { + "title": "SQL Reference", + "url": "/docs/sql-reference/" + } + ], + "children": [], + "next_title": "DESCRIBE", + "next_url": "/docs/describe/", + "parent": "SQL Commands", + "previous_title": "CREATE VIEW", + "previous_url": "/docs/create-view/", + "relative_path": "_docs/sql-reference/sql-commands/055-drop-view.md", + "title": "DROP VIEW", + "url": "/docs/drop-view/" }, "Data Sources and File Formats": { "breadcrumbs": [], @@ -2725,7 +2746,7 @@ "title": "Driver Configuration Options", "url": "/docs/driver-configuration-options/" }, - "EXPLAIN Commands": { + "EXPLAIN": { "breadcrumbs": [ { "title": "SQL Commands", @@ -2737,14 +2758,14 @@ } ], "children": [], - "next_title": "SELECT Statements", - "next_url": "/docs/select-statements/", + "next_title": "SELECT", + "next_url": "/docs/select/", "parent": "SQL Commands", - "previous_title": "DESCRIBE Command", - "previous_url": "/docs/describe-command/", - "relative_path": "_docs/sql-reference/sql-commands/070-explain-commands.md", - "title": "EXPLAIN Commands", - "url": "/docs/explain-commands/" + "previous_title": "DESCRIBE", + "previous_url": "/docs/describe/", + "relative_path": "_docs/sql-reference/sql-commands/070-explain.md", + "title": "EXPLAIN", + "url": "/docs/explain/" }, "Embedded Mode Prerequisites": { "breadcrumbs": [ @@ -6003,7 +6024,7 @@ "title": "Reserved Keywords", "url": "/docs/reserved-keywords/" }, - "SELECT Statements": { + "SELECT": { "breadcrumbs": [ { "title": "SQL Commands", @@ -6015,16 +6036,205 @@ } ], "children": [], - "next_title": "SHOW DATABASES and SHOW SCHEMAS Command", - "next_url": "/docs/show-databases-and-show-schemas-command/", + "next_title": "SELECT FROM", + "next_url": "/docs/select-from/", "parent": "SQL Commands", - "previous_title": "EXPLAIN Commands", - "previous_url": "/docs/explain-commands/", + "previous_title": "EXPLAIN", + "previous_url": "/docs/explain/", "relative_path": "_docs/sql-reference/sql-commands/080-select.md", - "title": "SELECT Statements", - "url": "/docs/select-statements/" + "title": "SELECT", + "url": "/docs/select/" + }, + "SELECT FROM": { + "breadcrumbs": [ + { + "title": "SQL Commands", + "url": "/docs/sql-commands/" + }, + { + "title": "SQL Reference", + "url": "/docs/sql-reference/" + } + ], + "children": [], + "next_title": "SELECT GROUP BY", + "next_url": "/docs/select-group-by/", + "parent": "SQL Commands", + "previous_title": "SELECT", + "previous_url": "/docs/select/", + "relative_path": "_docs/sql-reference/sql-commands/081-select-from.md", + "title": "SELECT FROM", + "url": "/docs/select-from/" + }, + "SELECT GROUP BY": { + "breadcrumbs": [ + { + "title": "SQL Commands", + "url": "/docs/sql-commands/" + }, + { + "title": "SQL Reference", + "url": "/docs/sql-reference/" + } + ], + "children": [], + "next_title": "SELECT HAVING", + "next_url": "/docs/select-having/", + "parent": "SQL Commands", + "previous_title": "SELECT FROM", + "previous_url": "/docs/select-from/", + "relative_path": "_docs/sql-reference/sql-commands/082-select-group-by.md", + "title": "SELECT GROUP BY", + "url": "/docs/select-group-by/" + }, + "SELECT HAVING": { + "breadcrumbs": [ + { + "title": "SQL Commands", + "url": "/docs/sql-commands/" + }, + { + "title": "SQL Reference", + "url": "/docs/sql-reference/" + } + ], + "children": [], + "next_title": "SELECT LIMIT", + "next_url": "/docs/select-limit/", + "parent": "SQL Commands", + "previous_title": "SELECT GROUP BY", + "previous_url": "/docs/select-group-by/", + "relative_path": "_docs/sql-reference/sql-commands/083-select-having.md", + "title": "SELECT HAVING", + "url": "/docs/select-having/" + }, + "SELECT LIMIT": { + "breadcrumbs": [ + { + "title": "SQL Commands", + "url": "/docs/sql-commands/" + }, + { + "title": "SQL Reference", + "url": "/docs/sql-reference/" + } + ], + "children": [], + "next_title": "SELECT OFFSET", + "next_url": "/docs/select-offset/", + "parent": "SQL Commands", + "previous_title": "SELECT HAVING", + "previous_url": "/docs/select-having/", + "relative_path": "_docs/sql-reference/sql-commands/084-select-limit.md", + "title": "SELECT LIMIT", + "url": "/docs/select-limit/" + }, + "SELECT OFFSET": { + "breadcrumbs": [ + { + "title": "SQL Commands", + "url": "/docs/sql-commands/" + }, + { + "title": "SQL Reference", + "url": "/docs/sql-reference/" + } + ], + "children": [], + "next_title": "SELECT ORDER BY", + "next_url": "/docs/select-order-by/", + "parent": "SQL Commands", + "previous_title": "SELECT LIMIT", + "previous_url": "/docs/select-limit/", + "relative_path": "_docs/sql-reference/sql-commands/085-select-offset.md", + "title": "SELECT OFFSET", + "url": "/docs/select-offset/" + }, + "SELECT ORDER BY": { + "breadcrumbs": [ + { + "title": "SQL Commands", + "url": "/docs/sql-commands/" + }, + { + "title": "SQL Reference", + "url": "/docs/sql-reference/" + } + ], + "children": [], + "next_title": "SELECT UNION", + "next_url": "/docs/select-union/", + "parent": "SQL Commands", + "previous_title": "SELECT OFFSET", + "previous_url": "/docs/select-offset/", + "relative_path": "_docs/sql-reference/sql-commands/086-select-order-by.md", + "title": "SELECT ORDER BY", + "url": "/docs/select-order-by/" + }, + "SELECT UNION": { + "breadcrumbs": [ + { + "title": "SQL Commands", + "url": "/docs/sql-commands/" + }, + { + "title": "SQL Reference", + "url": "/docs/sql-reference/" + } + ], + "children": [], + "next_title": "SELECT WHERE", + "next_url": "/docs/select-where/", + "parent": "SQL Commands", + "previous_title": "SELECT ORDER BY", + "previous_url": "/docs/select-order-by/", + "relative_path": "_docs/sql-reference/sql-commands/087-select-union.md", + "title": "SELECT UNION", + "url": "/docs/select-union/" + }, + "SELECT WHERE": { + "breadcrumbs": [ + { + "title": "SQL Commands", + "url": "/docs/sql-commands/" + }, + { + "title": "SQL Reference", + "url": "/docs/sql-reference/" + } + ], + "children": [], + "next_title": "SELECT WITH", + "next_url": "/docs/select-with/", + "parent": "SQL Commands", + "previous_title": "SELECT UNION", + "previous_url": "/docs/select-union/", + "relative_path": "_docs/sql-reference/sql-commands/088-select-where.md", + "title": "SELECT WHERE", + "url": "/docs/select-where/" + }, + "SELECT WITH": { + "breadcrumbs": [ + { + "title": "SQL Commands", + "url": "/docs/sql-commands/" + }, + { + "title": "SQL Reference", + "url": "/docs/sql-reference/" + } + ], + "children": [], + "next_title": "SHOW DATABASES and SHOW SCHEMAS", + "next_url": "/docs/show-databases-and-show-schemas/", + "parent": "SQL Commands", + "previous_title": "SELECT WHERE", + "previous_url": "/docs/select-where/", + "relative_path": "_docs/sql-reference/sql-commands/089-select-with.md", + "title": "SELECT WITH", + "url": "/docs/select-with/" }, - "SHOW DATABASES and SHOW SCHEMAS Command": { + "SHOW DATABASES and SHOW SCHEMAS": { "breadcrumbs": [ { "title": "SQL Commands", @@ -6036,16 +6246,16 @@ } ], "children": [], - "next_title": "SHOW FILES Command", - "next_url": "/docs/show-files-command/", + "next_title": "SHOW FILES", + "next_url": "/docs/show-files/", "parent": "SQL Commands", - "previous_title": "SELECT Statements", - "previous_url": "/docs/select-statements/", + "previous_title": "SELECT WITH", + "previous_url": "/docs/select-with/", "relative_path": "_docs/sql-reference/sql-commands/090-show-databases-and-show-schemas.md", - "title": "SHOW DATABASES and SHOW SCHEMAS Command", - "url": "/docs/show-databases-and-show-schemas-command/" + "title": "SHOW DATABASES and SHOW SCHEMAS", + "url": "/docs/show-databases-and-show-schemas/" }, - "SHOW FILES Command": { + "SHOW FILES": { "breadcrumbs": [ { "title": "SQL Commands", @@ -6057,16 +6267,16 @@ } ], "children": [], - "next_title": "SHOW TABLES Command", - "next_url": "/docs/show-tables-command/", + "next_title": "SHOW TABLES", + "next_url": "/docs/show-tables/", "parent": "SQL Commands", - "previous_title": "SHOW DATABASES and SHOW SCHEMAS Command", - "previous_url": "/docs/show-databases-and-show-schemas-command/", + "previous_title": "SHOW DATABASES and SHOW SCHEMAS", + "previous_url": "/docs/show-databases-and-show-schemas/", "relative_path": "_docs/sql-reference/sql-commands/100-show-files.md", - "title": "SHOW FILES Command", - "url": "/docs/show-files-command/" + "title": "SHOW FILES", + "url": "/docs/show-files/" }, - "SHOW TABLES Command": { + "SHOW TABLES": { "breadcrumbs": [ { "title": "SQL Commands", @@ -6078,14 +6288,14 @@ } ], "children": [], - "next_title": "USE Command", - "next_url": "/docs/use-command/", + "next_title": "USE", + "next_url": "/docs/use/", "parent": "SQL Commands", - "previous_title": "SHOW FILES Command", - "previous_url": "/docs/show-files-command/", - "relative_path": "_docs/sql-reference/sql-commands/110-show-tables-command.md", - "title": "SHOW TABLES Command", - "url": "/docs/show-tables-command/" + "previous_title": "SHOW FILES", + "previous_url": "/docs/show-files/", + "relative_path": "_docs/sql-reference/sql-commands/110-show-tables.md", + "title": "SHOW TABLES", + "url": "/docs/show-tables/" }, "SQL Commands": { "breadcrumbs": [ @@ -6107,8 +6317,8 @@ } ], "children": [], - "next_title": "ALTER SESSION Command", - "next_url": "/docs/alter-session-command/", + "next_title": "ALTER SESSION", + "next_url": "/docs/alter-session/", "parent": "SQL Commands", "previous_title": "SQL Commands", "previous_url": "/docs/sql-commands/", @@ -6128,14 +6338,14 @@ } ], "children": [], - "next_title": "ALTER SYSTEM Command", - "next_url": "/docs/alter-system-command/", + "next_title": "ALTER SYSTEM", + "next_url": "/docs/alter-system/", "parent": "SQL Commands", "previous_title": "Supported SQL Commands", "previous_url": "/docs/supported-sql-commands/", - "relative_path": "_docs/sql-reference/sql-commands/010-alter-session-command.md", - "title": "ALTER SESSION Command", - "url": "/docs/alter-session-command/" + "relative_path": "_docs/sql-reference/sql-commands/010-alter-session.md", + "title": "ALTER SESSION", + "url": "/docs/alter-session/" }, { "breadcrumbs": [ @@ -6149,14 +6359,14 @@ } ], "children": [], - "next_title": "CREATE TABLE AS (CTAS) Command", - "next_url": "/docs/create-table-as-ctas-command/", + "next_title": "CREATE TABLE AS (CTAS)", + "next_url": "/docs/create-table-as-ctas/", "parent": "SQL Commands", - "previous_title": "ALTER SESSION Command", - "previous_url": "/docs/alter-session-command/", + "previous_title": "ALTER SESSION", + "previous_url": "/docs/alter-session/", "relative_path": "_docs/sql-reference/sql-commands/020-alter-system.md", - "title": "ALTER SYSTEM Command", - "url": "/docs/alter-system-command/" + "title": "ALTER SYSTEM", + "url": "/docs/alter-system/" }, { "breadcrumbs": [ @@ -6170,14 +6380,14 @@ } ], "children": [], - "next_title": "CREATE VIEW Command", - "next_url": "/docs/create-view-command/", + "next_title": "CREATE VIEW", + "next_url": "/docs/create-view/", "parent": "SQL Commands", - "previous_title": "ALTER SYSTEM Command", - "previous_url": "/docs/alter-system-command/", - "relative_path": "_docs/sql-reference/sql-commands/030-create-table-as-command.md", - "title": "CREATE TABLE AS (CTAS) Command", - "url": "/docs/create-table-as-ctas-command/" + "previous_title": "ALTER SYSTEM", + "previous_url": "/docs/alter-system/", + "relative_path": "_docs/sql-reference/sql-commands/030-create-table-as.md", + "title": "CREATE TABLE AS (CTAS)", + "url": "/docs/create-table-as-ctas/" }, { "breadcrumbs": [ @@ -6191,14 +6401,14 @@ } ], "children": [], - "next_title": "DESCRIBE Command", - "next_url": "/docs/describe-command/", + "next_title": "DROP VIEW", + "next_url": "/docs/drop-view/", "parent": "SQL Commands", - "previous_title": "CREATE TABLE AS (CTAS) Command", - "previous_url": "/docs/create-table-as-ctas-command/", - "relative_path": "_docs/sql-reference/sql-commands/050-create-view-command.md", - "title": "CREATE VIEW Command", - "url": "/docs/create-view-command/" + "previous_title": "CREATE TABLE AS (CTAS)", + "previous_url": "/docs/create-table-as-ctas/", + "relative_path": "_docs/sql-reference/sql-commands/050-create-view.md", + "title": "CREATE VIEW", + "url": "/docs/create-view/" }, { "breadcrumbs": [ @@ -6212,14 +6422,14 @@ } ], "children": [], - "next_title": "EXPLAIN Commands", - "next_url": "/docs/explain-commands/", + "next_title": "DESCRIBE", + "next_url": "/docs/describe/", "parent": "SQL Commands", - "previous_title": "CREATE VIEW Command", - "previous_url": "/docs/create-view-command/", - "relative_path": "_docs/sql-reference/sql-commands/060-describe-command.md", - "title": "DESCRIBE Command", - "url": "/docs/describe-command/" + "previous_title": "CREATE VIEW", + "previous_url": "/docs/create-view/", + "relative_path": "_docs/sql-reference/sql-commands/055-drop-view.md", + "title": "DROP VIEW", + "url": "/docs/drop-view/" }, { "breadcrumbs": [ @@ -6233,14 +6443,14 @@ } ], "children": [], - "next_title": "SELECT Statements", - "next_url": "/docs/select-statements/", + "next_title": "EXPLAIN", + "next_url": "/docs/explain/", "parent": "SQL Commands", - "previous_title": "DESCRIBE Command", - "previous_url": "/docs/describe-command/", - "relative_path": "_docs/sql-reference/sql-commands/070-explain-commands.md", - "title": "EXPLAIN Commands", - "url": "/docs/explain-commands/" + "previous_title": "DROP VIEW", + "previous_url": "/docs/drop-view/", + "relative_path": "_docs/sql-reference/sql-commands/060-describe.md", + "title": "DESCRIBE", + "url": "/docs/describe/" }, { "breadcrumbs": [ @@ -6254,14 +6464,14 @@ } ], "children": [], - "next_title": "SHOW DATABASES and SHOW SCHEMAS Command", - "next_url": "/docs/show-databases-and-show-schemas-command/", + "next_title": "SELECT", + "next_url": "/docs/select/", "parent": "SQL Commands", - "previous_title": "EXPLAIN Commands", - "previous_url": "/docs/explain-commands/", - "relative_path": "_docs/sql-reference/sql-commands/080-select.md", - "title": "SELECT Statements", - "url": "/docs/select-statements/" + "previous_title": "DESCRIBE", + "previous_url": "/docs/describe/", + "relative_path": "_docs/sql-reference/sql-commands/070-explain.md", + "title": "EXPLAIN", + "url": "/docs/explain/" }, { "breadcrumbs": [ @@ -6275,14 +6485,14 @@ } ], "children": [], - "next_title": "SHOW FILES Command", - "next_url": "/docs/show-files-command/", + "next_title": "SELECT FROM", + "next_url": "/docs/select-from/", "parent": "SQL Commands", - "previous_title": "SELECT Statements", - "previous_url": "/docs/select-statements/", - "relative_path": "_docs/sql-reference/sql-commands/090-show-databases-and-show-schemas.md", - "title": "SHOW DATABASES and SHOW SCHEMAS Command", - "url": "/docs/show-databases-and-show-schemas-command/" + "previous_title": "EXPLAIN", + "previous_url": "/docs/explain/", + "relative_path": "_docs/sql-reference/sql-commands/080-select.md", + "title": "SELECT", + "url": "/docs/select/" }, { "breadcrumbs": [ @@ -6296,14 +6506,14 @@ } ], "children": [], - "next_title": "SHOW TABLES Command", - "next_url": "/docs/show-tables-command/", + "next_title": "SELECT GROUP BY", + "next_url": "/docs/select-group-by/", "parent": "SQL Commands", - "previous_title": "SHOW DATABASES and SHOW SCHEMAS Command", - "previous_url": "/docs/show-databases-and-show-schemas-command/", - "relative_path": "_docs/sql-reference/sql-commands/100-show-files.md", - "title": "SHOW FILES Command", - "url": "/docs/show-files-command/" + "previous_title": "SELECT", + "previous_url": "/docs/select/", + "relative_path": "_docs/sql-reference/sql-commands/081-select-from.md", + "title": "SELECT FROM", + "url": "/docs/select-from/" }, { "breadcrumbs": [ @@ -6317,14 +6527,14 @@ } ], "children": [], - "next_title": "USE Command", - "next_url": "/docs/use-command/", + "next_title": "SELECT HAVING", + "next_url": "/docs/select-having/", "parent": "SQL Commands", - "previous_title": "SHOW FILES Command", - "previous_url": "/docs/show-files-command/", - "relative_path": "_docs/sql-reference/sql-commands/110-show-tables-command.md", - "title": "SHOW TABLES Command", - "url": "/docs/show-tables-command/" + "previous_title": "SELECT FROM", + "previous_url": "/docs/select-from/", + "relative_path": "_docs/sql-reference/sql-commands/082-select-group-by.md", + "title": "SELECT GROUP BY", + "url": "/docs/select-group-by/" }, { "breadcrumbs": [ @@ -6338,38 +6548,20 @@ } ], "children": [], - "next_title": "SQL Conditional Expressions", - "next_url": "/docs/sql-conditional-expressions/", + "next_title": "SELECT LIMIT", + "next_url": "/docs/select-limit/", "parent": "SQL Commands", - "previous_title": "SHOW TABLES Command", - "previous_url": "/docs/show-tables-command/", - "relative_path": "_docs/sql-reference/sql-commands/120-use-command.md", - "title": "USE Command", - "url": "/docs/use-command/" - } - ], - "next_title": "Supported SQL Commands", - "next_url": "/docs/supported-sql-commands/", - "parent": "SQL Reference", - "previous_title": "Query Directory Functions", - "previous_url": "/docs/query-directory-functions/", - "relative_path": "_docs/sql-reference/070-sql-commands-summary.md", - "title": "SQL Commands", - "url": "/docs/sql-commands/" - }, - "SQL Conditional Expressions": { - "breadcrumbs": [ - { - "title": "SQL Reference", - "url": "/docs/sql-reference/" - } - ], - "children": [ + "previous_title": "SELECT GROUP BY", + "previous_url": "/docs/select-group-by/", + "relative_path": "_docs/sql-reference/sql-commands/083-select-having.md", + "title": "SELECT HAVING", + "url": "/docs/select-having/" + }, { "breadcrumbs": [ { - "title": "SQL Conditional Expressions", - "url": "/docs/sql-conditional-expressions/" + "title": "SQL Commands", + "url": "/docs/sql-commands/" }, { "title": "SQL Reference", @@ -6377,55 +6569,20 @@ } ], "children": [], - "next_title": "Reserved Keywords", - "next_url": "/docs/reserved-keywords/", - "parent": "SQL Conditional Expressions", - "previous_title": "SQL Conditional Expressions", - "previous_url": "/docs/sql-conditional-expressions/", - "relative_path": "_docs/sql-reference/sql-conditional-expressions/010-case-expression.md", - "title": "CASE", - "url": "/docs/case/" - } - ], - "next_title": "CASE", - "next_url": "/docs/case/", - "parent": "SQL Reference", - "previous_title": "USE Command", - "previous_url": "/docs/use-command/", - "relative_path": "_docs/sql-reference/075-sql-conditional-expressions.md", - "title": "SQL Conditional Expressions", - "url": "/docs/sql-conditional-expressions/" - }, - "SQL Extensions": { - "breadcrumbs": [ - { - "title": "SQL Reference", - "url": "/docs/sql-reference/" - } - ], - "children": [], - "next_title": "Data Sources and File Formats", - "next_url": "/docs/data-sources-and-file-formats/", - "parent": "SQL Reference", - "previous_title": "Reserved Keywords", - "previous_url": "/docs/reserved-keywords/", - "relative_path": "_docs/sql-reference/090-sql-extensions.md", - "title": "SQL Extensions", - "url": "/docs/sql-extensions/" - }, - "SQL Functions": { - "breadcrumbs": [ - { - "title": "SQL Reference", - "url": "/docs/sql-reference/" - } - ], - "children": [ + "next_title": "SELECT OFFSET", + "next_url": "/docs/select-offset/", + "parent": "SQL Commands", + "previous_title": "SELECT HAVING", + "previous_url": "/docs/select-having/", + "relative_path": "_docs/sql-reference/sql-commands/084-select-limit.md", + "title": "SELECT LIMIT", + "url": "/docs/select-limit/" + }, { "breadcrumbs": [ { - "title": "SQL Functions", - "url": "/docs/sql-functions/" + "title": "SQL Commands", + "url": "/docs/sql-commands/" }, { "title": "SQL Reference", @@ -6433,20 +6590,20 @@ } ], "children": [], - "next_title": "Math and Trig", - "next_url": "/docs/math-and-trig/", - "parent": "SQL Functions", - "previous_title": "SQL Functions", - "previous_url": "/docs/sql-functions/", - "relative_path": "_docs/sql-reference/sql-functions/005-about-sql-function-examples.md", - "title": "About SQL Function Examples", - "url": "/docs/about-sql-function-examples/" + "next_title": "SELECT ORDER BY", + "next_url": "/docs/select-order-by/", + "parent": "SQL Commands", + "previous_title": "SELECT LIMIT", + "previous_url": "/docs/select-limit/", + "relative_path": "_docs/sql-reference/sql-commands/085-select-offset.md", + "title": "SELECT OFFSET", + "url": "/docs/select-offset/" }, { "breadcrumbs": [ { - "title": "SQL Functions", - "url": "/docs/sql-functions/" + "title": "SQL Commands", + "url": "/docs/sql-commands/" }, { "title": "SQL Reference", @@ -6454,20 +6611,20 @@ } ], "children": [], - "next_title": "Data Type Conversion", - "next_url": "/docs/data-type-conversion/", - "parent": "SQL Functions", - "previous_title": "About SQL Function Examples", - "previous_url": "/docs/about-sql-function-examples/", - "relative_path": "_docs/sql-reference/sql-functions/010-math-and-trig.md", - "title": "Math and Trig", - "url": "/docs/math-and-trig/" + "next_title": "SELECT UNION", + "next_url": "/docs/select-union/", + "parent": "SQL Commands", + "previous_title": "SELECT OFFSET", + "previous_url": "/docs/select-offset/", + "relative_path": "_docs/sql-reference/sql-commands/086-select-order-by.md", + "title": "SELECT ORDER BY", + "url": "/docs/select-order-by/" }, { "breadcrumbs": [ { - "title": "SQL Functions", - "url": "/docs/sql-functions/" + "title": "SQL Commands", + "url": "/docs/sql-commands/" }, { "title": "SQL Reference", @@ -6475,20 +6632,20 @@ } ], "children": [], - "next_title": "Date/Time Functions and Arithmetic", - "next_url": "/docs/date-time-functions-and-arithmetic/", - "parent": "SQL Functions", - "previous_title": "Math and Trig", - "previous_url": "/docs/math-and-trig/", - "relative_path": "_docs/sql-reference/sql-functions/020-data-type-conversion.md", - "title": "Data Type Conversion", - "url": "/docs/data-type-conversion/" + "next_title": "SELECT WHERE", + "next_url": "/docs/select-where/", + "parent": "SQL Commands", + "previous_title": "SELECT ORDER BY", + "previous_url": "/docs/select-order-by/", + "relative_path": "_docs/sql-reference/sql-commands/087-select-union.md", + "title": "SELECT UNION", + "url": "/docs/select-union/" }, { "breadcrumbs": [ { - "title": "SQL Functions", - "url": "/docs/sql-functions/" + "title": "SQL Commands", + "url": "/docs/sql-commands/" }, { "title": "SQL Reference", @@ -6496,14 +6653,277 @@ } ], "children": [], - "next_title": "String Manipulation", - "next_url": "/docs/string-manipulation/", - "parent": "SQL Functions", - "previous_title": "Data Type Conversion", - "previous_url": "/docs/data-type-conversion/", - "relative_path": "_docs/sql-reference/sql-functions/030-date-time-functions-and-arithmetic.md", - "title": "Date/Time Functions and Arithmetic", - "url": "/docs/date-time-functions-and-arithmetic/" + "next_title": "SELECT WITH", + "next_url": "/docs/select-with/", + "parent": "SQL Commands", + "previous_title": "SELECT UNION", + "previous_url": "/docs/select-union/", + "relative_path": "_docs/sql-reference/sql-commands/088-select-where.md", + "title": "SELECT WHERE", + "url": "/docs/select-where/" + }, + { + "breadcrumbs": [ + { + "title": "SQL Commands", + "url": "/docs/sql-commands/" + }, + { + "title": "SQL Reference", + "url": "/docs/sql-reference/" + } + ], + "children": [], + "next_title": "SHOW DATABASES and SHOW SCHEMAS", + "next_url": "/docs/show-databases-and-show-schemas/", + "parent": "SQL Commands", + "previous_title": "SELECT WHERE", + "previous_url": "/docs/select-where/", + "relative_path": "_docs/sql-reference/sql-commands/089-select-with.md", + "title": "SELECT WITH", + "url": "/docs/select-with/" + }, + { + "breadcrumbs": [ + { + "title": "SQL Commands", + "url": "/docs/sql-commands/" + }, + { + "title": "SQL Reference", + "url": "/docs/sql-reference/" + } + ], + "children": [], + "next_title": "SHOW FILES", + "next_url": "/docs/show-files/", + "parent": "SQL Commands", + "previous_title": "SELECT WITH", + "previous_url": "/docs/select-with/", + "relative_path": "_docs/sql-reference/sql-commands/090-show-databases-and-show-schemas.md", + "title": "SHOW DATABASES and SHOW SCHEMAS", + "url": "/docs/show-databases-and-show-schemas/" + }, + { + "breadcrumbs": [ + { + "title": "SQL Commands", + "url": "/docs/sql-commands/" + }, + { + "title": "SQL Reference", + "url": "/docs/sql-reference/" + } + ], + "children": [], + "next_title": "SHOW TABLES", + "next_url": "/docs/show-tables/", + "parent": "SQL Commands", + "previous_title": "SHOW DATABASES and SHOW SCHEMAS", + "previous_url": "/docs/show-databases-and-show-schemas/", + "relative_path": "_docs/sql-reference/sql-commands/100-show-files.md", + "title": "SHOW FILES", + "url": "/docs/show-files/" + }, + { + "breadcrumbs": [ + { + "title": "SQL Commands", + "url": "/docs/sql-commands/" + }, + { + "title": "SQL Reference", + "url": "/docs/sql-reference/" + } + ], + "children": [], + "next_title": "USE", + "next_url": "/docs/use/", + "parent": "SQL Commands", + "previous_title": "SHOW FILES", + "previous_url": "/docs/show-files/", + "relative_path": "_docs/sql-reference/sql-commands/110-show-tables.md", + "title": "SHOW TABLES", + "url": "/docs/show-tables/" + }, + { + "breadcrumbs": [ + { + "title": "SQL Commands", + "url": "/docs/sql-commands/" + }, + { + "title": "SQL Reference", + "url": "/docs/sql-reference/" + } + ], + "children": [], + "next_title": "SQL Conditional Expressions", + "next_url": "/docs/sql-conditional-expressions/", + "parent": "SQL Commands", + "previous_title": "SHOW TABLES", + "previous_url": "/docs/show-tables/", + "relative_path": "_docs/sql-reference/sql-commands/120-use.md", + "title": "USE", + "url": "/docs/use/" + } + ], + "next_title": "Supported SQL Commands", + "next_url": "/docs/supported-sql-commands/", + "parent": "SQL Reference", + "previous_title": "Query Directory Functions", + "previous_url": "/docs/query-directory-functions/", + "relative_path": "_docs/sql-reference/070-sql-commands-summary.md", + "title": "SQL Commands", + "url": "/docs/sql-commands/" + }, + "SQL Conditional Expressions": { + "breadcrumbs": [ + { + "title": "SQL Reference", + "url": "/docs/sql-reference/" + } + ], + "children": [ + { + "breadcrumbs": [ + { + "title": "SQL Conditional Expressions", + "url": "/docs/sql-conditional-expressions/" + }, + { + "title": "SQL Reference", + "url": "/docs/sql-reference/" + } + ], + "children": [], + "next_title": "Reserved Keywords", + "next_url": "/docs/reserved-keywords/", + "parent": "SQL Conditional Expressions", + "previous_title": "SQL Conditional Expressions", + "previous_url": "/docs/sql-conditional-expressions/", + "relative_path": "_docs/sql-reference/sql-conditional-expressions/010-case-expression.md", + "title": "CASE", + "url": "/docs/case/" + } + ], + "next_title": "CASE", + "next_url": "/docs/case/", + "parent": "SQL Reference", + "previous_title": "USE", + "previous_url": "/docs/use/", + "relative_path": "_docs/sql-reference/075-sql-conditional-expressions.md", + "title": "SQL Conditional Expressions", + "url": "/docs/sql-conditional-expressions/" + }, + "SQL Extensions": { + "breadcrumbs": [ + { + "title": "SQL Reference", + "url": "/docs/sql-reference/" + } + ], + "children": [], + "next_title": "Data Sources and File Formats", + "next_url": "/docs/data-sources-and-file-formats/", + "parent": "SQL Reference", + "previous_title": "Reserved Keywords", + "previous_url": "/docs/reserved-keywords/", + "relative_path": "_docs/sql-reference/090-sql-extensions.md", + "title": "SQL Extensions", + "url": "/docs/sql-extensions/" + }, + "SQL Functions": { + "breadcrumbs": [ + { + "title": "SQL Reference", + "url": "/docs/sql-reference/" + } + ], + "children": [ + { + "breadcrumbs": [ + { + "title": "SQL Functions", + "url": "/docs/sql-functions/" + }, + { + "title": "SQL Reference", + "url": "/docs/sql-reference/" + } + ], + "children": [], + "next_title": "Math and Trig", + "next_url": "/docs/math-and-trig/", + "parent": "SQL Functions", + "previous_title": "SQL Functions", + "previous_url": "/docs/sql-functions/", + "relative_path": "_docs/sql-reference/sql-functions/005-about-sql-function-examples.md", + "title": "About SQL Function Examples", + "url": "/docs/about-sql-function-examples/" + }, + { + "breadcrumbs": [ + { + "title": "SQL Functions", + "url": "/docs/sql-functions/" + }, + { + "title": "SQL Reference", + "url": "/docs/sql-reference/" + } + ], + "children": [], + "next_title": "Data Type Conversion", + "next_url": "/docs/data-type-conversion/", + "parent": "SQL Functions", + "previous_title": "About SQL Function Examples", + "previous_url": "/docs/about-sql-function-examples/", + "relative_path": "_docs/sql-reference/sql-functions/010-math-and-trig.md", + "title": "Math and Trig", + "url": "/docs/math-and-trig/" + }, + { + "breadcrumbs": [ + { + "title": "SQL Functions", + "url": "/docs/sql-functions/" + }, + { + "title": "SQL Reference", + "url": "/docs/sql-reference/" + } + ], + "children": [], + "next_title": "Date/Time Functions and Arithmetic", + "next_url": "/docs/date-time-functions-and-arithmetic/", + "parent": "SQL Functions", + "previous_title": "Math and Trig", + "previous_url": "/docs/math-and-trig/", + "relative_path": "_docs/sql-reference/sql-functions/020-data-type-conversion.md", + "title": "Data Type Conversion", + "url": "/docs/data-type-conversion/" + }, + { + "breadcrumbs": [ + { + "title": "SQL Functions", + "url": "/docs/sql-functions/" + }, + { + "title": "SQL Reference", + "url": "/docs/sql-reference/" + } + ], + "children": [], + "next_title": "String Manipulation", + "next_url": "/docs/string-manipulation/", + "parent": "SQL Functions", + "previous_title": "Data Type Conversion", + "previous_url": "/docs/data-type-conversion/", + "relative_path": "_docs/sql-reference/sql-functions/030-date-time-functions-and-arithmetic.md", + "title": "Date/Time Functions and Arithmetic", + "url": "/docs/date-time-functions-and-arithmetic/" }, { "breadcrumbs": [ @@ -7038,8 +7458,8 @@ } ], "children": [], - "next_title": "ALTER SESSION Command", - "next_url": "/docs/alter-session-command/", + "next_title": "ALTER SESSION", + "next_url": "/docs/alter-session/", "parent": "SQL Commands", "previous_title": "SQL Commands", "previous_url": "/docs/sql-commands/", @@ -7059,14 +7479,14 @@ } ], "children": [], - "next_title": "ALTER SYSTEM Command", - "next_url": "/docs/alter-system-command/", + "next_title": "ALTER SYSTEM", + "next_url": "/docs/alter-system/", "parent": "SQL Commands", "previous_title": "Supported SQL Commands", "previous_url": "/docs/supported-sql-commands/", - "relative_path": "_docs/sql-reference/sql-commands/010-alter-session-command.md", - "title": "ALTER SESSION Command", - "url": "/docs/alter-session-command/" + "relative_path": "_docs/sql-reference/sql-commands/010-alter-session.md", + "title": "ALTER SESSION", + "url": "/docs/alter-session/" }, { "breadcrumbs": [ @@ -7080,14 +7500,14 @@ } ], "children": [], - "next_title": "CREATE TABLE AS (CTAS) Command", - "next_url": "/docs/create-table-as-ctas-command/", + "next_title": "CREATE TABLE AS (CTAS)", + "next_url": "/docs/create-table-as-ctas/", "parent": "SQL Commands", - "previous_title": "ALTER SESSION Command", - "previous_url": "/docs/alter-session-command/", + "previous_title": "ALTER SESSION", + "previous_url": "/docs/alter-session/", "relative_path": "_docs/sql-reference/sql-commands/020-alter-system.md", - "title": "ALTER SYSTEM Command", - "url": "/docs/alter-system-command/" + "title": "ALTER SYSTEM", + "url": "/docs/alter-system/" }, { "breadcrumbs": [ @@ -7101,14 +7521,14 @@ } ], "children": [], - "next_title": "CREATE VIEW Command", - "next_url": "/docs/create-view-command/", + "next_title": "CREATE VIEW", + "next_url": "/docs/create-view/", "parent": "SQL Commands", - "previous_title": "ALTER SYSTEM Command", - "previous_url": "/docs/alter-system-command/", - "relative_path": "_docs/sql-reference/sql-commands/030-create-table-as-command.md", - "title": "CREATE TABLE AS (CTAS) Command", - "url": "/docs/create-table-as-ctas-command/" + "previous_title": "ALTER SYSTEM", + "previous_url": "/docs/alter-system/", + "relative_path": "_docs/sql-reference/sql-commands/030-create-table-as.md", + "title": "CREATE TABLE AS (CTAS)", + "url": "/docs/create-table-as-ctas/" }, { "breadcrumbs": [ @@ -7122,14 +7542,14 @@ } ], "children": [], - "next_title": "DESCRIBE Command", - "next_url": "/docs/describe-command/", + "next_title": "DROP VIEW", + "next_url": "/docs/drop-view/", "parent": "SQL Commands", - "previous_title": "CREATE TABLE AS (CTAS) Command", - "previous_url": "/docs/create-table-as-ctas-command/", - "relative_path": "_docs/sql-reference/sql-commands/050-create-view-command.md", - "title": "CREATE VIEW Command", - "url": "/docs/create-view-command/" + "previous_title": "CREATE TABLE AS (CTAS)", + "previous_url": "/docs/create-table-as-ctas/", + "relative_path": "_docs/sql-reference/sql-commands/050-create-view.md", + "title": "CREATE VIEW", + "url": "/docs/create-view/" }, { "breadcrumbs": [ @@ -7143,14 +7563,14 @@ } ], "children": [], - "next_title": "EXPLAIN Commands", - "next_url": "/docs/explain-commands/", + "next_title": "DESCRIBE", + "next_url": "/docs/describe/", "parent": "SQL Commands", - "previous_title": "CREATE VIEW Command", - "previous_url": "/docs/create-view-command/", - "relative_path": "_docs/sql-reference/sql-commands/060-describe-command.md", - "title": "DESCRIBE Command", - "url": "/docs/describe-command/" + "previous_title": "CREATE VIEW", + "previous_url": "/docs/create-view/", + "relative_path": "_docs/sql-reference/sql-commands/055-drop-view.md", + "title": "DROP VIEW", + "url": "/docs/drop-view/" }, { "breadcrumbs": [ @@ -7164,14 +7584,14 @@ } ], "children": [], - "next_title": "SELECT Statements", - "next_url": "/docs/select-statements/", + "next_title": "EXPLAIN", + "next_url": "/docs/explain/", "parent": "SQL Commands", - "previous_title": "DESCRIBE Command", - "previous_url": "/docs/describe-command/", - "relative_path": "_docs/sql-reference/sql-commands/070-explain-commands.md", - "title": "EXPLAIN Commands", - "url": "/docs/explain-commands/" + "previous_title": "DROP VIEW", + "previous_url": "/docs/drop-view/", + "relative_path": "_docs/sql-reference/sql-commands/060-describe.md", + "title": "DESCRIBE", + "url": "/docs/describe/" }, { "breadcrumbs": [ @@ -7185,14 +7605,224 @@ } ], "children": [], - "next_title": "SHOW DATABASES and SHOW SCHEMAS Command", - "next_url": "/docs/show-databases-and-show-schemas-command/", + "next_title": "SELECT", + "next_url": "/docs/select/", "parent": "SQL Commands", - "previous_title": "EXPLAIN Commands", - "previous_url": "/docs/explain-commands/", + "previous_title": "DESCRIBE", + "previous_url": "/docs/describe/", + "relative_path": "_docs/sql-reference/sql-commands/070-explain.md", + "title": "EXPLAIN", + "url": "/docs/explain/" + }, + { + "breadcrumbs": [ + { + "title": "SQL Commands", + "url": "/docs/sql-commands/" + }, + { + "title": "SQL Reference", + "url": "/docs/sql-reference/" + } + ], + "children": [], + "next_title": "SELECT FROM", + "next_url": "/docs/select-from/", + "parent": "SQL Commands", + "previous_title": "EXPLAIN", + "previous_url": "/docs/explain/", "relative_path": "_docs/sql-reference/sql-commands/080-select.md", - "title": "SELECT Statements", - "url": "/docs/select-statements/" + "title": "SELECT", + "url": "/docs/select/" + }, + { + "breadcrumbs": [ + { + "title": "SQL Commands", + "url": "/docs/sql-commands/" + }, + { + "title": "SQL Reference", + "url": "/docs/sql-reference/" + } + ], + "children": [], + "next_title": "SELECT GROUP BY", + "next_url": "/docs/select-group-by/", + "parent": "SQL Commands", + "previous_title": "SELECT", + "previous_url": "/docs/select/", + "relative_path": "_docs/sql-reference/sql-commands/081-select-from.md", + "title": "SELECT FROM", + "url": "/docs/select-from/" + }, + { + "breadcrumbs": [ + { + "title": "SQL Commands", + "url": "/docs/sql-commands/" + }, + { + "title": "SQL Reference", + "url": "/docs/sql-reference/" + } + ], + "children": [], + "next_title": "SELECT HAVING", + "next_url": "/docs/select-having/", + "parent": "SQL Commands", + "previous_title": "SELECT FROM", + "previous_url": "/docs/select-from/", + "relative_path": "_docs/sql-reference/sql-commands/082-select-group-by.md", + "title": "SELECT GROUP BY", + "url": "/docs/select-group-by/" + }, + { + "breadcrumbs": [ + { + "title": "SQL Commands", + "url": "/docs/sql-commands/" + }, + { + "title": "SQL Reference", + "url": "/docs/sql-reference/" + } + ], + "children": [], + "next_title": "SELECT LIMIT", + "next_url": "/docs/select-limit/", + "parent": "SQL Commands", + "previous_title": "SELECT GROUP BY", + "previous_url": "/docs/select-group-by/", + "relative_path": "_docs/sql-reference/sql-commands/083-select-having.md", + "title": "SELECT HAVING", + "url": "/docs/select-having/" + }, + { + "breadcrumbs": [ + { + "title": "SQL Commands", + "url": "/docs/sql-commands/" + }, + { + "title": "SQL Reference", + "url": "/docs/sql-reference/" + } + ], + "children": [], + "next_title": "SELECT OFFSET", + "next_url": "/docs/select-offset/", + "parent": "SQL Commands", + "previous_title": "SELECT HAVING", + "previous_url": "/docs/select-having/", + "relative_path": "_docs/sql-reference/sql-commands/084-select-limit.md", + "title": "SELECT LIMIT", + "url": "/docs/select-limit/" + }, + { + "breadcrumbs": [ + { + "title": "SQL Commands", + "url": "/docs/sql-commands/" + }, + { + "title": "SQL Reference", + "url": "/docs/sql-reference/" + } + ], + "children": [], + "next_title": "SELECT ORDER BY", + "next_url": "/docs/select-order-by/", + "parent": "SQL Commands", + "previous_title": "SELECT LIMIT", + "previous_url": "/docs/select-limit/", + "relative_path": "_docs/sql-reference/sql-commands/085-select-offset.md", + "title": "SELECT OFFSET", + "url": "/docs/select-offset/" + }, + { + "breadcrumbs": [ + { + "title": "SQL Commands", + "url": "/docs/sql-commands/" + }, + { + "title": "SQL Reference", + "url": "/docs/sql-reference/" + } + ], + "children": [], + "next_title": "SELECT UNION", + "next_url": "/docs/select-union/", + "parent": "SQL Commands", + "previous_title": "SELECT OFFSET", + "previous_url": "/docs/select-offset/", + "relative_path": "_docs/sql-reference/sql-commands/086-select-order-by.md", + "title": "SELECT ORDER BY", + "url": "/docs/select-order-by/" + }, + { + "breadcrumbs": [ + { + "title": "SQL Commands", + "url": "/docs/sql-commands/" + }, + { + "title": "SQL Reference", + "url": "/docs/sql-reference/" + } + ], + "children": [], + "next_title": "SELECT WHERE", + "next_url": "/docs/select-where/", + "parent": "SQL Commands", + "previous_title": "SELECT ORDER BY", + "previous_url": "/docs/select-order-by/", + "relative_path": "_docs/sql-reference/sql-commands/087-select-union.md", + "title": "SELECT UNION", + "url": "/docs/select-union/" + }, + { + "breadcrumbs": [ + { + "title": "SQL Commands", + "url": "/docs/sql-commands/" + }, + { + "title": "SQL Reference", + "url": "/docs/sql-reference/" + } + ], + "children": [], + "next_title": "SELECT WITH", + "next_url": "/docs/select-with/", + "parent": "SQL Commands", + "previous_title": "SELECT UNION", + "previous_url": "/docs/select-union/", + "relative_path": "_docs/sql-reference/sql-commands/088-select-where.md", + "title": "SELECT WHERE", + "url": "/docs/select-where/" + }, + { + "breadcrumbs": [ + { + "title": "SQL Commands", + "url": "/docs/sql-commands/" + }, + { + "title": "SQL Reference", + "url": "/docs/sql-reference/" + } + ], + "children": [], + "next_title": "SHOW DATABASES and SHOW SCHEMAS", + "next_url": "/docs/show-databases-and-show-schemas/", + "parent": "SQL Commands", + "previous_title": "SELECT WHERE", + "previous_url": "/docs/select-where/", + "relative_path": "_docs/sql-reference/sql-commands/089-select-with.md", + "title": "SELECT WITH", + "url": "/docs/select-with/" }, { "breadcrumbs": [ @@ -7206,14 +7836,14 @@ } ], "children": [], - "next_title": "SHOW FILES Command", - "next_url": "/docs/show-files-command/", + "next_title": "SHOW FILES", + "next_url": "/docs/show-files/", "parent": "SQL Commands", - "previous_title": "SELECT Statements", - "previous_url": "/docs/select-statements/", + "previous_title": "SELECT WITH", + "previous_url": "/docs/select-with/", "relative_path": "_docs/sql-reference/sql-commands/090-show-databases-and-show-schemas.md", - "title": "SHOW DATABASES and SHOW SCHEMAS Command", - "url": "/docs/show-databases-and-show-schemas-command/" + "title": "SHOW DATABASES and SHOW SCHEMAS", + "url": "/docs/show-databases-and-show-schemas/" }, { "breadcrumbs": [ @@ -7227,14 +7857,14 @@ } ], "children": [], - "next_title": "SHOW TABLES Command", - "next_url": "/docs/show-tables-command/", + "next_title": "SHOW TABLES", + "next_url": "/docs/show-tables/", "parent": "SQL Commands", - "previous_title": "SHOW DATABASES and SHOW SCHEMAS Command", - "previous_url": "/docs/show-databases-and-show-schemas-command/", + "previous_title": "SHOW DATABASES and SHOW SCHEMAS", + "previous_url": "/docs/show-databases-and-show-schemas/", "relative_path": "_docs/sql-reference/sql-commands/100-show-files.md", - "title": "SHOW FILES Command", - "url": "/docs/show-files-command/" + "title": "SHOW FILES", + "url": "/docs/show-files/" }, { "breadcrumbs": [ @@ -7248,14 +7878,14 @@ } ], "children": [], - "next_title": "USE Command", - "next_url": "/docs/use-command/", + "next_title": "USE", + "next_url": "/docs/use/", "parent": "SQL Commands", - "previous_title": "SHOW FILES Command", - "previous_url": "/docs/show-files-command/", - "relative_path": "_docs/sql-reference/sql-commands/110-show-tables-command.md", - "title": "SHOW TABLES Command", - "url": "/docs/show-tables-command/" + "previous_title": "SHOW FILES", + "previous_url": "/docs/show-files/", + "relative_path": "_docs/sql-reference/sql-commands/110-show-tables.md", + "title": "SHOW TABLES", + "url": "/docs/show-tables/" }, { "breadcrumbs": [ @@ -7272,11 +7902,11 @@ "next_title": "SQL Conditional Expressions", "next_url": "/docs/sql-conditional-expressions/", "parent": "SQL Commands", - "previous_title": "SHOW TABLES Command", - "previous_url": "/docs/show-tables-command/", - "relative_path": "_docs/sql-reference/sql-commands/120-use-command.md", - "title": "USE Command", - "url": "/docs/use-command/" + "previous_title": "SHOW TABLES", + "previous_url": "/docs/show-tables/", + "relative_path": "_docs/sql-reference/sql-commands/120-use.md", + "title": "USE", + "url": "/docs/use/" } ], "next_title": "Supported SQL Commands", @@ -7321,8 +7951,8 @@ "next_title": "CASE", "next_url": "/docs/case/", "parent": "SQL Reference", - "previous_title": "USE Command", - "previous_url": "/docs/use-command/", + "previous_title": "USE", + "previous_url": "/docs/use/", "relative_path": "_docs/sql-reference/075-sql-conditional-expressions.md", "title": "SQL Conditional Expressions", "url": "/docs/sql-conditional-expressions/" @@ -7856,8 +8486,8 @@ } ], "children": [], - "next_title": "ALTER SESSION Command", - "next_url": "/docs/alter-session-command/", + "next_title": "ALTER SESSION", + "next_url": "/docs/alter-session/", "parent": "SQL Commands", "previous_title": "SQL Commands", "previous_url": "/docs/sql-commands/", @@ -8187,7 +8817,7 @@ "title": "Tutorials Introduction", "url": "/docs/tutorials-introduction/" }, - "USE Command": { + "USE": { "breadcrumbs": [ { "title": "SQL Commands", @@ -8202,11 +8832,11 @@ "next_title": "SQL Conditional Expressions", "next_url": "/docs/sql-conditional-expressions/", "parent": "SQL Commands", - "previous_title": "SHOW TABLES Command", - "previous_url": "/docs/show-tables-command/", - "relative_path": "_docs/sql-reference/sql-commands/120-use-command.md", - "title": "USE Command", - "url": "/docs/use-command/" + "previous_title": "SHOW TABLES", + "previous_url": "/docs/show-tables/", + "relative_path": "_docs/sql-reference/sql-commands/120-use.md", + "title": "USE", + "url": "/docs/use/" }, "Useful Research": { "breadcrumbs": [ @@ -11272,8 +11902,8 @@ } ], "children": [], - "next_title": "ALTER SESSION Command", - "next_url": "/docs/alter-session-command/", + "next_title": "ALTER SESSION", + "next_url": "/docs/alter-session/", "parent": "SQL Commands", "previous_title": "SQL Commands", "previous_url": "/docs/sql-commands/", @@ -11293,14 +11923,14 @@ } ], "children": [], - "next_title": "ALTER SYSTEM Command", - "next_url": "/docs/alter-system-command/", + "next_title": "ALTER SYSTEM", + "next_url": "/docs/alter-system/", "parent": "SQL Commands", "previous_title": "Supported SQL Commands", "previous_url": "/docs/supported-sql-commands/", - "relative_path": "_docs/sql-reference/sql-commands/010-alter-session-command.md", - "title": "ALTER SESSION Command", - "url": "/docs/alter-session-command/" + "relative_path": "_docs/sql-reference/sql-commands/010-alter-session.md", + "title": "ALTER SESSION", + "url": "/docs/alter-session/" }, { "breadcrumbs": [ @@ -11314,14 +11944,14 @@ } ], "children": [], - "next_title": "CREATE TABLE AS (CTAS) Command", - "next_url": "/docs/create-table-as-ctas-command/", + "next_title": "CREATE TABLE AS (CTAS)", + "next_url": "/docs/create-table-as-ctas/", "parent": "SQL Commands", - "previous_title": "ALTER SESSION Command", - "previous_url": "/docs/alter-session-command/", + "previous_title": "ALTER SESSION", + "previous_url": "/docs/alter-session/", "relative_path": "_docs/sql-reference/sql-commands/020-alter-system.md", - "title": "ALTER SYSTEM Command", - "url": "/docs/alter-system-command/" + "title": "ALTER SYSTEM", + "url": "/docs/alter-system/" }, { "breadcrumbs": [ @@ -11335,14 +11965,14 @@ } ], "children": [], - "next_title": "CREATE VIEW Command", - "next_url": "/docs/create-view-command/", + "next_title": "CREATE VIEW", + "next_url": "/docs/create-view/", "parent": "SQL Commands", - "previous_title": "ALTER SYSTEM Command", - "previous_url": "/docs/alter-system-command/", - "relative_path": "_docs/sql-reference/sql-commands/030-create-table-as-command.md", - "title": "CREATE TABLE AS (CTAS) Command", - "url": "/docs/create-table-as-ctas-command/" + "previous_title": "ALTER SYSTEM", + "previous_url": "/docs/alter-system/", + "relative_path": "_docs/sql-reference/sql-commands/030-create-table-as.md", + "title": "CREATE TABLE AS (CTAS)", + "url": "/docs/create-table-as-ctas/" }, { "breadcrumbs": [ @@ -11356,14 +11986,14 @@ } ], "children": [], - "next_title": "DESCRIBE Command", - "next_url": "/docs/describe-command/", + "next_title": "DROP VIEW", + "next_url": "/docs/drop-view/", "parent": "SQL Commands", - "previous_title": "CREATE TABLE AS (CTAS) Command", - "previous_url": "/docs/create-table-as-ctas-command/", - "relative_path": "_docs/sql-reference/sql-commands/050-create-view-command.md", - "title": "CREATE VIEW Command", - "url": "/docs/create-view-command/" + "previous_title": "CREATE TABLE AS (CTAS)", + "previous_url": "/docs/create-table-as-ctas/", + "relative_path": "_docs/sql-reference/sql-commands/050-create-view.md", + "title": "CREATE VIEW", + "url": "/docs/create-view/" }, { "breadcrumbs": [ @@ -11377,14 +12007,14 @@ } ], "children": [], - "next_title": "EXPLAIN Commands", - "next_url": "/docs/explain-commands/", + "next_title": "DESCRIBE", + "next_url": "/docs/describe/", "parent": "SQL Commands", - "previous_title": "CREATE VIEW Command", - "previous_url": "/docs/create-view-command/", - "relative_path": "_docs/sql-reference/sql-commands/060-describe-command.md", - "title": "DESCRIBE Command", - "url": "/docs/describe-command/" + "previous_title": "CREATE VIEW", + "previous_url": "/docs/create-view/", + "relative_path": "_docs/sql-reference/sql-commands/055-drop-view.md", + "title": "DROP VIEW", + "url": "/docs/drop-view/" }, { "breadcrumbs": [ @@ -11398,14 +12028,14 @@ } ], "children": [], - "next_title": "SELECT Statements", - "next_url": "/docs/select-statements/", + "next_title": "EXPLAIN", + "next_url": "/docs/explain/", "parent": "SQL Commands", - "previous_title": "DESCRIBE Command", - "previous_url": "/docs/describe-command/", - "relative_path": "_docs/sql-reference/sql-commands/070-explain-commands.md", - "title": "EXPLAIN Commands", - "url": "/