sqlite_subsetidx: sqlite_subsetidx fetch an subset of index table from sqlite...

Description Usage Arguments Value

Description

sqlite_subsetidx fetch an subset of index table from sqlite db - inner join

Usage

1
2
sqlite_subsetidx(dt, tb, db, id, batch_size = 10000, all.dt = FALSE,
  all.tb = FALSE)

Arguments

dt:

a data.frame/data.table in R with column of key

tb:

a full reference table in sqlite with key value

Value

a data.table with value append to the R data.table id is limit to single index - add capability to id multiple index


gyang274/yg documentation built on May 17, 2019, 9:42 a.m.