General Discussion

Archives for May 2020

Parent child table segmentation

Answered ✓ sknair 3.2K 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 6K views 4 comments 0 points Most recent by marcothesane May 2020General Discussion
Vertica 5 documentation

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

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

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

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

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

Answered ✓ maks 15.1K 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 10.4K views 8 comments 0 points Most recent by mosheg May 2020General Discussion
flex table to devide into partitions

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

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

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

Answered shashank_p 13.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 1.2K 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 2.1K views 1 comment 0 points Most recent by mosheg May 2020General Discussion
Enforcing Password complexity for user logins - how to check?

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

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

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

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

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

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

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

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

Answered ✓ cp00634326 3.2K 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 8.8K views 6 comments 0 points Most recent by VivJain December 2021General Discussion
when license message goes off

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

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

Answered ✓ akissay 3.3K 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 8.8K views 4 comments 0 points Most recent by dsahu123 May 2020General Discussion
COPY data from S3 using IAM_ROLE

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