Search found 15 matches

by sreediff
Fri Nov 18, 2016 1:39 pm
Forum: General
Topic: vertica 7.2.3 community edition
Replies: 1
Views: 556

vertica 7.2.3 community edition

where to download 7.2.3 version for red hat 7.
by sreediff
Fri Nov 18, 2016 1:38 pm
Forum: General
Topic: Vertica community edition download
Replies: 1
Views: 1854

Vertica community edition download

where to download vertica 7.2.3 community edition ? I can see community edition for vertica 8.0 only
by sreediff
Wed Oct 19, 2016 8:20 am
Forum: Vertica Database Development
Topic: char(1) vs varchar(1)
Replies: 1
Views: 473

char(1) vs varchar(1)

This regarding usage of data type Varchar and char for indicator columns . I did a sample test to check the bytes used for each data type and there is no difference between bytes used for char or varchar. Which data type occupies less space and is preferred for the usage where length is 1. create ta...
by sreediff
Mon Oct 10, 2016 4:36 am
Forum: General
Topic: vbr.py for copying tables between vertica servers
Replies: 1
Views: 1753

vbr.py for copying tables between vertica servers

i want to use vbr.py between two single nodes . What are settings needed in vbr.ini or custom ini.
Also what all files i need to copy to the target server . WIll restore command with ini file be safe and work without shutting down the target DB.
by sreediff
Mon Oct 10, 2016 4:34 am
Forum: General
Topic: Vertica copy on tables with identity columns
Replies: 3
Views: 397

Vertica copy on tables with identity columns

i created two tables CREATE TABLE TEST1 ( TEST1_ID identity(1) , CHART_TYPE_DESC varchar(100) NOT NULL, CREATED_BY_ID varchar(50), MODIFIED_BY_ID varchar(50) ); CREATE TABLE TEST2 ( TEST2_ID int , CHART_TYPE_DESC varchar(100) NOT NULL, CREATED_BY_ID varchar(50), MODIFIED_BY_ID varchar(50) ); When i ...
by sreediff
Tue Sep 27, 2016 2:29 pm
Forum: Vertica Migration
Topic: export data from vertica on DB1 to vertica on azure -DB2
Replies: 1
Views: 1822

export data from vertica on DB1 to vertica on azure -DB2

We have installed DB2 vertica 7.1 on azure .Vertica is installed on private ip. I connect using telnet/putty using public IP. Now i want to transfer data from DB1 using 'export to vertica' to vertica on azure. However i am unable to connect . How to connect to vertica on azure so that i can export t...
by sreediff
Mon Aug 08, 2016 6:59 pm
Forum: Vertica Database Administration
Topic: change ip address
Replies: 1
Views: 490

change ip address

Can i change IP address of any existing installation>what are the steps ,which files i need to change

Go to advanced search