General Discussion

Discussion List

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

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

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

  Answered ✓ reli 10.1K 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 9.8K views 3 comments 0 points Most recent by mosheg December 2020General Discussion
• 
  The number of unused projections is not displayed

  Answered yamakawa 12.5K 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 7.6K views 2 comments 0 points Most recent by poojan December 2020General Discussion
• 
  Dynamic Header Column When Exec Query

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

  Answered Pieter_Sheth-Vo 26.9K 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 7K views 3 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 17.8K 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 18K views 6 comments 0 points Most recent by Sudhakar_B December 2020General Discussion
• 
  erro in cast array

  Answered ✓ reli 18.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 7.6K views 2 comments 0 points Most recent by JayantaB December 2020General Discussion
• 
  How to generate an error

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

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

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

  Answered ivan 12.5K 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 4.9K views 1 comment 0 points Most recent by mosheg December 2020General Discussion
• 
  Why is the error occured?

  Answered HyeontaeJu 7.7K views 2 comments 0 points Most recent by mosheg December 2020General Discussion
• 
  Unable to import existing database from Management console

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

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

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

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

  Answered HyeontaeJu 4.4K 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 12.6K views 4 comments 0 points Most recent by Jim_Knicely December 2020General Discussion
• 
  How to check table is exist?

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