COMPUTE_FLEXTABLE_KEYS_AND_BUILD_VIEW
Combines the functionality of BUILD_FLEXTABLE_VIEW and COMPUTE_FLEXTABLE_KEYS to compute virtual columns (keys) from the VMap data of a flex table and construct a view. Creating a view with this function ignores empty keys. If you do not need to perform both operations together, use one of the single-operation functions instead.
If the length of a key exceeds 65,000, Vertica truncates the key.
Syntax
COMPUTE_FLEXTABLE_KEYS_AND_BUILD_VIEW('
flex_table')
Arguments
flex_table |
The name of a flex table. |
Examples
This example shows how to call the function for the darkdata flex table.
=> SELECT COMPUTE_FLEXTABLE_KEYS_AND_BUILD_VIEW('darkdata'); compute_flextable_keys_and_build_view ----------------------------------------------------------------------- Please see public.darkdata_keys for updated keys The view public.darkdata_view is ready for querying (1 row)