marcothesane
Administrator
marcothesane Administrator
Reactions
-
Re: Expert advice on slow running query
I agree with @VValdar - the OVER() can be costly. Try this workaround: Add this WITH clause at the beginning of the query: WITHmaxb AS ( SELECT max(throughput_in_bit_per_s) AS b_max_throughput_in_bit… (View Post)1 -
Re: ERROR: Too many ROS containers exist for the following projections
Hi MrBudy01 Yes, you can perform multi-row value insert as in specified in DBeaver. If you perform a multi-row value insert into a table mystuff, DBeaver will create a statement: INSERT INTO mystuff … (View Post)1 -
Re: SQL Reserved Words
Not quite. Trying to create a table with those column names - I do get an error in the first wrong column name: 152 -- out ERROR 4856: Syntax error at or near "ALL" at character 24153 -- ou… (View Post)1 -
Re: Can Vertica database be migrated to any cloud database like Postgresql?
If you already have a Vertica Database on prem; and if you want the same node count - and the same Vertica version - in the Cloud, all you do is backup the on-prem database; In the case of Azure, GCP… (View Post)1 -
Re: Equivalent of LISTAGG that returns an ARRAY rather than delimited string?
This is how IMPLODE() works: WITH car_sales(manufact,"type") AS ( SELECT 'Morgan','Plus 6' UNION ALL SELECT 'Morgan','Plus 4' UNION ALL SELECT 'Morgan','Threewheeler' UNION ALL SELECT 'Morg… (View Post)1