Vertica Forum

Discussion List

• 
  How to optimize a merge query?

  Answered ✓ joergschaber 16.3K views 8 comments 0 points Most recent by VValdar December 2023General Discussion
• 
  Is there an option to add a column alias to the table definition

  Answered ankitdm 4.8K views 2 comments 0 points Most recent by mosheg December 2023General Discussion
• 
  Is it possible to somehow rename the Vertica schema without interrupting current transaction, withou

  Answered givanx 6.7K views 3 comments -1 point Most recent by givanx December 2023General Discussion
• 
  Vertica 12 spark connector issue while saving dataframe

  Answered aj23 2.9K views 1 comment 0 points Most recent by Bryan_H December 2023General Discussion
• 
  How to put json with array values into varchar columns

  Answered ✓ greyofthedawn 5.1K views 2 comments 0 points Most recent by greyofthedawn December 2023General Discussion
• 
  Getting an error in Visual Studios while extracting the tables from Vertica

  Answered JatinV 8.7K views 4 comments 0 points Most recent by VivJain November 2023General Discussion
• 
  COPY's usage with complex types - ARRAY

  Answered xpegenaute 2.9K views 1 comment 0 points Most recent by marcothesane November 2023General Discussion
• 
  Is it possible to force Vertica to rebalance storage on node

  Answered Sergey_Cherepan_1 981 views 0 comments 0 points Most recent by Sergey_Cherepan_1 November 2023General Discussion
• 
  vsql connection behave differently from ODBC or JDBC

  Answered Sergey_Cherepan_1 4.9K views 2 comments 0 points Most recent by Sergey_Cherepan_1 November 2023General Discussion
• 
  I need to Pivot date/month rows to column.

  Answered ✓ skulkarvertica 11K views 5 comments 0 points Most recent by VValdar November 2023General Discussion
• 
  remove pruned columns dynamically using sdk

  phil2 10.7K views 5 comments 0 points Most recent by phil2 November 2023General Discussion
• 
  How to create a multi node vertica using vertica-ce docker images

  Answered halukakin 3.2K views 1 comment 0 points Most recent by Bryan_H November 2023General Discussion
• 
  Not able to find the Vertica Kafka connector

  Answered JatinV 2.9K views 1 comment 0 points Most recent by Bryan_H November 2023General Discussion
• 
  export to parquet suddenly gone

  Answered lvehbiu 28.4K views 14 comments 0 points Most recent by lvehbiu November 2023General Discussion
• 
  Grouping with moving_average or ARIMA

  Answered lrng 3K views 1 comment 0 points Most recent by VValdar November 2023General Discussion
• 
  Can I add a partition group to a partitioned table ?

  Answered bmurrell 6.9K views 3 comments 0 points Most recent by marcothesane November 2023General Discussion
• 
  Backfilling data and partitions - looking for best practice/advice

  Answered ✓ bmurrell 5K views 2 comments 0 points Most recent by bmurrell November 2023General Discussion
• 
  when will v_monitor.execution_engine_profiles be populated?

  Answered qihua_wu 2.9K views 1 comment 0 points Most recent by SruthiA November 2023General Discussion
• 
  DAX query

  Answered ✓ swetas 8.9K views 4 comments 0 points Most recent by swetas October 2023General Discussion
• 
  what's the difference between Join Inner Tuple Table VS Join Inner Tuple Buffer?

  Question qihua_wu 981 views 0 comments 0 points Most recent by qihua_wu October 2023General Discussion
• 
  Why memory reserved (bytes) is negative?

  Answered qihua_wu 2.9K views 1 comment 0 points Most recent by SruthiA October 2023General Discussion
• 
  Is there any solution to secure backups (or encryption ?)

  Answered mykhan 3K views 1 comment 0 points Most recent by SruthiA October 2023General Discussion
• 
  Warning from UDx API compilation implicit-fallthrough

  Answered Sergey_Cherepan_1 6.9K views 3 comments 0 points Most recent by Sergey_Cherepan_1 October 2023General Discussion
• 
  Sending Datetime or Datetime2 values via linked server in SQL Server - rounded to millisecond

  Answered kamil_kosno 7.1K views 3 comments 0 points Most recent by SruthiA October 2023General Discussion
• 
  Export/import statistics on flex table is not working

  Answered Sergey_Cherepan_1 13.7K views 4 comments 0 points Most recent by SruthiA October 2023General Discussion
• 
  How to deploy c++ udx using only database credentials

  Answered ✓ Sergey_Cherepan_1 5K views 2 comments 0 points Most recent by Sergey_Cherepan_1 October 2023General Discussion
• 
  How to determine the memory need of a query?

  rupenc 18K views 6 comments 0 points Most recent by Sergey_Cherepan_1 October 2023General Discussion
• 
  vkconfig: Is it possible to have kafka-clusters with different authentication on the same scheduler?

  Answered ✓ LauriPessi 5.1K views 2 comments 0 points Most recent by LauriPessi October 2023General Discussion
• 
  Extract JSON Data From Regular Table

  Answered bmurrell 3.5K views 1 comment 0 points Most recent by bmurrell October 2023General Discussion
• 
  Is there a way to concat more than 2 strings?

  Answered Efi 5.3K views 2 comments 0 points Most recent by SruthiA October 2023General Discussion