Vertica Forum

Discussion List

• 
  Rule of thumb for picking shard count?

  Answered kxu 6.7K views 2 comments 0 points Most recent by ChuckB April 2020General Discussion
• 
  Changing depot parameters

  Answered kxu 4.2K views 1 comment 0 points Most recent by skeswani April 2020General Discussion
• 
  Dynamic partition pinning?

  Answered kxu 4.2K views 2 comments 0 points Most recent by skeswani April 2020General Discussion
• 
  Determining depot size

  Answered kxu 6.7K views 2 comments 0 points Most recent by skeswani April 2020General Discussion
• 
  User specified segmentation in Live Aggregate Projections?

  Answered Min_Yun_Chan 6.7K views 2 comments 0 points Most recent by ChuckB April 2020General Discussion
• 
  How many projections used per query?

  Answered DreaBrandford 6.8K views 2 comments 0 points Most recent by DaveT April 2020General Discussion
• 
  How do queries behave after a subcluster is removed?

  Answered kxu 4.1K views 1 comment 0 points Most recent by skeswani April 2020General Discussion
• 
  DBD: How many candidate projections?

  Answered DreaBrandford 4.1K views 1 comment 0 points Most recent by RaghavAg April 2020General Discussion
• 
  How does the native load balance round-robin work?

  Answered kxu 4.2K views 1 comment 0 points Most recent by skeswani April 2020General Discussion
• 
  Eon mode: projections created on ALL NODES or all shards?

  Answered DreaBrandford 4.2K views 1 comment 0 points Most recent by Pan April 2020General Discussion
• 
  Creating a stored procedure returning multiple rows

  Answered DreaBrandford 4.5K views 1 comment 0 points Most recent by marcothesane April 2020General Discussion
• 
  Automated profiling tools to sift through the pre-made scripts for object migration

  Answered Min_Yun_Chan 4.2K views 1 comment 0 points Most recent by marcothesane April 2020General Discussion
• 
  How do aggregate projections affect the load performance?

  Answered Min_Yun_Chan 4.2K views 1 comment 0 points Most recent by marcothesane April 2020General Discussion
• 
  Potential impact of frequent Vertica updates on SCD2 historization of dimensional tables?

  Answered Min_Yun_Chan 4.2K views 1 comment 0 points Most recent by marcothesane April 2020General Discussion
• 
  Combining flattened table and Live Aggregate Projections for denormalized table with aggregates?

  Answered Min_Yun_Chan 6.7K views 2 comments 0 points Most recent by marcothesane April 2020General Discussion
• 
  DBD: Can we see the benefit/cost scores for projection candidates?

  Question DreaBrandford 1.7K views 0 comments 1 point Started by DreaBrandford April 2020 General Discussion
• 
  How does DBD calculate storage?

  Question DreaBrandford 1.7K views 0 comments 1 point Started by DreaBrandford April 2020 General Discussion
• 
  DBD enhancement: supporting views

  Question DreaBrandford 1.7K views 0 comments 1 point Started by DreaBrandford April 2020 General Discussion
• 
  LAPs and the WHERE clause

  Answered DreaBrandford 6.6K views 2 comments 0 points Most recent by bertcord2 April 2020General Discussion
• 
  If my data size is 4TB with 4 nodes, what should the depot size be?

  Answered emichaud 84.6K views 1 comment 0 points Most recent by bertcord2 April 2020General Discussion
• 
  Can MC alerts be sent via SNMP traps, or queried by SNMP?

  Answered emichaud 4.1K views 1 comment 0 points Most recent by emichaud April 2020General Discussion
• 
  MC - Coordinating Vertica upgrades with cluster management, Eon Mode, and the MC version

  Question emichaud 1.7K views 0 comments 1 point Started by emichaud April 2020 General Discussion
• 
  Example of scenarios to not define a projection?

  Answered Min_Yun_Chan 4.2K views 1 comment 0 points Most recent by ybei April 2020General Discussion
• 
  SELECT statement performance improvements?

  Answered rjs_docs 4.2K views 1 comment 0 points Most recent by twall April 2020General Discussion
• 
  Vertica 10 wire protocol - reference docs? Integration suggestions?

  Answered rjs_docs 4.3K views 1 comment 0 points Most recent by twall April 2020General Discussion
• 
  Using Uber's started vertica-python package?

  Answered rjs_docs 4.1K views 1 comment 0 points Most recent by twall April 2020General Discussion
• 
  Inheritance on sequences?

  Question kxu 1.7K views 0 comments 0 points Started by kxu April 2020 General Discussion
• 
  Updates to language server protocol?

  Question rjs_docs 1.7K views 0 comments 1 point Started by rjs_docs April 2020 General Discussion
• 
  Can a superuser impersonate a regular user?

  Question kxu 1.7K views 0 comments 0 points Started by kxu April 2020 General Discussion
• 
  DEFAULT values not being populated by Kafka microbatch loader

  Answered johnnychien 9.2K views 3 comments 0 points Most recent by ThePebble April 2020General Discussion