General Discussion

Discussion List

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

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

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

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

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

  Answered ✓ ftobin 4.5K 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 9.6K views 3 comments 0 points Most recent by treb76 September 2023General Discussion
• 
  Verica Write Operation from Spark not working

  Answered haidernaveed_100 11.2K 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 13.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.4K 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.7K views 1 comment 0 points Most recent by Sergey_Cherepan_1 September 2023General Discussion
• 
  declare a variable inside a function

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

  Question qihua_wu 948 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.6K 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.7K 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.6K 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 12.2K 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.9K views 1 comment 0 points Most recent by VValdar September 2023General Discussion
• 
  anyone Successfully used "WITH" clause in a transformation?

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