marcothesane
Administrator
marcothesane Administrator
Reactions
-
Re: How to find the week days between two dates using Vertica?
Or, with the existing calendar from my preceding answer - just a complex join with the calendar: WITHticket(tkid,tkname,cre_dt,res_dt) AS ( SELECT 1,'3rd ticket', DATE '2023-09-01', DATE '2023-09-04'… (View Post)1 -
Re: How to find the week days between two dates using Vertica?
Then, you need to create a distinct "calendar" between creation and resolution date for each ticket: 1. UNION SELECT ticket id and start date with ticket id and resolution date, to get a li… (View Post)1 -
Re: Data warehouse modelling on Vertica
In general - form follows function. So I'd need to know the nature of the more you're mentioning. Without any additional info, the safest way is to: * model star models rather than snow flake * use V… (View Post)1 -
Re: Prevent specific column value-rows in a Vertica table
I can imagine two ways - both not too effective, but there you are. This CSV file: dbadmin@gessnerm-HP-ZBook-15-G3:~/data$ cat foo.csvid,org,nam1,1,arthur1,2,arthur1,3,ford1,1,trillian1,1,zaphod1,1,s… (View Post)1 -
Re: Does update on a partition lock the whole table ?
Then, yes, I'm afraid. If you're updating a table through two sessions in parallel - never mind the partitions, the lock goes to the whole table. To avoid that, it may become nasty. One swap-staging … (View Post)1