General Discussion

Discussion List

• 
  How to find out all the tables with no data.

  Answered ✓ SK21 17.4K views 5 comments 0 points Most recent by Jim_Knicely January 2021General Discussion
• 
  What authentication does dbadmin need to startup a cluster?

  Answered mgroesbeek 13.8K views 4 comments 0 points Most recent by SergeB February 2021General Discussion
• 
  Get largest tables in database

  Answered ✓ reli 11.2K views 3 comments 0 points Most recent by Sergey_Cherepan_1 January 2021General Discussion
• 
  Need to retrieve particular string from all tables and get table names

  Answered ✓ SK21 11K views 3 comments 0 points Most recent by mosheg December 2020General Discussion
• 
  The number of unused projections is not displayed

  Answered yamakawa 13.9K views 4 comments 0 points Most recent by yamakawa January 2021General Discussion
• 
  Is there a better way to export data from a very big vertica table to flatfile?

  Answered sri_vtca 8.5K views 2 comments 0 points Most recent by poojan December 2020General Discussion
• 
  Dynamic Header Column When Exec Query

  Answered ✓ reli 57.2K views 18 comments 0 points Most recent by Sergey_Cherepan_1 January 2021General Discussion
• 
  Specifying length of VARCHAR

  Answered Pieter_Sheth-Vo 29.8K views 8 comments 0 points Most recent by vivekbarad December 2020General Discussion
• 
  Exposing Vertica log as external table for SQL access? Does anyone have a script with log parser?

  Sudhakar_B 7.8K views 2 comments 0 points Most recent by Sudhakar_B December 2020General Discussion
• 
  memory_allocated_bytes from "v_monitor"."query_plan_profiles" always NULL : A bug?

  Answered Sudhakar_B 19.9K views 6 comments 0 points Most recent by SruthiA December 2020General Discussion
• 
  SYSQUERY_POOL_SPILL event in dc_execution engine events: Any concerns?

  Answered ✓ Sudhakar_B 20.1K views 6 comments 0 points Most recent by Sudhakar_B December 2020General Discussion
• 
  erro in cast array

  Answered ✓ reli 20.8K views 4 comments 0 points Most recent by Pieter_Sheth-Vo June 2023General Discussion
• 
  Fill Missing Dates for Each Group in an existing table

  Answered ✓ JayantaB 8.4K views 2 comments 0 points Most recent by JayantaB December 2020General Discussion
• 
  How to generate an error

  Answered ✓ yamakawa 10.8K views 3 comments 0 points Most recent by yamakawa December 2020General Discussion
• 
  Vertica bulk upload failing from R

  Answered mvishruth 8K views 1 comment 0 points Most recent by mosheg December 2020General Discussion
• 
  Same query executes 2 times in a row

  Answered ✓ zadvovl 14.4K views 4 comments 0 points Most recent by zadvovl December 2020General Discussion
• 
  Default permissions for vertica.log

  Answered ivan 13.9K views 4 comments 0 points Most recent by ivan December 2020General Discussion
• 
  "No transaction in progress" message occured in error_messages table frequently..

  Answered HyeontaeJu 5.4K views 1 comment 0 points Most recent by mosheg December 2020General Discussion
• 
  Why is the error occured?

  Answered HyeontaeJu 8.4K views 1 comment 0 points Most recent by mosheg December 2020General Discussion
• 
  Unable to import existing database from Management console

  mqazi 7.8K views 2 comments 0 points Most recent by mqazi December 2020General Discussion
• 
  How many nodes are enough for 24 terabytes of data?

  Answered SK21 14K views 4 comments 0 points Most recent by Vertica_Curtis January 2021General Discussion
• 
  What is difference purge() and DO_TM_TASK('mergeout') ?

  Answered HyeontaeJu 5.4K views 1 comment 0 points Most recent by mosheg December 2020General Discussion
• 
  Slow query execution

  yamakawa 17K views 5 comments 0 points Most recent by yamakawa December 2020General Discussion
• 
  How to grant superuser grants to user?

  Answered HyeontaeJu 4.9K views 1 comment 0 points Most recent by Jim_Knicely December 2020General Discussion
• 
  How can i fix the message "Monitoring Activities requires the database user have the DBADMIN role"

  Answered HyeontaeJu 14.1K views 4 comments 0 points Most recent by Jim_Knicely December 2020General Discussion
• 
  How to check table is exist?

  Answered HyeontaeJu 13K views 3 comments 0 points Most recent by mosheg December 2020General Discussion