Vertica Forum

Discussion List

• Before You Upgrade to Vertica 9.1 or 9.2

  Announcement 226 views 2 comments 0 points Most recent by Vertica_Curtis November 20Vertica Forum
• Micro Focus Vertica S/W Support: How to Move from My.Vertica.com to Software Support Online (SSO)

  Announcement 721 views 3 comments 5 points Most recent by Vertiguy March 29Vertica Forum
• REMINDER: Tell us about your experience with Vertica: A Quick Survey

  Announcement 149 views 0 comments 0 points Started by SarahL February 13 Vertica Forum
• Vertica Test Results for Operating System Patches for Meltdown and Spectre Security Flaws

  Announcement 718 views 2 comments 0 points Most recent by mleuchtenburg January 24Vertica Forum
• IMPORTANT: What you need to know about hardware security flaws

  Announcement 276 views 0 comments 0 points Started by SarahL January 4 Vertica Forum
• Vertica integration with Kafka

  Answered 8 views 2 comments 0 points Most recent by Jim_Knicely 5:31PMVertica Forum
• Copy Table History

  4 views 0 comments 0 points Started by Jim_Knicely 5:25PM Vertica Tips
• How to connect R to vertica

  1.5K views 5 comments 0 points Most recent by Padep 3:05PMVertica Forum
• Loading data from non-AWS S3

  Answered 13 views 1 comment 0 points Most recent by Jim_Knicely 2:41PMVertica Forum
• Effective way to bulk update with Merge

  Accepted Answer 16 views 2 comments 0 points Most recent by Alex 1:56PMVertica Forum
• What is default replication factor in Hadoop( big-data-hadoop)

  8 views 1 comment 0 points Most recent by SruthiA December 9Vertica Forum
• QUERY_DURATION_US in the QUERY_PROFILES view

  15 views 0 comments 0 points Started by Tim_1 December 6 Vertica Forum
• Bring back stand By node to permanent state in Vertica

  Answered 21 views 3 comments 0 points Most recent by SruthiA December 5Vertica Forum
• schema replication failed with VIAssert(ctx.excludedSet.count(oldOid) || ctx.mappings.count(oldOid)

  27 views 1 comment 0 points Most recent by SruthiA December 5Vertica Forum
• Handling Expression Errors in COPY Statements

  12 views 0 comments 0 points Started by Jim_Knicely December 4 Vertica Tips
• After Vertica Has Been Installed....

  36 views 18 comments 0 points Most recent by jmchu92 December 4Vertica Forum
• One node is down in three node vertica cluster

  25 views 2 comments 0 points Most recent by RaghavA December 4Vertica Forum
• How to investigate a delay of Copy statement.

  33 views 3 comments 0 points Most recent by Kaito December 4Vertica Forum
• Best practices/tests as to health check for avoiding attempted connections F5 Load Balancer

  7 views 1 comment 1 point Most recent by mkheir December 3Vertica Forum
• Encode Projection Columns with Zstandard Compression

  9 views 0 comments 0 points Started by Jim_Knicely December 3 Vertica Tips
• COPY Statement not rejecting records when FILLER is being used

  Answered 37 views 5 comments 0 points Most recent by Jim_Knicely December 3Vertica Forum
• Union with Group by is possible?

  41 views 1 comment 0 points Most recent by DaveT November 30Vertica Forum
• Why some queries exceed time cap set?

  148 views 5 comments 0 points Most recent by SruthiA November 29Vertica Forum
• Vertica Essentials 9.x ASP Exam registration

  62 views 3 comments 0 points Most recent by SruthiA November 29Vertica Forum
• Display Tables Referenced by a View

  13 views 0 comments 0 points Started by Jim_Knicely November 29 Vertica Tips
• we get error [ERROR] Rolling back MB: [Vertica][VJDBC](2245) ERROR: Attempted to create too many ROS

  15 views 1 comment 0 points Most recent by Jim_Knicely November 29Vertica Forum
• Bulk load from HDFS(using Delegation token mechanism) failing with VIAssert SQL Exception

  28 views 3 comments 0 points Most recent by SruthiA November 28Vertica Forum
• Calculate the Catalog Size in Memory on Each Node

  16 views 0 comments 0 points Started by Jim_Knicely November 28 Vertica Tips
• Labeling Queries

  12 views 0 comments 0 points Started by Jim_Knicely November 28 Vertica Tips
• Maximum number tables

  29 views 3 comments 0 points Most recent by Kaito November 28Vertica Forum
• Returning multiple values

  20 views 0 comments 0 points Started by jumanji November 28 Vertica Forum
• Hash segmentation to node number mapping

  19 views 0 comments 0 points Started by RaghavA November 27 Vertica Forum
• grouping sets - no local resegment groups

  44 views 5 comments 0 points Most recent by nirka November 26Vertica Forum
• Create a User Defined SQL Function to Calculate Fibonacci Numbers

  12 views 0 comments 0 points Started by Jim_Knicely November 26 Vertica Tips
• LDAP

  19 views 0 comments 0 points Started by SergioVertica November 22 Vertica Forum
• Vertica Cluster Shutting Down repeatedly

  Answered 30 views 5 comments 0 points Most recent by Jim_Knicely November 22Vertica Forum
• Replacing an Empty String

  65 views 7 comments 0 points Most recent by Jim_Knicely November 22Vertica Tips
• Calculate Future Thanksgiving Dates

  8 views 0 comments 0 points Started by Jim_Knicely November 21 Vertica Tips
• Unwated data in Dim Table

  18 views 3 comments 0 points Most recent by Jim_Knicely November 21Vertica Forum
• Time Zone - DST

  Question 8 views 0 comments 0 points Started by MaorFrid November 20 Vertica Forum
• Resize cluster 3 => 1, unused buddies

  25 views 1 comment 0 points Most recent by Jim_Knicely November 20Vertica Forum
• Insert Spaces Into a Character String

  13 views 0 comments 0 points Started by Jim_Knicely November 20 Vertica Tips
• Does Vertica have an equivalent to MySQL's GROUP_CONCAT function?

  1.8K views 18 comments 0 points Most recent by Jim_Knicely November 19Vertica Forum
• Find the Version of Vertica that Created a Database

  9 views 0 comments 1 point Started by Jim_Knicely November 19 Vertica Tips
• Database crash during object replication

  47 views 12 comments 0 points Most recent by Jim_Knicely November 19Vertica Forum
• Vertica copy command with identity column

  238 views 2 comments 1 point Most recent by Jim_Knicely November 19Vertica Forum
• Show all the columns in a projection's ORDER by clause

  13 views 1 comment 0 points Most recent by Jim_Knicely November 16Vertica Tips
• Rejected Data Table Row Number

  7 views 0 comments 0 points Started by Jim_Knicely November 15 Vertica Tips
• golang driver

  7 views 0 comments 0 points Started by ramprasadap November 15 Vertica Forum
• Drop/Remove Access Policy

  27 views 2 comments 0 points Most recent by richie1 November 15Vertica Forum
• Time Zone - DST

  Accepted Answer 36 views 4 comments 0 points Most recent by DaveT November 15Vertica Forum
• Reload Data from a Rejected Data Table

  12 views 0 comments 0 points Started by Jim_Knicely November 14 Vertica Tips
• Why would I receive s3() function does not exist.

  Accepted Answer 13 views 2 comments 0 points Most recent by hoosierbigdata November 13Vertica Forum
• Handling Cast Conversion Load Errors

  13 views 0 comments 0 points Started by Jim_Knicely November 13 Vertica Tips