sql_query_save.PrestoConnection

Implements a 'DBI' compliant interface to Presto. Presto is
an open source distributed SQL query engine for running interactive
analytic queries against data sources of all sizes ranging from
gigabytes to petabytes: <https://prestodb.io/>.

Jarod G.R. Meng

RPresto

DBI Connector to Presto

Onur Ismail Filiz

Sergey Goder

Thomas J. Leeper

John Myles White

sql_query_save.PrestoConnection function

<dl><dt>con</dt>
<dd>A database connection.</dd>
<dt>sql</dt>
<dd>a character string containing SQL statement.</dd>
<dt>name</dt>
<dd>The table name, passed on to <code><a href="https://dbi.r-dbi.org/reference/dbQuoteIdentifier.html">DBI::dbQuoteIdentifier()</a></code>. Options are:<ul>
<li>a character string with the unquoted DBMS table name,
e.g. <code>"table_name"</code>,</li>
<li>a call to <code><a href="https://dbi.r-dbi.org/reference/Id.html">DBI::Id()</a></code> with components to the fully qualified table name,
e.g. <code>Id(schema = "my_schema", table = "table_name")</code></li>
<li>a call to <code><a href="https://dbi.r-dbi.org/reference/SQL.html">DBI::SQL()</a></code> with the quoted and fully qualified table name
given verbatim, e.g. <code>SQL('"my_schema"."table_name"')</code></li>
</ul></dd>
<dt>temporary</dt>
<dd>If a temporary table should be created. Default to TRUE in
the <code><a href="https://dbplyr.tidyverse.org/reference/db-sql.html">dbplyr::sql_query_save()</a></code> generic. The default value generates an
error in Presto. Using <code>temporary = FALSE</code> to save the query in a
permanent table.</dd>
<dt>...</dt>
<dd>Other arguments used by individual methods.</dd>
<dt>with</dt>
<dd>An optional WITH clause for the CREATE TABLE statement.</dd></dl>

Arguments

dbplyr SQL methods — sql_query_save.PrestoConnection

<dl>

<dt>con</dt>
<dd>A database connection.</dd>


<dt>sql</dt>
<dd>a character string containing SQL statement.</dd>


<dt>name</dt>
<dd>The table name, passed on to <code><a href='https://dbi.r-dbi.org/reference/dbQuoteIdentifier.html'>DBI::dbQuoteIdentifier()</a></code>. Options are:<ul>
<li>a character string with the unquoted DBMS table name,
e.g. <code>"table_name"</code>,</li>
<li>a call to <code><a href='https://dbi.r-dbi.org/reference/Id.html'>DBI::Id()</a></code> with components to the fully qualified table name,
e.g. <code>Id(schema = "my_schema", table = "table_name")</code></li>
<li>a call to <code><a href='https://dbi.r-dbi.org/reference/SQL.html'>DBI::SQL()</a></code> with the quoted and fully qualified table name
given verbatim, e.g. <code>SQL('"my_schema"."table_name"')</code></li>
</ul></dd>


<dt>temporary</dt>
<dd>If a temporary table should be created. Default to TRUE in
the <code><a href='https://dbplyr.tidyverse.org/reference/db-sql.html'>dbplyr::sql_query_save()</a></code> generic. The default value generates an
error in Presto. Using <code>temporary = FALSE</code> to save the query in a
permanent table.</dd>


<dt>...</dt>
<dd>Other arguments used by individual methods.</dd>


<dt>with</dt>
<dd>An optional WITH clause for the CREATE TABLE statement.</dd>

</dl>

dbplyr SQL methods

sql_query_save.PrestoConnection: dbplyr SQL methods

Description

Usage

Arguments