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)