get_partitions: get unique values from table's column

In parquetize: Convert Files to Parquet Format

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)

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

Value

a vector with unique values for the column of the table

Examples

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

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

parquetize documentation built on May 29, 2024, 8 a.m.