General Discussion

Discussion List

• 
  permissions for views that access other schema's table does not work; only dbadmin owner works?

  Answered ✓ ftobin 13.9K views 9 comments 0 points Most recent by VValdar October 2023General Discussion
• 
  OpenText 2023 conference

  Answered Sergey_Cherepan_1 820 views 1 comment 0 points Most recent by Sergey_Cherepan_1 September 2023General Discussion
• 
  Pivot from columns to rows?

  Answered yardenpel 4.8K views 2 comments 0 points Most recent by VValdar September 2023General Discussion
• 
  Are Vertica CTEs reusable?

  Answered Pieter_Sheth-Vo 9.8K views 6 comments 0 points Most recent by Hibiki May 2024General Discussion
• 
  'interpolate previous value' expression order does not matter?

  Answered ✓ ftobin 4.2K views 2 comments 0 points Most recent by ftobin September 2023General Discussion
• 
  Query with LISTAGG function fails on secondary subcluster but passes on primary (Error loading file)

  Answered ✓ treb76 9K views 3 comments 0 points Most recent by treb76 September 2023General Discussion
• 
  Verica Write Operation from Spark not working

  Answered haidernaveed_100 9.9K views 7 comments 0 points Most recent by Bryan_H May 2024General Discussion
• 
  profile timing data doens't match the real sql elapse time.

  Answered qihua_wu 12.2K views 7 comments 0 points Most recent by qihua_wu September 2023General Discussion
• 
  why group by hash has multiple activity id?

  Answered qihua_wu 4.1K views 2 comments 0 points Most recent by qihua_wu September 2023General Discussion
• 
  explain local version: How to understand section "Estimated resources for plan:"

  Answered qihua_wu 2.5K views 1 comment 0 points Most recent by Sergey_Cherepan_1 September 2023General Discussion
• 
  declare a variable inside a function

  Answered ✓ Efi 5.8K views 3 comments 0 points Most recent by VValdar September 2023General Discussion
• 
  activity_id and operator_id in profile table

  Question qihua_wu 893 views 0 comments 0 points Started by qihua_wu September 2023 General Discussion
• 
  after materiaize, are the data process in columns based format or row based format?

  Answered qihua_wu 2.4K views 1 comment 0 points Most recent by marcothesane September 2023General Discussion
• 
  What's the meaning of LOCAL ROUND ROBIN in the execution plan?

  Answered ✓ qihua_wu 9.1K views 5 comments 0 points Most recent by qihua_wu September 2023General Discussion
• 
  Syntax for transform with expression on value, keeping column name same as field name

  Answered Sergey_Cherepan_1 2.5K views 2 comments 0 points Most recent by SruthiA September 2023General Discussion
• 
  How to find the week days between two dates using Vertica?

  Answered sachin 11.4K views 6 comments 0 points Most recent by sachin September 2023General Discussion
• 
  "Establishing a Connection from a .NET Core App to Vertica Database"

  Answered juditrjones 2.7K views 1 comment 0 points Most recent by VValdar September 2023General Discussion
• 
  anyone Successfully used "WITH" clause in a transformation?

  Answered Jrnisaac1 2.5K views 1 comment 0 points Most recent by SruthiA September 2023General Discussion