profile.sql_in File Reference

SQL function for single-pass table profiles. More...

Go to the source code of this file.

Functions
set< profile_result >	profile (text input_table)
	Compute a simple "profile" of a table or view.
set< profile_result >	profile_full (text input_table, integer buckets)
	Compute a full "profile" of a table or view.
anyarray	array_collapse (anyarray input)
	Collapses n-dimensional Arrays to 1-dim Array, so they can be read in pl/python can read it. Otherwise we would get ERROR: cannot convert multidimensional array to Python list.

---

Detailed Description

Date:

January 2011

See also:

For a brief introduction to "profiles", see the module description Profile. Cf. also the module Sketch-based Estimators.

Definition in file profile.sql_in.

---

Function Documentation

anyarray array_collapse

(

anyarray

input

)

Parameters:

input

Mult-dim array

Returns:

One dimensional anyarray

Definition at line 180 of file profile.sql_in.

set<profile_result> profile

(

text

input_table

)

Parameters:

input_table

table name to analyze

Returns:

Set of PROFILE_RESULT type

Definition at line 143 of file profile.sql_in.

set<profile_result> profile_full	(	text	input_table,
		integer	buckets
	)

Parameters:

input_table	table name to analyze
buckets	number of buckets for histogram functions

Returns:

Set of PROFILE_RESULT type

Definition at line 161 of file profile.sql_in.