The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

General Discussion

Archives for December 2020

What authentication does dbadmin need to startup a cluster?

Answered mgroesbeek 2.3K views 4 comments 0 points Most recent by SergeB February 2021General Discussion
How many nodes are enough for 24 terabytes of data?

Answered SK21 2.5K views 4 comments 0 points Most recent by Vertica_Curtis January 2021General Discussion
Dynamic Header Column When Exec Query

Answered ✓ reli 9.3K views 18 comments 0 points Most recent by Sergey_Cherepan_1 January 2021General Discussion
Get largest tables in database

Answered ✓ reli 2K views 3 comments 0 points Most recent by Sergey_Cherepan_1 January 2021General Discussion
The number of unused projections is not displayed

Answered yamakawa 2.4K views 4 comments 0 points Most recent by yamakawa January 2021General Discussion
How to find out all the tables with no data.

Answered ✓ SK21 3K views 5 comments 0 points Most recent by Jim_Knicely January 2021General Discussion
Need to retrieve particular string from all tables and get table names

Answered ✓ SK21 1.9K views 3 comments 0 points Most recent by mosheg December 2020General Discussion
Specifying length of VARCHAR

Answered Pieter_Sheth-Vo 5.6K views 8 comments 0 points Most recent by vivekbarad December 2020General Discussion
Is there a better way to export data from a very big vertica table to flatfile?

Answered sri_vtca 1.7K views 2 comments 0 points Most recent by poojan December 2020General Discussion
Slow query execution

yamakawa 2.9K views 5 comments 0 points Most recent by yamakawa December 2020General Discussion
memory_allocated_bytes from "v_monitor"."query_plan_profiles" always NULL : A bug?

Answered Sudhakar_B 3.3K views 6 comments 0 points Most recent by SruthiA December 2020General Discussion
Exposing Vertica log as external table for SQL access? Does anyone have a script with log parser?

Sudhakar_B 1.4K views 3 comments 0 points Most recent by Sudhakar_B December 2020General Discussion
erro in cast array

Answered ✓ reli 3.2K views 4 comments 0 points Most recent by SergeB December 2020General Discussion
SYSQUERY_POOL_SPILL event in dc_execution engine events: Any concerns?

Answered ✓ Sudhakar_B 3.4K views 6 comments 0 points Most recent by Sudhakar_B December 2020General Discussion
Same query executes 2 times in a row

Answered ✓ zadvovl 2.6K views 4 comments 0 points Most recent by zadvovl December 2020General Discussion
How to generate an error

Answered ✓ yamakawa 1.9K views 3 comments 0 points Most recent by yamakawa December 2020General Discussion
Fill Missing Dates for Each Group in an existing table

Answered ✓ JayantaB 1.9K views 2 comments 0 points Most recent by JayantaB December 2020General Discussion
Default permissions for vertica.log

Answered ivan 2.4K views 4 comments 0 points Most recent by ivan December 2020General Discussion
Vertica bulk upload failing from R

Answered mvishruth 1.8K views 1 comment 0 points Most recent by mosheg December 2020General Discussion
What is difference purge() and DO_TM_TASK('mergeout') ?

Answered HyeontaeJu 1.3K views 1 comment 0 points Most recent by mosheg December 2020General Discussion
"No transaction in progress" message occured in error_messages table frequently..

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

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

mqazi 1.5K views 2 comments 0 points Most recent by mqazi December 2020General Discussion
How to check table is exist?

Answered HyeontaeJu 3.2K views 3 comments 0 points Most recent by mosheg December 2020General Discussion
How can i fix the message "Monitoring Activities requires the database user have the DBADMIN role"

Answered HyeontaeJu 2.5K views 4 comments 0 points Most recent by Jim_Knicely December 2020General Discussion
How to grant superuser grants to user?

Answered HyeontaeJu 1K views 1 comment 0 points Most recent by Jim_Knicely December 2020General Discussion

General Discussion

Discussion List