Vertica Forum

Discussion List

• 
  Resource Pool Usage History (v11.1)

  Answered bmurrell 11.2K views 4 comments 0 points Most recent by bmurrell November 2022General Discussion
• 
  Leaving a column out of 'select *'

  Pawn 15.5K views 5 comments 1 point Most recent by Pieter_Sheth-Vo November 2022General Discussion
• 
  Convert ARRAY to SET?

  Answered Pieter_Sheth-Vo 6.3K views 3 comments 0 points Most recent by Pieter_Sheth-Vo November 2022General Discussion
• 
  Is commit still necessary when using INSERT /*+direct*/ INTO ... ?

  Answered ✓ jiahe1224 21.3K views 8 comments 1 point Most recent by jiahe1224 November 2022General Discussion
• 
  How to solve Error 'KafkaJSONParser() does not exist, or permission is denied for KafkaJSONParse'

  Answered joergschaber 6.2K views 2 comments 0 points Most recent by joergschaber November 2022General Discussion
• 
  Why unique constraint doesn't work?

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

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

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

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

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

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

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

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

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

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

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

  Answered ✓ jiahe1224 3.9K views 2 comments 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 9K views 3 comments 0 points Most recent by Sergey_Cherepan_1 November 2022General Discussion
• 
  How to generate a stalled truncate query?

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

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

  Answered ✓ liquidbear 28.6K views 8 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 6.1K views 2 comments 0 points Most recent by SruthiA November 2022General Discussion
• 
  Has anyone benchmarked/compared loading using AVRO (versus NATIVE )

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

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

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

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

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

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

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

  Answered avinash1 3.7K views 2 comments 0 points Most recent by SruthiA October 2022General Discussion