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
0answers
27 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 ...
3
votes
1answer
185 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.
0
votes
1answer
92 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 ------------- ...
4
votes
1answer
301 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 ...
-1
votes
2answers
262 views

HP Vertica, can we install it on Windows & the SQL we use for oracle is same for the HP Vertica?

I am new to HP Vertica. I read the installation documentation for the HP Vertica. The documentation is totally based on the *ix environment. So, my question is Can we install HP Vertica on Windows ...
0
votes
0answers
72 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
vote
1answer
82 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
201 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
816 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 ...
3
votes
1answer
1k 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' ...
3
votes
4answers
805 views

How to query a Vertica server in C language?

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 ...