Vertica Forum

Discussion List

• Loading data from non-AWS S3

  Question 68 views 2 comments 0 points Most recent by gytis December 2018Vertica Forum
• Copy Table History

  68 views 0 comments 0 points Started by Jim_Knicely December 2018 Vertica Tips
• How to connect R to vertica

  2K views 5 comments 0 points Most recent by Padep December 2018Vertica Forum
• Effective way to bulk update with Merge

  Accepted Answer 70 views 2 comments 0 points Most recent by Alex December 2018Vertica Forum
• QUERY_DURATION_US in the QUERY_PROFILES view

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

  Answered 87 views 3 comments 0 points Most recent by SruthiA December 2018Vertica Forum
• Handling Expression Errors in COPY Statements

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

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

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

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

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

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

  Answered 90 views 5 comments 0 points Most recent by Jim_Knicely December 2018Vertica Forum
• Why some queries exceed time cap set?

  246 views 5 comments 0 points Most recent by SruthiA November 2018Vertica Forum
• Display Tables Referenced by a View

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

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

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

  80 views 0 comments 1 point Started by Jim_Knicely November 2018 Vertica Tips
• Labeling Queries

  57 views 0 comments 0 points Started by Jim_Knicely November 2018 Vertica Tips
• Maximum number tables

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

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

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

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

  58 views 0 comments 0 points Started by Jim_Knicely November 2018 Vertica Tips
• LDAP

  68 views 0 comments 0 points Started by SergioVertica November 2018 Vertica Forum
• Vertica Cluster Shutting Down repeatedly

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

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

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

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

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

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

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

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

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

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

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

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

  58 views 0 comments 0 points Started by Jim_Knicely November 2018 Vertica Tips
• golang driver

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

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

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

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

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

  57 views 0 comments 1 point Started by Jim_Knicely November 2018 Vertica Tips
• Spark Vertica Connector

  57 views 1 comment 0 points Most recent by siddyash November 2018Vertica Forum
• Calculate Request Queue Length

  98 views 8 comments 1 point Most recent by chaima November 2018Vertica Tips
• Passing 3rd argument in IntermediateAggs

  58 views 2 comments 0 points Most recent by jumanji November 2018Vertica Forum
• Return All Cast Failures as NULL

  58 views 0 comments 0 points Started by Jim_Knicely November 2018 Vertica Tips
• Management console not access from web browser

  70 views 1 comment 0 points Most recent by Jim_Knicely November 2018Vertica Forum
• What application would pick HBase

  47 views 0 comments 0 points Started by helenmai November 2018 Vertica Forum