Vertica Forum

Discussion List

• 
  Why unique constraint doesn't work?

  Answered sergey_h 13.3K views 4 comments 0 points Most recent by VValdar November 2022General Discussion
• 
  Error on PREDICT_AUTOREGRESSOR

  Answered ✓ yongwei 42.3K views 9 comments 0 points Most recent by SruthiA November 2022General Discussion
• 
  Why does the query slow down after partitioning?

  Answered ✓ jiahe1224 30.9K views 10 comments 0 points Most recent by VValdar November 2022General Discussion
• 
  Unable to Find Dependencies to Drop Table

  Patrick_Ting_1 15.4K views 3 comments 0 points Most recent by jiahe1224 November 2022General Discussion
• 
  why my \timing doesn't work？

  Answered ✓ jiahe1224 13.3K views 4 comments 0 points Most recent by jiahe1224 November 2022General Discussion
• 
  Machine Learning

  Answered MdAshrafRahi 11.9K views 2 comments 0 points Most recent by TLinde6 November 2022General Discussion
• 
  How to delete VMart example database in vertica dockerized version

  Answered vaishnavav99 13.7K views 4 comments 0 points Most recent by TLinde6 November 2022General Discussion
• 
  How to analyse high query performance variabilty?

  Answered ✓ joergschaber 25.2K views 8 comments 0 points Most recent by SergeB November 2022General Discussion
• 
  How show the CPU load of a vertica process

  Answered maks 7.5K views 2 comments 0 points Most recent by maks November 2022General Discussion
• 
  Will drop a partition affect ongoing queries?

  Answered ✓ jiahe1224 4.4K views 1 comment 0 points Most recent by Bryan_H November 2022General Discussion
• 
  Other special values besides NULL?

  Answered Pieter_Sheth-Vo 25.3K views 5 comments 0 points Most recent by HKhan1 November 2022General Discussion
• 
  partition by cannot be used in create table as ...?

  Answered ✓ jiahe1224 4.6K views 1 comment 0 points Most recent by Bryan_H November 2022General Discussion
• 
  MAPTOSTRING turns JSON arrays into objects keyed by array index and erases types

  Answered raayan0 10.8K views 3 comments 0 points Most recent by Sergey_Cherepan_1 November 2022General Discussion
• 
  How to generate a stalled truncate query?

  Answered ✓ joergschaber 25.3K views 8 comments 0 points Most recent by joergschaber November 2022General Discussion
• 
  SUM, AVERAGE, COUNT, STDEV across columns?

  Answered ✓ Pieter_Sheth-Vo 17.6K views 5 comments 0 points Most recent by Pieter_Sheth-Vo November 2022General Discussion
• 
  How to Copy text to ARRAY type column

  Answered ✓ liquidbear 34K views 7 comments 0 points Most recent by marcothesane November 2022General Discussion
• 
  Is there a way to set a KafkaSource end condition to load data until there are no new data arrivals

  Answered olivertwsit 7.4K views 2 comments 0 points Most recent by SruthiA November 2022General Discussion
• 
  Has anyone benchmarked/compared loading using AVRO (versus NATIVE )

  Answered kent_hoover 37.5K views 12 comments 0 points Most recent by VValdar November 2022General Discussion
• 
  UNION ALL very slow

  Answered BHIFP 10.1K views 2 comments 0 points Most recent by Sergey_Cherepan_1 November 2022General Discussion
• 
  Median in the moving window

  KG2 20.7K views 6 comments 0 points Most recent by Ralf_S November 2022General Discussion
• 
  JAVA SDK working with complex types in v11

  Answered BHIFP 40.6K views 13 comments 0 points Most recent by KennethAman November 2022General Discussion
• 
  Options/tools to migrate Vertica data to Azure Cloud ADLS

  Answered vasanthvk 19.5K views 6 comments 0 points Most recent by mosheg November 2022General Discussion
• 
  Cannot use outer join in update syntax

  Answered ✓ yashiro 16.6K views 5 comments 0 points Most recent by yashiro November 2022General Discussion
• 
  Optimizing DISTANCE using projections

  Answered zun 10.5K views 3 comments 0 points Most recent by Hibiki October 2022General Discussion
• 
  Restore system table

  Answered avinash1 4.5K views 1 comment 0 points Most recent by SruthiA October 2022General Discussion
• 
  Integration with MQTT

  Answered yongwei 16.4K views 5 comments 0 points Most recent by yongwei October 2022General Discussion
• 
  How to see the source code of an overloaded stored procedure?

  Answered johansn 7.6K views 2 comments 0 points Most recent by SruthiA October 2022General Discussion
• 
  Seeing Broken pipe errors after upgrading the Vertica nodes from Linux 6 to 7.

  Answered gjabraj 79.5K views 17 comments 0 points Most recent by SruthiA October 2022General Discussion
• 
  How to set KafkaSource end condition 'Load data until no new data arrives within a timeout period'?

  Answered joergschaber 16.5K views 5 comments 0 points Most recent by SruthiA October 2022General Discussion
• 
  USAGE privileges on a schema

  Answered fokimure 4.5K views 1 comment 0 points Most recent by VValdar October 2022General Discussion