Vertica Forum

Discussion List

• Calculate a Year’s Chinese Zodiac Animal

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

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

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

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

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

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

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

  184 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'

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

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

  195 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

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

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

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

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

  164 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

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

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

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

  215 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.

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

  166 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.

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

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

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

  185 views 0 comments 0 points Started by Jim_Knicely January 24 Vertica Tips
• Failed to install vertica client 9.1.1 window server 2012

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

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

  175 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???

  195 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 174 views 1 comment 0 points Most recent by Jim_Knicely January 20Vertica Forum
• Does vertica support derivative column concept in case statement.

  196 views 3 comments 0 points Most recent by hdk0310 January 19Vertica Forum
• Enable Join Spill

  175 views 1 comment 0 points Most recent by scottpedersoli January 18Vertica Forum
• Using VSQL as a Calculator

  174 views 0 comments 0 points Started by Jim_Knicely January 18 Vertica Tips
• SQL help with finding peaks across like values in time series data

  184 views 2 comments 0 points Most recent by jbuss January 17Vertica Forum
• i can send email to support

  174 views 1 comment 0 points Most recent by AMiller January 17Vertica Forum
• Extracting Characters from the Left and Right Side of a LONG VARCHAR

  165 views 0 comments 0 points Started by Jim_Knicely January 16 Vertica Tips
• Determining the Current K-Safety

  164 views 0 comments 0 points Started by Jim_Knicely January 15 Vertica Tips
• Unable to grant different authentication to different users

  174 views 2 comments 0 points Most recent by DaveT January 15Vertica Forum
• Client to connect to Vertica

  194 views 4 comments 0 points Most recent by Jim_Knicely January 14Vertica Forum
• Table partition dynamic expression / partition grouping

  164 views 0 comments 0 points Started by nirka January 14 Vertica Forum
• Equivalence of variables in Vertica

  154 views 0 comments 0 points Started by savioceg January 14 Vertica Forum
• Specifying CASCADE When Dropping a Table

  175 views 0 comments 0 points Started by Jim_Knicely January 14 Vertica Tips
• Vertica Analytics Platform - the Analyzer of Everything

  164 views 0 comments 0 points Started by Jim_Knicely January 14 Vertica Forum
• Vertica client versions 8.1 and 9.1 fail to install in Windows 10 Pro 64-bit

  299 views 3 comments 0 points Most recent by icisneros January 12Vertica Forum
• Ordering the List of Values Returned from LISTAGG

  269 views 0 comments 0 points Started by Jim_Knicely January 11 Vertica Tips
• ETL or ELT? What is the best for Vertica Database?

  Accepted Answer 247 views 3 comments 0 points Most recent by mpedroso January 11Vertica Forum
• Ignore NULL Values in Non-Correlated Subqueries

  164 views 0 comments 0 points Started by Jim_Knicely January 10 Vertica Tips
• Unable to call rJava library from within a R UDTF

  194 views 1 comment 0 points Most recent by Hibiki January 10Vertica Forum