I’ve looked for an answer here to no avail; wondering if this problem is best suited outside SQL environment but thought I’d see how it could be solved. I’m trying to look at web journeys and as a result need my data to be in the following format: At present the data is in the following format: I essentially want
Tag: vertica
Vertica: How to create a new column by subtracting two other columns?
I have a Vertica table named Start_End like: It has about 100,000 rows. How can I use months_between to subtract Started from Ended? The resulting table would look like: The following will add a blank column: How can I use months_between? Answer Check here: https://www.vertica.com/docs/9.3.x/HTML/Content/Authoring/SQLReferenceManual/Functions/Date-Time/MONTHS_BETWEEN.htm?zoom_highlight=MONTHS%20BETWEEN to find out if the behaviour of MONTHS_BETWEEN() (when to return INTEGER, when to return
Case statements around values in a list
I have a table that looks like below after performing certain joins: create table test(id varchar(10), sub varchar(20)); insert into test values(1,’a’) insert into test values(1,’b’) insert into …
Solving Query-Errors in Vertica [Vertica][VJDBC](4160) and [Vertica][VJDBC](4680)
I have some issues in getting my Vertica query to work correctly. Let’s assume I have a relation which is defined as follows: CREATE TABLE KOMM ( MANDT VARCHAR(3), DOCNUM …
Is there a way to query and find out the version of Vertica installed?
I searched the Vertica documentation for the keywords Version and Version Number. But I couldn’t really get any mention of SQL query to select the version of Vertica installed. I thought there would …