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
29 views

COPY in TSV data enclosed by quotes; treat empty strings as NULLs

I have a TSV file like this, except with many more columns: "name"\t"color"\t"lucky_number" "Nick"\t"Red"\t"" ""\t"Blue"\t"8" I'm trying to COPY this file into a table and have empty cells (i.e. ...
0
votes
1answer
28 views

Set Default Maximum Rows for Export

I am more of a Vertica database user than admin, so I'm not even sure if what I'm asking is absurd, but here goes nothing... Could I, as an admin, put default restrictions on the number of rows that ...
0
votes
1answer
629 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
39 views

Getting “LDAP authentication failed” when connecting to Vertica via JDBC

I'm trying to connect to a Vertica 7.1.1 database using DBeaver. I've downloaded the 7.1.2 JDBC driver (I couldn't find a 7.1.1 driver available for download) and configured DBeaver to use it. When I ...
0
votes
0answers
30 views

How to Find Consecutive count of a column based on a their status

I have a table containing various sites and billing information of those sites. Ex: site_key | billing_date | Reason_type | rank ----------+---------------------+-------------+------ ...
0
votes
0answers
26 views

Create a new column with sequential days based on start and end dates

Say I have a single row of data referring to a specific marketing activity that has a start and end dates: activity start_date end_date abcdmkt12 2015-06-01 2015-06-03 How can I reshape ...
0
votes
0answers
250 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 ; when I run only ...