sample_sql: Select sample n rows returns a lazy evaluation object

In DyfanJones/connectR: Database backend for DBI, dplyr and dbplyr

Description

sample_sql gets a sample of n rows from lazy evaluation object and returns a lazy evaluation object.

Usage

sample_sql(x = NULL, n = NULL)

Arguments

x:	Lazy evaluation object. Object created from the function 'tbl'.
n:	Number of rows, n defaults to 10.

Value

Returns a lazy evaluation object with n rows from a lazy evaluation object.

Examples

#Sample 20 rows from lazy evaluation object
   tbl(post,sql("SELECT * FROM
                 CALENDAR")) %>%
   group_by(ACCOUNT_YEAR_WEEK,
            SEASON) %>%
   summarise(WEEK_ENDING=max(CAL_DATE)) %>%
   sample_sql(n=20)

DyfanJones/connectR documentation built on May 23, 2019, 10:32 p.m.