Vertica Forum

Discussion List

• Effective way to bulk update with Merge

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

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

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

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

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

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

  216 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

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

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

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

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

  184 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

  357 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

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

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

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

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

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

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

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

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

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

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

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

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

  174 views 3 comments 0 points Most recent by Jim_Knicely November 2018Vertica Forum
• Resize cluster 3 => 1, unused buddies

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

  164 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.6K views 18 comments 0 points Most recent by Jim_Knicely November 2018Vertica Forum
• Find the Version of Vertica that Created a Database

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  154 views 0 comments 0 points Started by helenmai November 2018 Vertica Forum
• Does STV_Intersect Operation takes all the Points inside a Polygon?

  Answered 154 views 1 comment 0 points Most recent by Ariel_Cary November 2018Vertica Forum
• Does STV_Intersect Operation takes all POINTS that are INSIDE a POLYGON?

  154 views 0 comments 0 points Started by msuzuki23 November 2018 Vertica Forum
• Extremely Slow ST_Contains Query Across 20 Billion Rows in Vertica Place

  459 views 9 comments 0 points Most recent by msuzuki23 November 2018Vertica Forum
• Display Canceled Queries

  164 views 0 comments 0 points Started by Jim_Knicely November 2018 Vertica Tips