Vertica Forum

Got questions? Use the Vertica forum to get expert advice and connect with other Vertica users. Looking for more? Check out our Vertica Community: https://my.vertica.com/big-data-analytics-community-content/

Unclear error location

Answered aryehgielchinsky 724 views 3 comments 0 points Most recent by Jim_Knicely February 13Vertica Forum
What’s the Distance Between Two Zip Codes?

Jim_Knicely 341 views 2 comments 1 point Most recent by Jim_Knicely February 12Vertica Tips
Reset the ROUNDROBIN Load Balancing Counter

Jim_Knicely 283 views 0 comments 0 points Started by Jim_Knicely February 12 Vertica Tips
JDBC over SSL

MaciejPaliwoda 290 views 0 comments 0 points Started by MaciejPaliwoda February 12 Vertica Forum
COPY data into 2 Tables

verban 308 views 1 comment 0 points Most recent by Jim_Knicely February 12Vertica Forum
"Cannot reserve JVM while holding global locks"

Chen_Sun 277 views 0 comments 0 points Started by Chen_Sun February 12 Vertica Forum
Long Varbinary more than 32,000,000 bytes needed for UDF

jumanji 288 views 0 comments 0 points Started by jumanji February 11 Vertica Forum
Long Varbinary morethan 32,000,000

jumanji 278 views 0 comments 0 points Started by jumanji February 11 Vertica Forum
Random Host Load Balancing

Jim_Knicely 281 views 0 comments 0 points Started by Jim_Knicely February 11 Vertica Tips
How to find all statements executed by any user

[Deleted User] 2.9K views 2 comments 0 points Most recent by Jim_Knicely February 11Vertica Forum
Yet Another Way to De-Duplicate Table Rows

Jim_Knicely 303 views 1 comment 1 point Most recent by mkheir February 10Vertica Tips
Too many ROS Container

JunaidKhan 705 views 3 comments 0 points Most recent by JunaidKhan February 7Vertica Forum
Combining Functions to Extract Discrete Data From a String

Jim_Knicely 286 views 0 comments 0 points Started by Jim_Knicely February 7 Vertica Tips
Vertica 7.2.3 data files can be used with Vertica 8.0.1 ?

didAl 327 views 2 comments 0 points Most recent by Bryan_H February 7Vertica Forum
We've published more than 200 Quick Tips

SarahL 278 views 0 comments 0 points Started by SarahL February 6 Vertica Forum
Flattened Table in vertica

savioceg 301 views 1 comment 0 points Most recent by Jim_Knicely February 6Vertica Forum
For using DIRECT load method with GZIP format, what size to consider

sverma28 279 views 2 comments 0 points Most recent by sverma28 February 6Vertica Forum
Calculate a Year’s Chinese Zodiac Animal

Jim_Knicely 278 views 0 comments 0 points Started by Jim_Knicely February 5 Vertica Tips
Copy Vertica DB to google cloud?

usao 358 views 3 comments 0 points Most recent by cloudbigsales February 5Vertica Forum
Finding All Columns Storing Some Value

Jim_Knicely 362 views 0 comments 0 points Started by Jim_Knicely February 4 Vertica Tips
What is the fastest way to insert the data in Vertica?

ashishtomer 375 views 1 comment 0 points Most recent by Jim_Knicely February 1Vertica Forum
error in vertica log

anup1007 316 views 1 comment 0 points Most recent by Jim_Knicely February 1Vertica Forum
Viewing External Table Definitions

Jim_Knicely 279 views 0 comments 0 points Started by Jim_Knicely February 1 Vertica Tips
Transactionally reload daily table snapshots

gytis 294 views 1 comment 1 point Most recent by Jim_Knicely January 31Vertica Forum
Generate a Random Integer Within a Range

Jim_Knicely 299 views 0 comments 0 points Started by Jim_Knicely January 31 Vertica Tips
Error: 'Could not send data to client: No such file or directory'

TimNooren 372 views 3 comments 0 points Most recent by Jim_Knicely January 31Vertica Forum
Seeding a Random Integer

Jim_Knicely 268 views 0 comments 0 points Started by Jim_Knicely January 30 Vertica Tips
vsql transaction model

john8 321 views 4 comments 0 points Most recent by Jim_Knicely January 30Vertica Forum
Support of Vertica 9.1 ( 9.1 and 9.2) on RHEL 7.6

ivan 373 views 0 comments 0 points Started by ivan January 30 Vertica Forum
VerticaDialect.jar file for Vertica and Hibernate Integration

scottysak 291 views 2 comments 0 points Most recent by siddyash January 29Vertica Forum
Seeding a Random Number

Jim_Knicely 284 views 0 comments 0 points Started by Jim_Knicely January 29 Vertica Tips
Limiting the Amount of Memory Available to a Query

Jim_Knicely 281 views 0 comments 0 points Started by Jim_Knicely January 28 Vertica Tips
Vertica v7 to v8

elghali 279 views 2 comments 0 points Most recent by elghali January 28Vertica Forum
Evaluate the similarity of two strings and return the match rate In vertica SQL

Divyashoba 400 views 2 comments 0 points Most recent by Divyashoba January 28Vertica Forum
DatabaseError: Write pandas dataframe to vertica using to_sql and vertica_python

rucci 439 views 0 comments 0 points Started by rucci January 28 Vertica Forum
What is the fastest way to insert the data in Vertica?

ashishtomer 312 views 0 comments 0 points Started by ashishtomer January 28 Vertica Forum
Be Careful with the Sequence CACHE Value

SarahL 331 views 4 comments 0 points Most recent by sreeblr January 25Vertica Tips
"where" when selecting from external table(HDFS), not working with FLOAT, BIGINT e.t.c.

Nikolaysu 329 views 8 comments 0 points Most recent by Nikolaysu January 25Vertica Forum
Display a Rounded Number With a Specific Scale

Jim_Knicely 284 views 0 comments 0 points Started by Jim_Knicely January 25 Vertica Tips
Node went down due to insufficient catalog space and not coming up.

hdk0310 308 views 1 comment 0 points Most recent by SruthiA January 24Vertica Forum
View Vertica Features Recently Used

Jim_Knicely 303 views 0 comments 0 points Started by Jim_Knicely January 24 Vertica Tips
change email for my account

sreeblr 278 views 2 comments 0 points Most recent by sreeblr January 24Vertica Forum
Monitoring COPY Statement Events (Part 2)

Jim_Knicely 298 views 0 comments 0 points Started by Jim_Knicely January 24 Vertica Tips
Hot Fix updates with the release of 8.1.1-27

PhilM1 305 views 0 comments 0 points Started by PhilM1 January 23 Vertica Forum
Failed to install vertica client 9.1.1 window server 2012

Oshrat 289 views 0 comments 0 points Started by Oshrat January 23 Vertica Forum
Adding Node in EON is impact on running queries ?

Mujeef 321 views 1 comment 0 points Most recent by dsprogis January 22Vertica Forum
Monitoring COPY Statement Events (Part 1)

Jim_Knicely 291 views 0 comments 0 points Started by Jim_Knicely January 22 Vertica Tips
How to display query run time in minutes and seconds instead of milliseconds in vsql???

anhphuong 336 views 1 comment 0 points Most recent by Jim_Knicely January 21Vertica Forum
Unable to load the data using COPY STREAM when table has multiple partitions

Answered khaja 293 views 1 comment 0 points Most recent by Jim_Knicely January 20Vertica Forum
Does vertica support derivative column concept in case statement.

hdk0310 315 views 3 comments 0 points Most recent by hdk0310 January 19Vertica Forum