In this post, we will see how to resolve Docker Vertica’s image fails to create database Question: I have installed the docker image of vertica from https://hub.docker.com/r/vertica/vertica-ce . When I run a standalone docker container like shown in the site, ...
In this post, we will see how to resolve For vertica s3 export query escape multiple characters Question: In Vertica DB we have an attribute column that is either comma-separated or enclosed within inverted commas (double and single applicable). When ...
Question: Remove the “w/o” and convert the date format into “MM/DD/YYYY” (Ex: 10/26/2020) in Sql/Vertica Answer: Remove ' w/o' using REPLACE(), then convert the string to a date using TO_DATE(), and convert the date back to a string using TO_CHAR(). ...
Question: I am trying to run the below query to get a substring from a string but it gives wrong result. I am not sure how to use the regex since the regex I am using works well with PCRE. ...
Question: I have a table like this: id cols val 1 date 01-01-01 1 name abc 1 flag True 1 end_date null 2 date 01-01-02 2 name abcd 2 flag False 2 end_date 01-01-03 And I need to create a ...
Question: I get weather telemetries from Kafka and insert it to Vertica. I want to add to the vertica table a 'receive_time' type timestamp column and 'receive_date' type date column that indicate the exact time a telemetry was been inserted ...
Question: I have a third party app that writes to Vertica database every 5 minutes. As a result, a sample table looks like this: As a result, there are 288 (24 hours * 12 entries each hour) rows for each ...