My colleague had an issue in Vertica. He had a set of values in table 1 to be deleted based on the records in a table table2. I didn’t think this would be easy considering VERTICA didn’t support joins when doing deletes unlike MYSQL. But they do have something else. Let me take you through the steps I followed. I created the following table in which I have records
c i i i i i i ` c i c ` F D r n n n n n n ` r n o ` i E W ( ( f ( e s s s s s s ` e s m ` r L H s s r a s a a e e e e e e I a e m I s E E e w a e o w n a e w n t r r r r r r t r i t T R l f h n l m h d n l f h d e t t t t t t a e t t w E E e r e a a d e e a d e r e a l ; a t c o r n n c e r n e c o r n e t i i i i i i s t i s r f e t m e d d e t a e d a e t m e d a a n n n n n n o a n y r a a k k a k b t t t t t t b t n : o k e e e e e k e a e e a k e e e e a l o o o o o o c l o a ` m a a a a a a a a n a a n a a a a a n e r e i ` n k k k k k n k \ k k n k k k k \ p p p p p p e p v ` e . a a a a a . a _ a a _ . a a a a _ e u u u u u u a e u e a s n n n n n d n d n n d n n n n n d a b b b b b b t a b k e \ \ \ \ \ a \ e \ \ e a \ \ \ \ e k l l l l l l e k l i a c _ _ _ _ _ t _ l _ _ l m _ _ _ _ l a i i i i i i d a i n n \ d d d d d e d d d . e d d d d . n c c c c c c n c i _ e e e e e e e e n i e e e e n . . . . . . a \ . t i l l l l l I l l l a d l l l l a ( e e e e e e n _ e i d . . . . N . . . m . . . m s a a a a a a o d a a s s d n d s d e i n s d e e k k k k k k t e k l I e e a a a e a i n a e a i c a a a a a a h l a l N c c t m t c t d m c t d \ n n n n n n e n y \ \ e e e \ e = e \ e = _ r ( \ _ _ = i _ = e i _ = e i v v v v v v s _ a i i e d i e a d i e a d a a a a a a t e d n d d a = d a k d a k l l l l l l a c e d = k e = k a = k a i u u u u u u b \ l e a a e a n e a n n e e e e e e l _ d a n k a n . a n . t s s s s s s e i v i k . a k . n k . n , ( ( ( ( ( ( d a d a d n a d a a d a 1 2 3 1 2 3 u l n a . n a m n a m n , , , , , , s i u s . t n . t e . t e a 1 1 1 1 1 1 i n e o s e a s e i s e i m , , , , , , n t s m e m e d e d e ' ' ' ' ' ' g , ( e c e c ) c ) i 2 2 2 2 2 2 1 t \ i \ \ ; d 0 0 0 0 0 0 t n , h _ d _ _ 1 1 1 1 1 1 h a 1 i i ) i i i 3 3 3 3 3 3 e m , n d d d n - - - - - - e ' g t 0 0 0 0 0 0 r i 2 , 5 5 5 5 5 5 e d 0 l - - - - - - c 1 i d 2 2 2 2 2 2 o i 3 k a 0 0 0 1 1 1 r n - e t ' ' ' ' ' ' d t 0 e ) ) ) ) ) ) s , 5 t ; ; ; ; ; ; - h d o d 2 i a f a 1 s t t ' : e w e ) ) h ; ; i d c a h t e I ) ; h a v e t o d e l e t e r e c o r d s i n t h e e a r l i e r o n e . ` ` ` Then I realized there should be another way and used some documentation of Vertica and also checked out Vertica Forums if something was available.
...