marcothesane
Administrator
marcothesane Administrator
Reactions
-
Re: COPY's usage with complex types - ARRAY
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)1 -
Re: Getting an error in Visual Studios while extracting the tables from Vertica
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)1 -
Re: Can I add a partition group to a partitioned table ?
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_scd.spplr_id, suppli… (View Post)1 -
Re: Backfilling data and partitions - looking for best practice/advice
Assume that the table is hierarchically partitioned by day for the last 3 months, month for the past year, and year from then onwards, and the table is sales.f_sales. Assume that the new records are … (View Post)1 -
Re: declare a variable inside a function
Why would you need to do that? I know three - all pretty intuitive - ways to add minutes to timestamps. * knowing that a minute is 1/1440 of a day, add n times 1/1440 to an input timestamp * use the … (View Post)1