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.
12
questions with no upvoted or accepted answers
1
vote
1answer
227 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
327 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
826 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
1answer
311 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 ...
0
votes
1answer
52 views
Select from other table if exist
hi I want to union 2 tables but I am not sure if the table is exits
this is my query:
select a from table
union
select case when exists(select a from table1) then (select a from table1)
else (...
0
votes
1answer
50 views
vertica/postgres copy text to binary column
Until now I used Oracle to store xml file in blob data type column.
Is there any option in Vertica to copy xml file into binary column?
I saw there is varbinary data type but, I haven't succeeded to ...
0
votes
0answers
35 views
Is there a way to create temporary tables using CTE's and WITH/VALUES in Vertica?
I'm trying to create a temporary table using CTE's/With.
Is there a Vertica equivalent for this approach?
WITH vals (k,v) AS (VALUES (0,-9999), (1, 100))
SELECT * FROM vals;
I want to be able to ...
0
votes
1answer
45 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
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
663 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
3k 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. "") ...