Search found 18 matches
- 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 ...
- 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...
- 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
- 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.?
- 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?
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?
- 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 ?
- 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 ?