Top "Vertica" questions

Vertica SQL insert multiple rows in one statement

Was wondering whether it's possible to accomplish the following in one insert statement? drop table analytics.bw_covariance_matrix; create …

sql vertica

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 version vertica

ALTER table in vertica

I have table in Vertica which has time_stamp:int with value Unix timestamp, I want to alter this data …

sql database vertica

100 TB of data on Mongo DB? Possible?

What kind of an architecture is needed to store 100 TB data and query it with aggregation? How many nodes? Disk …

mongodb hadoop vertica bigdata database

GROUP_CONCAT in Vertica

Suppose we have data something like this: date | campaign | raw | unq ------------+----------+-----+----- 2016-06-01 | camp1 | 5 | 1 2016-06-01 | …

group-concat vertica

Setting default schema for Vertica Database

I am building a web application using Play! with Vertica database as back-end. The JDBC connection string for Vertica contains …

jpa playframework vertica

Dealing with overlapping conditions in CASE statement

SELECT (CASE WHEN ymd BETWEEN CURRENT_DATE -4 AND CURRENT_DATE -1 THEN '3day total' WHEN ymd BETWEEN CURRENT_…

sql vertica vsql

Convert the datetime value of one time zone to another time zone in Vertica

Is there anything in Vertica to get the same output as given by the following Sql query in Oracle? SELECT …

timezone vertica