get_default_mapping: Get default mapping

In tomasgreif/mondrianr: Create Mondrian schema in R

Description

This function returns data frame with default mapping of data types to schema properties for given data engine.

Usage

get_default_mapping(engine = NA, debug = FALSE)

Arguments

engine	Data engine. See function create_schema for details.
debug	Print additional information useful for debugging.

Details

If successful, dataset with the following columns is returned:

Column	Description
class	Class of data type. Raw data types are aggregated into high-level groups. For example in PostgreSQL, data types smallint, integer, bigint have class integer. This grouping can be used when using argument aggregator in function create_schema.
type	Data type as defined by data engine.
dimension	If TRUE than columns with given data type will be used to create dimensions.
aggregator	Defines default aggregators for given data type. Character string consisting of exactly six digits. If 1 than aggregator is enabled. If 0 then aggregator is disabled. Aggregators are defined in the following order: average, count, distinct-count, maximum, minimum, sum.

Examples for column aggregator:

• 111111 - All aggregators enabled

• 100001 - Only average and sumenabled

• 010000 - Only count enabled

• 000000 - All aggregators disabled - for columns with given data type there will be no measure.

Examples

get_default_mapping('PostgreSQL')
get_default_mapping('R')
get_default_mapping('R', debug=TRUE)

tomasgreif/mondrianr documentation built on May 31, 2019, 5:15 p.m.