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.

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

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

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

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

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

Answered Pieter_Sheth-Vo 1.1K 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 361 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 434 views 6 comments 0 points Most recent by Sudhakar_B December 2020General Discussion
erro in cast array

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

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

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

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

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

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

Answered HyeontaeJu 785 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 401 views 4 comments 0 points Most recent by Vertica_Curtis January 2021General Discussion
What is difference purge() and DO_TM_TASK('mergeout') ?

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

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

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