General Discussion

Discussion channel for questions, answers, and conversations among Vertica users and employees.

Ask a Question

How to savely drop a column involved in a projection

Answered ✓ joergschaber 32.9K views 8 comments 0 points Most recent by joergschaber December 2021
Prior week

Answered ✓ slc1axj 11K views 4 comments 0 points Most recent by Jim_Knicely December 2021
[54000] ERROR: Cannot prepare statement - too many prepared statements

Answered ✓ joergschaber 21.5K views 8 comments 0 points Most recent by joergschaber December 2021
Merge Queries failing during node down

Answered SK21 20.5K views 8 comments 0 points Most recent by Hibiki December 2021
3 Node Vertica Cluster setup. Later 2 of the nodes FQDN extension modified hence cluster broken

Answered sistla 3.6K views 1 comment 0 points Most recent by Hibiki November 2021
Top 10 Re-fetches in Depot

Answered ✓ atomix 6K views 2 comments 0 points Most recent by atomix November 2021
How to call pandas_to_vertica insert error

Answered polakrish 6.1K views 1 comment 0 points Most recent by SruthiA November 2021
Need to start sending out daily reports, need guidance on which route to pursue

wrlesini 3.6K views 1 comment 0 points Most recent by Jim_Knicely November 2021
Why error occured When i use purge_table(<table_name>) in spring boot project?

Answered HyeontaeJu 4K views 1 comment 0 points Most recent by HyeontaeJu November 2021
Error when executing a stored procedure

Answered ✓ ramon_perea 24.3K views 6 comments 0 points Most recent by ramon_perea November 2021
Long running partition reorganization interferes with other operations

Answered ✓ ftobin 8.5K views 3 comments 0 points Most recent by ftobin November 2021
Does the copy_table function automatically commit a transaction to the original table?

Answered HyeontaeJu 6K views 2 comments 0 points Most recent by mosheg November 2021
Is it possible to manually lock and release a specific table?

Answered HyeontaeJu 3.6K views 1 comment 0 points Most recent by Jim_Knicely November 2021
Base85 Encoding using built-in Vertica SQL functions

verticauser810 8.6K views 3 comments 0 points Most recent by verticauser810 November 2021
Vertica cannot be started with verticad command after EncryptSpreadComm parameter is set

raulk89 3.9K views 1 comment 0 points Most recent by raulk89 November 2021
Query to select first row based on column with duplicates

Answered ✓ slc1axj 13.9K views 3 comments 0 points Most recent by Jim_Knicely November 2021
<FATAL> {SessionRun} 57V03/5785: Cluster Status Request by

ZaphodB 4.6K views 1 comment 0 points Most recent by raulk89 November 2021
dbadmin account Password Expiration

Answered ✓ verban 30.5K views 12 comments 0 points Most recent by verban November 2021
Vertica management console configuration

raulk89 6K views 2 comments 0 points Most recent by raulk89 November 2021
Last day of last completed quarter

Answered ✓ pratheek238 11K views 4 comments 0 points Most recent by pratheek238 November 2021
How can I get a Vertica community Edition software Download link.

Answered neerajsharmans12 3.9K views 1 comment 0 points Most recent by Hibiki November 2021
I can't download Vertica Community Edition

Answered rvazsilva 3.7K views 1 comment 0 points Most recent by Hibiki November 2021
How do I PIVOT in Vertica

Slaagh 40K views 9 comments 0 points Most recent by marcothesane November 2021
How to insert/select varbinary as byte[] using ADO.NET

Answered ✓ joergschaber 10.4K views 3 comments 0 points Most recent by Hibiki November 2021
eon performance

Answered vcarusi 10.9K views 4 comments 0 points Most recent by vcarusi November 2021
Is there a way to run the Vertica CE docker image as a Pod in k8s?

Answered ✓ annayan1 28.5K views 11 comments 0 points Most recent by annayan1 November 2021
Parquet Export and Import when Columns are in Different Order

Answered ✓ avi120 16.5K views 6 comments 0 points Most recent by avi120 November 2021
Which query is faster, select count(*) or count(pk)?

Answered HyeontaeJu 3.6K views 1 comment 0 points Most recent by verban November 2021
Partition reorganize percent stuck on 99

ChenSha 4.7K views 1 comment 1 point Most recent by ftobin November 2021
Management Console : Could not establish a Connection with the agent

Answered DbaIM 8.4K views 3 comments 0 points Most recent by SruthiA November 2021

Ask a Question

General Discussion

Discussion List