+1Hello,
I do not have access to Vertica.com. My team is looking into this. So I have to use the forums.
Does anyone know the equivalent to TRY_CONVERT and PARSENAME in Vertica? They are SQL Server functions. Below is what I need to convert to Vertica.
select CONVERT(BIGINT, PARSENAME(IP_Address, 4))256256256 + CONVERT(BIGINT, PARSENAME(IP_Address,3))256256 +
CONVERT(BIGINT, PARSENAME(IP_Address,2))256 + CONVERT(BIGINT, PARSENAME(IP_Address,1))
from IP
Thank you all in advance.
+2For TRY_CONVERT, the "::!" construct should help:
dbadmin=> select * from test; c --- A 1 (2 rows) dbadmin=> select c, c::int from test; ERROR 2827: Could not convert "A" from column test.c to an int8 dbadmin=> select c, c::!int from test; c | c ---+--- A | 1 | 1 (2 rows)
For PARSENAME, maybe user SPLIT_PART?
dbadmin=> select split_part('192.168.1.1', '.', 1);
split_partb
-------------
192
(1 row)
Wow, perfect! Thanks Jim!
Jim - you just saved me a huge headache. Thanks again.
Jim - you just saved me a huge headache. Thanks again.
Wow, perfect! Thanks Jim!
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
