Curious how a view fits into the categories of not practical, overhead, or poorly performing. You can perform the desired formatting while loading into the table so you don't do it on each and every … (View Post)

What version of Vertica are you running? Suggest opening a support case if you think there is an issue. Here are examples from Vertica 10.1.1 where it fails as expected due to missing privileges; and… (View Post)

Try using a backslash in your search string, as in '\.co' (View Post)

I recommend taking a step back from the database and running the v*perf utilities if you have not already done that. Make sure that your environment is performant before you investigate the database. (View Post)