Vertica is a high performance commercial column-oriented DBMS that runs mainly in a Clustered environment. It uses ANSI SQL and runs on Linux.

learn more… | top users | synonyms

0
votes
1answer
262 views

Why bulk loading a Vertica database table does not load all lines?

I have a small csv file I would like to bulk load into a Vertica 6.1 database table, this file has 92 lines. dbadmin=> COPY games FROM '/tmp/games.csv' DELIMITER ','; Rows Loaded ------------- ...
0
votes
0answers
124 views

Vertica pagination

I have a query that gives the total number of rows to use in a pagination: select count(1) as total_rows from (subquery with some sum() and 2 inner joins) as as total_sums 1 - when I run only the ...
-1
votes
0answers
25 views

Query band like feature in Vertica?

I've been working long time with Teradata and I've found its Query band feature very useful for audit purposes. Query Band is a feature that allows an external client to add additional information in ...