sql.attribute.characteristics: Attribute characteristics

In cezden/rpostgrexplorer: Simplification of analysis in PostgreSQL and Redshift DBs

Description

Returns the query returning:

• row_cnt number of rows returned by query

• distinct_val_cnt number of distinct values of query.colname

• mincnt minimal number of instances for some distinct value of query.colname

• avgcnt average number of instances of distinct values of query.colname

• maxcnt maximal number of instances for some distinct value of query.colname

• sdevcnt standard deviation of the number of distinct value instances query.colname

• null_cnt number of NULL instances of query.colname

Usage

sql.attribute.characteristics(query, query.colname, query.countname,
  query.nullitymarker)

Arguments

query	the query to analyze
query.colname	the attribute name
query.countname	the alias for counting variable (some valid SQL name not among the attributes generated by query)
query.nullitymarker	the alias for counting variable (some valid SQL name not among the attributes generated by query)

cezden/rpostgrexplorer documentation built on May 13, 2019, 3:08 p.m.