FLTable: Constructor function for FLTable.

In Fuzzy-Logix/AdapteR: Converts R syntax to SQL to provide fast analytics using in-database C++ library DB Lytix.

Description

FLTable constructs an object of class FLTable.

Usage

FLTable(table, obs_id_colname, var_id_colnames = character(0),
  cell_val_colname = character(0), whereconditions = character(0),
  connection = getFLConnection(), type = "double", fetchIDs = TRUE,
  dims = 0, sparse = TRUE, dimnames = NULL, ...)

Arguments

table	name of the table
obs_id_colname	column name set as primary key
cell_val_colname	column name where cell values are stored if FLTable is deep
whereconditions	whereconditions if any to reference the table
connection	ODBC/JDBC connection object
var_id_colname	column name where variable id's are stored if FLTable is deep

Details

FLTable refers to an in-database table. This is equivalent to data.frame object. This object is commonly used as input for data mining functions.

Value

FLTable returns an object of class FLTable mapped to a table in Teradata.

Examples

widetable  <- FLTable("tblAbaloneWide", "ObsID")
deeptable <- FLTable("tblUSArrests","ObsID","VarID","Num_Val")
names(widetable)

Fuzzy-Logix/AdapteR documentation built on May 6, 2019, 5:07 p.m.