parquetize (version 0.5.8)

get_partitions: get unique values from table's column

Description

This function allows you to extract unique values from a table's column to use as partitions.

Internally, this function does "SELECT DISTINCT(mycolumn) FROM mytable;"

Usage

get_partitions(conn, table, column)

Value

a vector with unique values for the column of the table

Arguments

conn

A DBIConnection object, as return by DBI::dbConnect

table

a DB table name

column

a column name for the table passed in param

Examples

dbi_connection <- DBI::dbConnect(RSQLite::SQLite(),
  system.file("extdata","iris.sqlite",package = "parquetize"))

get_partitions(dbi_connection, "iris", "Species")