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 May 2020

Parent child table segmentation

Answered ✓ sknair 2.1K views 2 comments 1 point Most recent by sknair June 2020General Discussion
How can I get only date (excluding timestamp ) without changing timezone from timestamptz column .

Answered soumitrab 3.8K views 4 comments 0 points Most recent by marcothesane May 2020General Discussion
Vertica 5 documentation

Answered coco 4.7K views 6 comments 0 points Most recent by LenoyJ May 2020General Discussion
high availability check on Vertica 5

Answered coco 1.4K views 1 comment 0 points Most recent by Vertica_Curtis May 2020General Discussion
Deleting duplicates from a table

Answered sverma28 1.5K views 1 comment 0 points Most recent by marcothesane May 2020General Discussion
vkconfig, warning in stream_events table

xtrimf 1.5K views 1 comment -1 point Most recent by xtrimf May 2020General Discussion
Tools to interpret vioperf and vnetperf results

Answered ✓ karthik 2.2K views 2 comments 0 points Most recent by karthik May 2020General Discussion
query in drop_partitions

Answered ✓ maks 9.2K views 12 comments 0 points Most recent by maks May 2020General Discussion
Any way to get query data dynamically while its executing.

Answered ✓ sahil_kumar 6.4K views 8 comments 0 points Most recent by mosheg May 2020General Discussion
flex table to devide into partitions

Answered maks 1.5K views 1 comment 0 points Most recent by sahil_kumar May 2020General Discussion
[54000] ERROR: Cannot prepare statement - too many prepared statements

Answered ✓ joergschaber 6.3K views 8 comments 0 points Most recent by joergschaber December 2021General Discussion
RES mem is higher then memory_inuse_kb

Answered ✓ Alok_Tiwari 3.1K views 11 comments 0 points Most recent by SruthiA May 17General Discussion
Delete specific word using regexp_replace

Answered shashank_p 8.5K views 10 comments 0 points Most recent by shashank_p June 2020General Discussion
Copy Data from HDFS to Vertica Fail. Error: SSL certificate problem.

sahil_kumar 1K views 0 comments 0 points Started by sahil_kumar May 2020 General Discussion
populating null rows in table column based on matching IDs via join or otherwise

Answered mpc83 1.5K views 1 comment 0 points Most recent by mosheg May 2020General Discussion
Enforcing Password complexity for user logins - how to check?

Answered Sankarmn 2.9K views 3 comments 0 points Most recent by Sankarmn June 2020General Discussion
to write nested json attributes in standart table

Answered maks 3.4K views 4 comments 0 points Most recent by DaveT May 2020General Discussion
Does vertica support ON CASCADE DELETE on foreign key constraint?

Answered ✓ rajatpaliwal86 2.3K views 3 comments 0 points Most recent by rajatpaliwal86 May 2020General Discussion
deleting data in tables

Answered maks 3K views 3 comments 0 points Most recent by marcothesane May 2020General Discussion
alter column with projections

Answered ✓ tdiprima 4.5K views 3 comments 0 points Most recent by marcothesane May 2020General Discussion
Unable to start DB

Answered LakshmiNarayan 12.3K views 16 comments 0 points Most recent by LakshmiNarayan June 2020General Discussion
How to delete unwanted host IP without bringing it up

Answered ✓ LakshmiNarayan 2.1K views 2 comments 0 points Most recent by LenoyJ May 2020General Discussion
restrict database size

Answered aleksss55 2.8K views 3 comments 0 points Most recent by marcothesane May 2020General Discussion
Week number giving 1 week less number

Answered ✓ cp00634326 2.1K views 2 comments 0 points Most recent by cp00634326 May 2020General Discussion
I am getting an error while loading data from Vertica to SSIS.

Answered RadhaParanthaman 5.6K views 6 comments 0 points Most recent by VivJain December 2021General Discussion
when license message goes off

Answered ✓ avoronin 2.1K views 3 comments 0 points Most recent by avoronin May 2020General Discussion
Vertica new cluster running slow

Answered ✓ davds 16.3K views 23 comments 0 points Most recent by mosheg May 2020General Discussion
Vertica backup with data compresion

Answered ✓ akissay 2.2K views 2 comments 0 points Most recent by akissay May 2020General Discussion
Failed to connect to Vertica from Spark using Spark Connector under ssl

Answered dsahu123 5.6K views 4 comments 0 points Most recent by dsahu123 May 2020General Discussion
COPY data from S3 using IAM_ROLE

rkg112 3.6K views 4 comments 0 points Most recent by SruthiA May 2020General Discussion

General Discussion

Discussion List