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

4
votes
1answer
5k views

How do I get the size of a Vertica database?

I have a Vertica database. How can I tell how big the database is? I need a rough answer for the purposes of reporting basic statistics about our environment to upper management.
4
votes
1answer
93 views

Is Vertica's COPY atomic?

Seems like a simple thing, but I can't seem to find it in the docs for COPY. Is Vertica's COPY atomic? If a data load is interrupted or somehow fails, does Vertica take care of the cleanup?
4
votes
1answer
1k views

create linked server to vertica

I'm attempting to create a linked server from SQL Server to Vertica to pull over some data. I've attempted using the following ODBC found here. The code I'm currently trying is: EXEC dbo....
3
votes
2answers
1k views

How to load data into Vertica from C?

I'm investigating column oriented databases and came across Vertica. My need is to feed the Vertica database from C code. I don't succeed in grabbing this information from Vertica: I'm told to use "...
3
votes
1answer
142 views

Why does the Tuple Mover in C-Store consider only rows older than LWM?

In the Tuple Mover section of the C-Store paper by Michael Stonebraker (link: http://db.csail.mit.edu/projects/cstore/vldb.pdf) the following is described: MOP (merge out process) will find all ...
3
votes
4answers
130 views

Pairwise intersections

I have a table with two columns, let's say FirstName and LastName. I need to get another table, which for every pair of FirstName's from the first one contains a count of the common LastName's. Is ...
3
votes
1answer
3k views

How To dump data from Oracle to Vertica

I want to transfer data from Oracle to Vertica and I want to know what is best way to do it? I s there a tool for it? I tried to dump the Oracle data and load it to Vertica using 'Copy Direct' ...
2
votes
1answer
2k views

Where do I find the tables that a role has access to in Vertica?

I'm trying to use the System Tables to fetch some metadata about the whole Vertica cluster at a table level (including permissions). Where can I find the information about permissions required to ...
2
votes
1answer
35 views

Why does CURRENT_LOAD_SOURCE() return “Batch No. 1” instead of the actual source file name?

I'm loading some data into a table like this: COPY table1 ( col1, col2, file_name AS CURRENT_LOAD_SOURCE() ) FROM LOCAL :src_file REJECTED DATA :rejected_file EXCEPTIONS :exceptions_file ...
2
votes
2answers
153 views

Why would Vertica let me start a transaction if I can't roll it back?

I run the following statements against a Vertica database, one at a time: BEGIN TRANSACTION; UPDATE table SET col1 = 'something' WHERE col2 = 'something else'; SELECT COUNT(*) FROM table WHERE col1 ...
1
vote
2answers
242 views

How to architect an analytical BI platform? [closed]

I am working on a new BI project for a medium sized corporation. Right now there is no Analytical infrastructure in place and the reporting is done manually in Excel. There are a few different data ...
1
vote
1answer
188 views

Vertica performance on select from view with union

We have a huge number of rows(tens of millions), and for each table we have an associated view that is a select with UNION ALL between that table and several others. Now, we are doing a select from ...
1
vote
1answer
120 views

What is a “leaf expression”?

What is a "leaf expression"? Partition-clause expressions are limited in the following ways: Your partition-clause must calculate a single non-null value for each row. You can reference multiple ...
1
vote
2answers
793 views

In the Vertica database, what is a namespace?

In the Vertica database, what does the term "namespace" mean? I have reviewed the entire Vertica documentation and cannot find what this means.
0
votes
3answers
2k views

how to find vertica community edition and how to export / copy data

I have the hardest time downloading anything other than enterprise edition from vertica.com. It is supposed to have a community edition on https://my.vertica.com/community/ but all the links just show ...
0
votes
2answers
2k views

Does HP Vertica run on Windows and is it compatible with our existing Oracle SQL?

I am new to HP Vertica. I read the installation documentation for HP Vertica, but it seems to be totally unix focused. Can we install HP Vertica under Windows? Additionally, will we need to update ...
0
votes
1answer
202 views

Vertica INSERT speed highly depends on server load

I faced a problem with very slow INSERTs in Vertica DB. I made such test: create empty table with no projections and start inserting in it in batch, using > INSERT INTO table SELECT 111,222,333 ...
0
votes
0answers
114 views

Truncate a decimal field without rounding in VERTICA

How can I use Truncate function without rounding in Vertica? TRUNCATE(total,0) as total ERROR : Function TRUNCATE(numeric, int) does not exist Thanks
0
votes
1answer
179 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
0answers
199 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
33 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
1answer
31 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
49 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
309 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 ...
0
votes
1answer
63 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
843 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 ------------- ...
-1
votes
2answers
77 views

Vertica 6.1: vsql creashes with large resultset

I'm writing a script to export data from our Vertica cluster. The command I'm using is: vsql MY_DB_NAME -At -F$'\t' -o /data/vertica_archive/MY_DATA_2015_07_01.tsv -c "select * from DATA_TABLE where ...