EXPORT_STATISTICS_PARTITION

Generates partition-level statistics in XML format from data previously collected by ANALYZE_STATISTICS_PARTITION.

Syntax

EXPORT_STATISTICS_PARTITION ('[ filename ]', '[[database.]schema.]table', 'min‑range‑value','max‑range‑value' [, 'column[,…]' )

filename	Specifies where to write the generated XML. If filename already exists, `EXPORT_STATISTICS_PARTITION` overwrites it. If you supply an empty string, the function writes to standard output.
[database.]schema	Specifies a schema, by default `public`. If schema is any schema other than `public`, you must supply the schema name. For example: myschema.thisDbObject If you specify a database, it must be the current database.
table	The table on which to export data.
min‑range‑value max‑range‑value	The minimum and maximum value of partition keys on which to export statistics, where min‑range‑value must be ≤ max‑range‑value. The range of keys to export must be equal to, or a superset of, the full range of partitions previously analyzed by `ANALYZE_STATISTICS_PARTITION`. If the range omits any analyzed partition, `EXPORT_STATISTICS_PARTITION` exports no statistics.
column	The name of a column in table, typically a predicate column. You can specify multiple comma-delimited columns. Vertica narrows the scope of exported statistics to the specified columns only.

Superuser

EXPORT_STATISTICS_PARTITION does not export statistics for LONG data type columns.