You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@drill.apache.org by cg...@apache.org on 2024/05/01 16:28:16 UTC

(drill-site) branch master updated: Update 005-supported-sql-commands.md

This is an automated email from the ASF dual-hosted git repository.

cgivre pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/drill-site.git


The following commit(s) were added to refs/heads/master by this push:
     new b69819d197 Update 005-supported-sql-commands.md
b69819d197 is described below

commit b69819d197acb87bcdebf25602e0014e3207dde9
Author: Charles S. Givre <cg...@apache.org>
AuthorDate: Wed May 1 12:28:11 2024 -0400

    Update 005-supported-sql-commands.md
    
    Add INSERT to list of supported commands.
---
 _docs/en/sql-reference/sql-commands/005-supported-sql-commands.md | 1 +
 1 file changed, 1 insertion(+)

diff --git a/_docs/en/sql-reference/sql-commands/005-supported-sql-commands.md b/_docs/en/sql-reference/sql-commands/005-supported-sql-commands.md
index 5df941202b..1a10e95c1d 100644
--- a/_docs/en/sql-reference/sql-commands/005-supported-sql-commands.md
+++ b/_docs/en/sql-reference/sql-commands/005-supported-sql-commands.md
@@ -21,6 +21,7 @@ with their descriptions and example syntax:
 | [DROP VIEW]({{site.baseurl}}/docs/drop-view)                                               | Removes a view.                                                                                                                                                                                                                                        | DROP VIEW [workspace.]view_name ;                                                                                                                    [...]
 | [EXPLAIN PLAN FOR]({{site.baseurl}}/docs/explain)                                          | Returns the physical plan for a particular query.                                                                                                                                                                                                      | EXPLAIN PLAN FOR query;                                                                                                                              [...]
 | [EXPLAIN PLAN WITHOUT IMPLEMENTATION FOR]({{site.baseurl}}/docs/explain)                   | Returns the logical plan for a particular query.                                                                                                                                                                                                       | EXPLAIN PLAN WITHOUT IMPLEMENTATION FOR query;                                                                                                       [...]
+| [INSERT INTO]({{site.baseurl}}/docs/insert)                    | Inserts data into a datasource.                                                                                                                                                                                                       | { INSERT | UPSERT } INTO tablePrimary [ '(' column [, column ]* ')' ] query                                                                                                                       [...]
 | [RESET]({{site.baseurl}}/docs/reset)                                                       | Changes a session 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 SESSION] RESET \`option_name`;                                                                                                                [...]
 | [SELECT]({{site.baseurl}}/docs/select)                                                     | Retrieves data from tables and files.                                                                                                                                                                                                                  | [WITH subquery]SELECT column_list FROM table_name[WHERE clause] [GROUP BY clause][HAVING clause][ORDER BY clause];                                   [...]
 | [SET]({{site.baseurl}}/docs/set)                                                           | Changes a system setting for the duration of a session. A session ends when you quit the Drill shell. For a list of Drill options and their descriptions, see [Planning and Execution Options]({{site.baseurl}}/docs/planning-and-execution-options/). | [ALTER SESSION] SET \`option_name` = value;                                                                                                          [...]