General Discussion

Archives for September 2023

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

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

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

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

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

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

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

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

Answered qihua_wu 3.8K 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.3K views 1 comment 0 points Most recent by Sergey_Cherepan_1 September 2023General Discussion
declare a variable inside a function

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

Question qihua_wu 840 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.3K 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 8.5K 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.3K 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 10.6K 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.5K views 1 comment 0 points Most recent by VValdar September 2023General Discussion
anyone Successfully used "WITH" clause in a transformation?

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