Search found 18 matches

by sreediff
Mon Oct 10, 2016 4:34 am
Forum: General
Topic: Vertica copy on tables with identity columns
Replies: 3
Views: 9212

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: 16930

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: 7
Views: 37127

change ip address

Can i change IP address of any existing installation>what are the steps ,which files i need to change
by sreediff
Mon Aug 08, 2016 5:47 pm
Forum: Vertica Community Edition
Topic: vbr.py
Replies: 2
Views: 15758

vbr.py

can vbr.py be used to copy tables between two servers.?
by sreediff
Mon Aug 08, 2016 5:43 pm
Forum: Vertica Community Edition
Topic: vertica vsql limit
Replies: 1
Views: 43044

vertica vsql limit

vertica sql spool limit
I am trying to create dump of table using vsql -vsql -U -w -F "|" -P footer=off -AXnqc "select * from USER_SLCT" > USER_SLCT.csv
The table has 7 million rows but the output of the above shows only 1.79 million. Is there any limit in vsql?
by sreediff
Wed May 25, 2016 5:46 pm
Forum: Vertica "How to..."
Topic: NaN value in STDDEV
Replies: 4
Views: 58469

Re: NaN value in STDDEV

if i give float insert NaN:float will insert data but can we give limit to float datatype ?
by sreediff
Wed May 25, 2016 5:33 pm
Forum: Vertica "How to..."
Topic: NaN value in STDDEV
Replies: 4
Views: 58469

Re: NaN value in STDDEV

- ERROR: Float "nan" is out of range for type numeric(16,5) . What should be datatype/length to be used for inserting NaN ?

Go to advanced search