Try this: WITHmy_list (my_string) AS ( SELECT '1234567890abc1234567890'UNION ALL SELECT '1234I LOVE VERTICA192021'UNION ALL SELECT 'If knowledge is not put into practice, it does not benefit one.'UNI… (View Post)

Or this: CREATE FUNCTION PUBLIC.FIND_FIRST_ALPHA_POS(X VARCHAR(100)) RETURN INTASBEGIN RETURN STRPOS(X,REGEXP_SUBSTR(X,'[A-Z,a-z]'));END;SELECT FIND_FIRST_ALPHA_POS('5744604SOS032011000');FIND_FIRST_… (View Post)

* Yes, a table with high number of columns, wide VARCHAR(s), text index, many projections... any of these will produce more IO and will probably take longer time to load. * If you are loading a table… (View Post)

When you need to drop the oldest partition consider the following example: CREATE TABLE public.my_table( order_no int, order_date timestamp NOT NULL, shipper varchar(20), ship_date date)PARTITION BY … (View Post)

Everybody are talking about the sudo security vulnerability found yesterday, (CVE-2019-14287) Because none-root users can get root privilege using sudo -u#-1 on the command line. If sudo is enabled o… (View Post)