Welcome to the Vertica Forum

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

How to find out all the tables with no data.

Accepted Answer SK21 357 views 5 comments 0 points Most recent by Jim_Knicely January 2021General Discussion
What authentication does dbadmin need to startup a cluster?

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

Accepted Answer reli 348 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

Accepted Answer SK21 333 views 3 comments 0 points Most recent by mosheg December 2020General Discussion
The number of unused projections is not displayed

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

Accepted Answer reli 615 views 18 comments 0 points Most recent by Sergey_Cherepan_1 January 2021General Discussion
Specifying length of VARCHAR

Answered Pieter_Sheth-Vo 753 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 321 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 352 views 6 comments 0 points Most recent by SruthiA December 2020General Discussion
SYSQUERY_POOL_SPILL event in dc_execution engine events: Any concerns?

Accepted Answer Sudhakar_B 400 views 6 comments 0 points Most recent by Sudhakar_B December 2020General Discussion
erro in cast array

Accepted Answer reli 662 views 4 comments 0 points Most recent by SergeB December 2020General Discussion
Fill Missing Dates for Each Group in an existing table

Accepted Answer JayantaB 498 views 2 comments 0 points Most recent by JayantaB December 2020General Discussion
How to generate an error

Accepted Answer yamakawa 314 views 3 comments 0 points Most recent by yamakawa December 2020General Discussion
Vertica bulk upload failing from R

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

Accepted Answer zadvovl 403 views 4 comments 0 points Most recent by zadvovl December 2020General Discussion
Default permissions for vertica.log

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

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

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

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

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

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

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

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