The info 'FULL' for the statistics_type means just one of the possible values: 'FULL','ROWCOUNT','NONE'. That also means that 'FULL' statistics can v… (View Post)

It's a hierarchical partitioning scheme. If you drop a recent partition, you can have a from_key equal to a to_key, and just that partition will be dropped. If you drop older partitions, where y… (View Post)

I did not manage without a STRING_TO_ARRAY() function call :smile: DROP TABLE IF EXISTS with_array;-- out DROP TABLECREATE TABLE with_array ( id INT, name VARCHAR(3), accepted_forms ARRAY[VARCHAR(5),… (View Post)

You probably had a SQL statement written for SQL Server not abiding by the ANSI standard. Like: SELECT [firstname],[lastname] FROM [customer] Testing it with the vanilla client to Vertica: marco ~/1/… (View Post)

Do you mean this? Before: SQL>select export_objects('','public.supplier_scd',false)export_objectsCREATE TABLE public.supplier_scd( spplr_key int NOT NULL DEFAULT hash(supplier_… (View Post)