intersect.tbl_lazy

union.tbl_lazy

union_all.tbl_lazy

setdiff.tbl_lazy

These are methods for the dplyr generics <code><a href="https://generics.r-lib.org/reference/setops.html">dplyr::intersect()</a></code>,
<code><a href="https://generics.r-lib.org/reference/setops.html">dplyr::union()</a></code>, and <code><a href="https://generics.r-lib.org/reference/setops.html">dplyr::setdiff()</a></code>. They are translated to
<code>INTERSECT</code>, <code>UNION</code>, and <code>EXCEPT</code> respectively.

A 'dplyr' back end for databases that allows you to work with
remote database tables as if they are in-memory data frames.  Basic
features works with any database that has a 'DBI' back end; more
advanced features require 'SQL' translation to be provided by the
package author.

Hadley Wickham

dbplyr

A 'dplyr' Back End for Databases

Maximilian Girlich

Edgar Ruiz

Posit Software, PBC 

intersect.tbl_lazy function

<dl><dt>x, y</dt>
<dd>A pair of lazy data frames backed by database queries.</dd>
<dt>copy</dt>
<dd>If <code>x</code> and <code>y</code> are not from the same data source,
and <code>copy</code> is <code>TRUE</code>, then <code>y</code> will be copied into a
temporary table in same database as <code>x</code>. <code>*_join()</code> will automatically
run <code>ANALYZE</code> on the created table in the hope that this will make
you queries as efficient as possible by giving more data to the query
planner.
This allows you to join tables across srcs, but it's potentially expensive
operation so you must opt into it.</dd>
<dt>...</dt>
<dd>Not currently used; provided for future extensions.</dd>
<dt>all</dt>
<dd>If <code>TRUE</code>, includes all matches in output, not just unique rows.</dd></dl>

Arguments

These are methods for the dplyr generics <code><a href='https://generics.r-lib.org/reference/setops.html'>dplyr::intersect()</a></code>,
<code><a href='https://generics.r-lib.org/reference/setops.html'>dplyr::union()</a></code>, and <code><a href='https://generics.r-lib.org/reference/setops.html'>dplyr::setdiff()</a></code>. They are translated to
<code>INTERSECT</code>, <code>UNION</code>, and <code>EXCEPT</code> respectively.

SQL set operations — intersect.tbl_lazy

<dl>

<dt>x, y</dt>
<dd>A pair of lazy data frames backed by database queries.</dd>


<dt>copy</dt>
<dd>If <code>x</code> and <code>y</code> are not from the same data source,
and <code>copy</code> is <code>TRUE</code>, then <code>y</code> will be copied into a
temporary table in same database as <code>x</code>. <code>*_join()</code> will automatically
run <code>ANALYZE</code> on the created table in the hope that this will make
you queries as efficient as possible by giving more data to the query
planner.
This allows you to join tables across srcs, but it's potentially expensive
operation so you must opt into it.</dd>


<dt>...</dt>
<dd>Not currently used; provided for future extensions.</dd>


<dt>all</dt>
<dd>If <code>TRUE</code>, includes all matches in output, not just unique rows.</dd>

</dl>

intersect.tbl_lazy: SQL set operations

Description

Usage

Arguments