getMatchingColumns

character string containing a <a rd-options="" href="/link/regular%20expression?package=toaster&version=0.5.5" data-mini-rdoc="toaster::regular expression">regular expression</a> to be matched in the given table info.

pattern

connection object as returned by <code><a rd-options="" href="/link/odbcConnect?package=toaster&version=0.5.5" data-mini-rdoc="toaster::odbcConnect">odbcConnect</a></code>. Only used in combination with <code>tableName</code>.

channel

Aster table name to use. If missing then <code>tableInfo</code> will be used instead.

tableName

data frame obtained by calling <code><a rd-options="" href="/link/getTableSummary?package=toaster&version=0.5.5" data-mini-rdoc="toaster::getTableSummary">getTableSummary</a></code> or <code><a rd-options="" href="/link/sqlColumns?package=toaster&version=0.5.5" data-mini-rdoc="toaster::sqlColumns">sqlColumns</a></code>.

tableInfo

logical: if TRUE returns column names only, otherwise full rows of <code>tableInfo</code>.

names.only

if TRUE case is ignored during matching, otherwise matching is case sensitive.

ignore.case

logical. if TRUE return columns that do not match.

invert


Selects columns with names matching regular expression pattern.


A consistent set of tools to perform in-database analytics
on Teradata Aster Big Data Discovery Platform. toaster (a.k.a 'to Aster')
embraces simple 2-step approach: compute in Aster - visualize and analyze
in R. Its `compute` functions use combination of parallel SQL, SQL-MR and
SQL-GR executing in Aster database - highly scalable parallel
and distributed analytical platform. Then `create` functions visualize
results with boxplots, scatterplots, histograms, heatmaps, word clouds,
maps, networks, or slope graphs. Advanced options such as faceting, coloring,
labeling, and others are supported with most visualizations.

Gregory Kanevsky

toaster

Big Data in-Database Analytics that Scales with Teradata Aster
Distributed Platform

getMatchingColumns function

character string containing a <a rd-options='' href='regular expression'>regular expression</a> to be matched in the given table info.

connection object as returned by <code><a rd-options='' href='odbcConnect'>odbcConnect</a></code>. Only used in combination with <code>tableName</code>.

data frame obtained by calling <code><a rd-options='' href='getTableSummary'>getTableSummary</a></code> or <code><a rd-options='' href='sqlColumns'>sqlColumns</a></code>.

getMatchingColumns: Filter columns by pattern.

Description

Usage

Arguments

See Also