Welcome to the Vertica Forum

The Vertica Forum is getting a makeover! The site will be undergoing maintenance from Tuesday 8/13 to Friday 8/16. We appreciate your patience and cooperation during this time.

General Discussion

Archives for September 2018

DB Restore fails: IOError: Errno 2 No such file or directory

glassfish 421 views 4 comments 0 points Most recent by Jim_Knicely April 12General Discussion
SCD type 1 with merge table data

mpedroso 360 views 2 comments 0 points Most recent by marcothesane September 2018General Discussion
I have a situation

vincitytaymodaimo 312 views 1 comment 0 points Most recent by Jim_Knicely October 2018General Discussion
Column "‘mergeout’" does not exist?

Accepted Answer wardmw 328 views 1 comment 0 points Most recent by wardmw September 2018General Discussion
Vertica and OBIEE 12c

mpedroso 282 views 0 comments 0 points Started by mpedroso September 2018 General Discussion
Vertica and OBIEE 12c

mpedroso 338 views 10 comments 0 points Most recent by siddyash October 2018General Discussion
Limit Memory Usage of Vertica

anshulupadhyay 346 views 2 comments 0 points Most recent by anshulupadhyay September 2018General Discussion
JSON Payload Parsing & Querying

RedOc 949 views 8 comments 0 points Most recent by martinc123 October 2018General Discussion
Using RSQUARED function over multiple data sets

Answered ekilby 284 views 1 comment 0 points Most recent by ekilby September 2018General Discussion
Getting only delta from the Vertica DB using Spark (Java)

Question bala_8383 283 views 0 comments 0 points Started by bala_8383 September 2018 General Discussion
Class Not Found - com.vertica.spark.datasource.DefaultSource

Answered bala_8383 656 views 9 comments 0 points Most recent by LenoyJ May 31General Discussion
Update from Vertica v8.0.1-1 to Vertica v9.1.1-1

tumchik 293 views 0 comments 0 points Started by tumchik September 2018 General Discussion
Need to compare column value and identify outlier records which shows huge spike in data

rahul_vertica_infy 342 views 2 comments 0 points Most recent by rahul_vertica_infy October 2018General Discussion
Copy command not writing in load_streams table

Accepted Answer mpedroso 308 views 5 comments 0 points Most recent by mpedroso September 2018General Discussion
Spark/Scala connecting to Vertica DB with jdbc is failling

Answered msuzuki 831 views 1 comment 0 points Most recent by Connyrt-emp1 October 2018General Discussion
Spark/Scala using jdbc to connect to Vertica DB is failling

Answered msuzuki 541 views 2 comments 0 points Most recent by nrodriguez September 2018General Discussion
Vertica ODBC DSN error

mpedroso 417 views 5 comments 0 points Most recent by Jim_Knicely September 2018General Discussion
VSQL command does not return exit code -1 even if it fails internally

ishangaur 411 views 1 comment 0 points Most recent by DaveT September 2018General Discussion
Vertica Trigger

JunaidKhan 373 views 1 comment 0 points Most recent by Jim_Knicely September 2018General Discussion
License Agreement for JDBC Client drivers missing?

EdMitchell 331 views 4 comments 0 points Most recent by EdMitchell September 2018General Discussion
Load vertica.log in flex table and also evolve a regexp function to identify the error settings

deepvertica 346 views 6 comments 0 points Most recent by DaveT September 2018General Discussion
Similar to COPY FROM is there anything available for COPY TO

Anand 328 views 5 comments 0 points Most recent by Jim_Knicely September 2018General Discussion
Vertica at college fairs at UPitt, Brown, UMass-Amherst, and Brandeis

SarahL 286 views 0 comments 0 points Started by SarahL September 2018 General Discussion
Vertica Cluster questions

Accepted Answer mpedroso 308 views 3 comments 0 points Most recent by mpedroso September 2018General Discussion
Short Query Bias (SQB) function at Netezza/PureData

Kaito 338 views 2 comments 0 points Most recent by Kaito September 2018General Discussion
How to implement Student's t-test

Kaito 335 views 0 comments 0 points Started by Kaito September 2018 General Discussion
Operating systems approved for vertica community 9.x cluster

Accepted Answer mpedroso 312 views 1 comment 0 points Most recent by Jim_Knicely September 2018General Discussion
How to rebalance tables after new storage location was added to each of existing nodes?

I_M 328 views 2 comments 0 points Most recent by I_M September 2018General Discussion
Vertica Clock Skewed

JunaidKhan 440 views 1 comment 0 points Most recent by Jim_Knicely September 2018General Discussion
Vertica differences between Azure and AWS?

ScottL 295 views 0 comments 0 points Started by ScottL September 2018 General Discussion