Questions tagged [vertica]

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

11 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
1answer
273 views

NVMe+bcache as huge storage cache for vertica database

We are in process of selecting hardware for 3 machines vertica cluster capable to serve 20-30TB of data (15TB compressed). This translates to 8TB of post-RAID storage. With 16 CPU cores, the storage ...
1
vote
1answer
197 views

Vertica grant user create table

I have users (developers) in Vertica who need to create tables for testing purposes, which will later be deployed under specific production schema. I do not want them to have the ability to create ...
1
vote
1answer
282 views

How can I reduce the Tuple Mover's disk I/O impact for mergeouts?

I have a cluster with a constant trickle load of new data fed by a stream of large batch COPY statements and also simultaneously support interactive read-queries against the most recently added data, ...
1
vote
0answers
773 views

How to find consecutive count last 3 months count and last 6 months counts

Column names: Site_key. Billing_date ,Reason_type Things to Find: Consecutive count for last 5 months: Last 3 month Count Last 6 month Count I have to find Consecutive count for last 5 months for a ...
1
vote
2answers
2k views

Size, audit and rowcount of a table in Vertica

I need to find a compressed size, an audit and a row count for each table in some schemes. For a compressed size and a row count I tried to use projection_storage: SELECT anchor_table_schema, ...
0
votes
1answer
39 views

How get in SQL pairs of connections in a FW Logs

I have a database with orign_ip, destination_ip, and other columns. I am looking for a way to get in SQL just the connections between two IP's, I need to get just the list. This is my first step : ...
0
votes
0answers
26 views

Why is Vertica Management Console reporting my TZ is not set

I am experimenting with setting up a Vertica Community Edition (9.2.0-0) cluster using three virtual machines. In the Vertica Management Console, when I enter my IP addresses and ask to "Validate Host"...
0
votes
1answer
2k views

I can't restart Vertica database

I have database in Vertica on 4 nodes (RedHat OS). It was working until I decided to restart my DB. After nodes were shut down, they can't be UP anymore. I try to start DB via adminTools: nodes are ...
0
votes
1answer
41 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
0answers
617 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 ...
-1
votes
1answer
2k 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. "") ...