Vertica Forum

Got questions? Use the Vertica forum to get expert advice and connect with other Vertica users. Looking for more? Check out our Vertica Community: https://my.vertica.com/big-data-analytics-community-content/

Table Schemas for Global and Local Temp Tables

Jim_Knicely 165 views 0 comments 0 points Started by Jim_Knicely May 8 Vertica Tips
Make Comparisons on Subqueries that Return Multiple Rows

Jim_Knicely 159 views 0 comments 0 points Started by Jim_Knicely May 8 Vertica Tips
Query to generate rows dynamically

Accepted Answer aniruddha20 357 views 6 comments 0 points Most recent by Jim_Knicely May 7Vertica Forum
Error while writing to vertica from spark using Vertica spark connector

Arunrajva 368 views 10 comments 0 points Most recent by Arunrajva May 4Vertica Forum
Export Parquet files to HDFS

elchen 174 views 2 comments 0 points Most recent by SruthiA May 3Vertica Forum
Determine Number of Kafka To vertica Load jobs to run at any time.

esangrame 273 views 1 comment 0 points Most recent by esangrame May 3Vertica Forum
Stats not reflected in System tables

esangrame 173 views 3 comments 0 points Most recent by esangrame May 2Vertica Forum
Restoring Vertica to a cluster with different IPs

bergman 171 views 1 comment 0 points Most recent by DaveT May 2Vertica Forum
not able to copy the .gz files from s3 to vertca

sarojrout 194 views 1 comment 0 points Most recent by DilipKumar May 2Vertica Forum
timestamptz time is off by one hour

bf4688 161 views 0 comments 0 points Started by bf4688 May 1 Vertica Forum
ROLLBACK 3399: vsql Create library failure in Udx Error

Learner55 375 views 4 comments 0 points Most recent by SruthiA May 1Vertica Forum
Vertica strings_packge( and group_concat) Upgrade

yardenbar 382 views 4 comments 0 points Most recent by AnitaM77 May 1Vertica Forum
std::bad_alloc Loading SDK Sample Libraries

jpotts 795 views 12 comments 0 points Most recent by phil2 April 30Vertica Forum
Function reference automatically replaced with formula in view code - how to prevent this?

Answered pkosew 169 views 2 comments 0 points Most recent by pkosew April 29Vertica Forum
Create a Python UDx to Order a List of Values

Jim_Knicely 186 views 1 comment 1 point Most recent by bishal April 27Vertica Tips
Eon Mode no. of Shards effect on performance

bishal 177 views 0 comments 0 points Started by bishal April 27 Vertica Forum
Sentiment Analysis Error

AgustinaMonge 180 views 4 comments 0 points Most recent by AgustinaMonge April 25Vertica Forum
9.2 support of RH 7.6

alangano 183 views 1 comment 0 points Most recent by Jim_Knicely April 25Vertica Forum
9.2 support of RH 7.6

alangano 170 views 0 comments 0 points Started by alangano April 25 Vertica Forum
Not able to remove the node from DB

sshamsudheen 235 views 3 comments 0 points Most recent by sshamsudheen April 25Vertica Forum
copycluster help/advice?

usao 191 views 1 comment 0 points Most recent by Jim_Knicely April 24Vertica Forum
parsing vertica sql dialect

phil2 226 views 5 comments 0 points Most recent by phil2 April 24Vertica Forum
replication - files or queries ?

vcarusi 179 views 4 comments 0 points Most recent by vcarusi April 24Vertica Forum
maximum number of ROS containers

vcarusi 223 views 4 comments 0 points Most recent by vcarusi April 23Vertica Forum
How to set file size limit for user?

Answered johaidii12 203 views 4 comments 0 points Most recent by johaidii12 April 23Vertica Forum
Displaying the Vertica Code Name

Jim_Knicely 191 views 0 comments 0 points Started by Jim_Knicely April 22 Vertica Tips
Error in vbr copycluster

AndreAlmeida 230 views 1 comment 0 points Most recent by Afe April 22Vertica Forum
[Vertica][VJDBC](5569) ERROR:Either column "update_ts" does not exist or table alias "update_ts

esangrame 370 views 2 comments 0 points Most recent by Jim_Knicely April 22Vertica Forum
Forcing a Merge Join

Jim_Knicely 238 views 0 comments 1 point Started by Jim_Knicely April 19 Vertica Tips
Descending Sequences

Jim_Knicely 191 views 0 comments 0 points Started by Jim_Knicely April 19 Vertica Tips
I am getting decompression OK, trailing garbage ignored Error

rahul_vertica_infy 314 views 2 comments 0 points Most recent by rahul_vertica_infy April 18Vertica Forum
Display Session Sequence Cached Values Remaining

Jim_Knicely 198 views 0 comments 0 points Started by Jim_Knicely April 17 Vertica Tips
Is this a Leap Year?

Jim_Knicely 209 views 0 comments 0 points Started by Jim_Knicely April 16 Vertica Tips
Data Distribution in nodes

saipasupulati 252 views 2 comments 0 points Most recent by RaghavA April 16Vertica Forum
How Old Am I (In Months)?

Jim_Knicely 215 views 0 comments 0 points Started by Jim_Knicely April 16 Vertica Tips
Unable to use TransformFunction in vertica_sdk.

Answered rajdeepprmficon 299 views 1 comment 0 points Most recent by SruthiA April 15Vertica Forum
Remove a node from cluster permanently

markdane22 244 views 1 comment 0 points Most recent by SruthiA April 15Vertica Forum
Executing Vkconfig without having access to vertica Nodes..

Answered esangrame 220 views 4 comments 0 points Most recent by Jim_Knicely April 13Vertica Forum
DB Restore fails: IOError: Errno 2 No such file or directory

glassfish 403 views 4 comments 0 points Most recent by Jim_Knicely April 12Vertica Forum
Time Zone - DST

Answered MaorFrid 279 views 1 comment 0 points Most recent by vcarusi April 12Vertica Forum
ANALYZE_STATISTICS - CPU/memory consumption

vcarusi 282 views 15 comments 0 points Most recent by vcarusi April 12Vertica Forum
vertica 9.2 SIGFPE

vcarusi 239 views 15 comments 0 points Most recent by vcarusi April 12Vertica Forum
Display the Vertica Process Memory Allocated

Jim_Knicely 245 views 0 comments 0 points Started by Jim_Knicely April 10 Vertica Tips
[Vertica][Support] (40470) Conversion error at column 5 and row 1: Numeric value out of range..

Accepted Answer mpedroso 241 views 2 comments 0 points Most recent by marcothesane April 10Vertica Forum
vbr --setupconfig Error

Answered AndreAlmeida 256 views 2 comments 0 points Most recent by AndreAlmeida April 9Vertica Forum
Display Database Statement Counts by Type

Jim_Knicely 230 views 0 comments 1 point Started by Jim_Knicely April 9 Vertica Tips
Function to retrieve city and country from lat and lon

savioceg 219 views 0 comments 0 points Started by savioceg April 8 Vertica Forum
Vertica Essentials 9.x ASP Exam registration

elghali 424 views 6 comments 0 points Most recent by Jim_Knicely April 8Vertica Forum
Slow Performance on Flattened Facts Table

Answered AnuskaWR 256 views 2 comments 0 points Most recent by AnuskaWR April 8Vertica Forum
Use Time Series Analytics to Generate a List of Dates at a Specific Start Date

Jim_Knicely 251 views 0 comments 0 points Started by Jim_Knicely April 8 Vertica Tips