add_op_join

Append a join operation to the tbl_kusto object's ops list

An interface to 'Azure Data Explorer', also known as 'Kusto', a fast, distributed data exploration service from Microsoft: <https://azure.microsoft.com/en-us/products/data-explorer/>. Includes 'DBI' and 'dplyr' interfaces, with the latter modelled after the 'dbplyr' package, whereby queries are translated from R into the native 'KQL' query language and executed lazily. On the admin side, the package extends the object framework provided by 'AzureRMR' to support creation and deletion of databases, and management of database principals. Part of the 'AzureR' family of packages.

Alex Kyllo

AzureKusto

Interface to 'Kusto'/'Azure Data Explorer'

Hong Ooi

dbplyr development team 

Microsoft 

add_op_join function

<dl><dt>type</dt>
<dd>The name of the join type,
one of: inner_join, left_join, right_join, full_join, semi_join, anti_join</dd>
<dt>x</dt>
<dd>The "left" tbl</dd>
<dt>y</dt>
<dd>The "right" tbl</dd>
<dt>by</dt>
<dd>A vector of column names; keys by which tbl x and tbl y will be joined</dd>
<dt>suffix</dt>
<dd>A vector of strings that will be appended to the names of non-join key columns that exist in both tbl x and tbl y to distinguish them by source tbl.</dd>
<dt>.strategy</dt>
<dd>A strategy hint to provide to Kusto.</dd>
<dt>.shufflekeys</dt>
<dd>A character vector of column names to shuffle on, if <code>.strategy = "shuffle"</code>.</dd>
<dt>.num_partitions</dt>
<dd>The number of partitions for a shuffle query.</dd>
<dt>.remote</dt>
<dd>A strategy hint to provide to Kusto for cross-cluster joins.</dd></dl>

Arguments

Append a join operation to the tbl_kusto object's ops list — add_op_join

<dl>

<dt>type</dt>
<dd>The name of the join type,
one of: inner_join, left_join, right_join, full_join, semi_join, anti_join</dd>


<dt>x</dt>
<dd>The "left" tbl</dd>


<dt>y</dt>
<dd>The "right" tbl</dd>


<dt>by</dt>
<dd>A vector of column names; keys by which tbl x and tbl y will be joined</dd>


<dt>suffix</dt>
<dd>A vector of strings that will be appended to the names of non-join key columns that exist in both tbl x and tbl y to distinguish them by source tbl.</dd>


<dt>.strategy</dt>
<dd>A strategy hint to provide to Kusto.</dd>


<dt>.shufflekeys</dt>
<dd>A character vector of column names to shuffle on, if <code>.strategy = "shuffle"</code>.</dd>


<dt>.num_partitions</dt>
<dd>The number of partitions for a shuffle query.</dd>


<dt>.remote</dt>
<dd>A strategy hint to provide to Kusto for cross-cluster joins.</dd>

</dl>

add_op_join: Append a join operation to the tbl_kusto object's ops list

Description

Usage

Arguments