Vertica Analytics Platform Version 9.2.x Documentation

MATERIALIZE_FLEXTABLE_COLUMNS_RESULTS

Returns the results after you run the flex table function, MATERIALIZE_FLEXTABLE_COLUMNS. The system table includes the following information: 

Column Name Data Type Description
TABLE_ID

INTEGER

Unique numeric ID assigned by the Vertica catalog, which identifies the license.

TABLE_SCHEMA

VARCHAR

The license’s name.

TABLE_NAME

VARCHAR

The Verticaproduct toward which the license is applied.

CREATION_TIME

VARCHAR

The start date for which the license is valid.

KEY_NAME

VARCHAR

The end date until which the license is valid (or "Perpetual" if the license has no expiration).

STATUS

VARCHAR

The function status, which can be one of these values: 

  • ADDED
  • EXISTS
  • ERROR
MESSAGE

BOOLEAN

The message associated with the status in the previous column, one of the following:

  • Added successfully
  • Column of same name already exists in table definition
  • Add operation failed
  • No data type guess provided to add column

Example

=> SELECT table_name, creation_time, key_name, status, message FROM v_catalog.materialize_flextable_columns_results WHERE table_name = 'twitter_r'; table_name | creation_time | key_name | status | message ------------+-------------------------------+-------------------+--------+-------------------------------------------------------- twitter_r | 2013-11-20 17:00:27.945484-05 | contributors | ADDED | Added successfully twitter_r | 2013-11-20 17:00:27.94551-05 | entities.hashtags | ADDED | Added successfully twitter_r | 2013-11-20 17:00:27.945519-05 | entities.urls | ADDED | Added successfully twitter_r | 2013-11-20 17:00:27.945532-05 | created_at | EXISTS | Column of same name already exists in table definition (4 rows)