Database Administrators Stack Exchange
Database Administrators Stack Exchange

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.

Vertica is a column-oriented DBMS designed for data warehousing. Vertica is based on C-Store, which was an academic project involving academic and entrepreneur Michael Stonebraker (a co-founder of Vertica, Ingres, VoltDB) and colleagues from Brandeis University, Brown University, MIT, and University of Massachusetts Boston.

Vertica is designed to run in a Clusters environment on Linux boxes. A Vertica Cluster runs in a MPP(Massive Parallel Processing)fashion, and it is designed to scale linearly by adding nodes to the cluster. Columns are stored independently of other columns and allow for increased compression in storage.

46 questions
4
votes
4 answers

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 this even feasible to do in SQL? There are much more…
Andris Birkmanis
  • 223
  • 1
  • 6
3
votes
2 answers

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 "vsql" and the "copy" command. All I want is issue…
SCO
  • 565
  • 5
  • 8
3
votes
3 answers

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 SELECT on a table? I've poked around in the GRANTS…
vinaykola
  • 33
  • 1
  • 4
2
votes
2 answers

How "LIKE" by LONG VARCHAR?

I had DB Vertica 8.0. Create schema WAREHOUSE with table include field by type LONG VARCHAR. Now I tried to execude SELECT for example SELECT * FROM WAREHOUSE.ALL_EVENTS a WHERE a.original_data like '%d963%' returned error SQL Error [4286]…
Nikolay Baranenko
  • 177
  • 2
  • 12
1
vote
1 answer

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 ------------- 44 The file is 92 lines, but Vertica only…
davidjhp
  • 429
  • 1
  • 7
  • 17
1
vote
2 answers

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.
davidjhp
  • 429
  • 1
  • 7
  • 17
1
vote
1 answer

Vertica Export configuration

I have a DEV Vertica database and need to create a new TST Vertica database. During the past few months both administrators and users have had pretty-much wide open access to do what ever was needed to get things working. Thus, the internal Vertica…
Ron Watkins
  • 21
  • 1
1
vote
2 answers

Vertica-cluster architecture

I know that MongoDB has master-slave architecture and Cassandra has peer to peer architecture. I didn't find any resources about Vertica's architecture. Is that master slave or peer to peer? Does Vertica cluster allow multi-read and multi-write?
shyam rakhecha
  • 73
  • 7
1
vote
1 answer

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 tables in the production schema though. Im looking…
Ron Watkins
  • 21
  • 1
1
vote
2 answers

Problem of SUM of the SUM

When I execute my query I have always the same problem : year_created|month_created|loc_id_1|loc_id_2|loc_id_3|Total ------------------------------------------------------------ 2016 | 7 | 0 | 0.40 | 0 0.40 2016 …
Sarah
  • 111
  • 2
  • 4
  • 12
1
vote
2 answers

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, anchor_table_name, SUM(used_bytes), …
Vikora
  • 11
  • 2
  • 4
0
votes
2 answers

How skip vmart dataabse loading?

I am running docker vertica/vertica-ce image. But during start up it loads VMart database as example. I do not want this. Is there a way to disable this? I have tried to set export WITH_VMART=false export VMART_LOAD_DATA=n But it loads data anyway…
Cherry
  • 129
  • 1
  • 4
0
votes
1 answer

Got empty tables invertica after execute a file by vsql

Step by step scenario: Start cmd from odcker Run install.sh with list of files sql file with schema loaded (I see tables) sql with data alsoe excuted but no data present in tables. But If I execute same file (!) by Intellij Idea that connected to…
Cherry
  • 129
  • 1
  • 4
0
votes
0 answers

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 use the data without creating a temp table How to…
fcsr
  • 101
  • 2
0
votes
1 answer

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 : SELECT DISTINCT orig_h , resp_h from gustavo.conn; …
grojas123
  • 1
  • 2
1
2