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 329 views 5 comments 0 points Most recent by Jim_Knicely January 2General Discussion
What authentication does dbadmin need to startup a cluster?

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

Accepted Answer reli 336 views 3 comments 0 points Most recent by Sergey_Cherepan_1 January 22General Discussion
Need to retrieve particular string from all tables and get table names

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

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

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

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

Answered Pieter_Sheth-Vo 637 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 322 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 354 views 6 comments 0 points Most recent by SruthiA December 2020General Discussion
Java Framework for Network Application

Answered aartiyadav 331 views 4 comments 0 points Most recent by karansharma August 25General Discussion
SYSQUERY_POOL_SPILL event in dc_execution engine events: Any concerns?

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

Accepted Answer reli 644 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 451 views 2 comments 0 points Most recent by JayantaB December 2020General Discussion
How to generate an error

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

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

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

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

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

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

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

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

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

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