Vertica Forum

Discussion List

• BEFORE YOU UPGRADE TO VERTICA 9.1: Fix unsafe buddy projections

  Announcement 538 views 9 comments 0 points Most recent by mleuchtenburg April 26Vertica Forum
• Micro Focus Vertica S/W Support: How to Move from My.Vertica.com to Software Support Online (SSO)

  Announcement 692 views 2 comments 5 points Most recent by Vertiguy March 29Vertica Forum
• REMINDER: Tell us about your experience with Vertica: A Quick Survey

  Announcement 127 views 0 comments 0 points Started by SarahL February 13 Vertica Forum
• Vertica Test Results for Operating System Patches for Meltdown and Spectre Security Flaws

  Announcement 700 views 2 comments 0 points Most recent by mleuchtenburg January 24Vertica Forum
• IMPORTANT: What you need to know about hardware security flaws

  Announcement 273 views 0 comments 0 points Started by SarahL January 4 Vertica Forum
• rename database

  26 views 2 comments 0 points Most recent by gyoung 2:04AMVertica Forum
• Enforce encryption

  18 views 3 comments 0 points Most recent by SruthiA October 15Vertica Forum
• Vertica and OBIEE 12c

  14 views 3 comments 0 points Most recent by siddyash October 15Vertica Forum
• Special Date/Time Formatting

  10 views 0 comments 0 points Started by Jim_Knicely October 15 Vertica Tips
• Update Management Console Vertica IP to other node without loosing the messages & logs

  Accepted Answer 5 views 1 comment 0 points Most recent by robinem October 12Vertica Forum
• How to use live aggregated projection ?

  Question 15 views 0 comments 0 points Started by bdpanta October 12 Vertica Forum
• Change the VSQL Result Set Border

  16 views 0 comments 0 points Started by Jim_Knicely October 11 Vertica Tips
• JSON Payload Parsing & Querying

  63 views 7 comments 0 points Most recent by martinc123 October 11Vertica Forum
• Database Designer

  244 views 11 comments 1 point Most recent by thiago_rodrigo October 10Vertica Forum
• Prejoin projection is deprecated > Flattened Tables

  23 views 1 comment 0 points Most recent by thiago_rodrigo October 10Vertica Forum
• Find Which System Tables Have a Particular Column Name

  6 views 0 comments 0 points Started by Jim_Knicely October 10 Vertica Tips
• Vertica - Export table with IDENTITY

  20 views 1 comment 0 points Most recent by marcothesane October 10Vertica Forum
• Setting Data Retention in Vertica

  13 views 1 comment 0 points Most recent by Jim_Knicely October 10Vertica Forum
• DbVisualizer Free for Vertica Distribution Updates

  Announcement 10 views 0 comments 0 points Started by PhilM1 October 10 Vertica Forum
• Vertica Essentials 9.x ASP Exam registration

  24 views 1 comment 0 points Most recent by Jim_Knicely October 9Vertica Forum
• Vertica Learning Channel Playlist Videos

  21 views 0 comments 0 points Started by Jim_Knicely October 9 Vertica Forum
• Find Which Tables Have a Particular Column Name

  7 views 0 comments 0 points Started by Jim_Knicely October 9 Vertica Tips
• How to connect R to vertica

  1.4K views 4 comments 0 points Most recent by SruthiA October 9Vertica Forum
• SELECT all data such that a single-node query plan is maintained

  29 views 2 comments 0 points Most recent by gjorgjevski October 9Vertica Forum
• Database Storage - Raw and Compressed Size

  13 views 0 comments 0 points Started by Jim_Knicely October 8 Vertica Tips
• Vertica MC and CVE-2014-3625 - Directory traversal vulnerability in Pivotal Spring Framework

  9 views 0 comments 0 points Started by Neil_3 October 6 Vertica Forum
• Benchmark for Update Query

  13 views 0 comments 0 points Started by Kaito October 5 Vertica Forum
• Display Last SQL Run Time

  10 views 0 comments 0 points Started by Jim_Knicely October 4 Vertica Tips
• Renaming a View

  106 views 2 comments 0 points Most recent by Jim_Knicely October 4Vertica Tips
• Can't find the "DbVisualizer Free for Vertica" edition on Big Data Marketplace ...

  50 views 14 comments 0 points Most recent by Jim_Knicely October 3Vertica Forum
• Displaying the Administration Tools Process ID

  8 views 0 comments 0 points Started by Jim_Knicely October 3 Vertica Tips
• 9.1 Management console marketplace AMI?

  12 views 4 comments 0 points Most recent by jbuss October 3Vertica Forum
• DB Restore fails: IOError: Errno 2 No such file or directory

  19 views 1 comment 0 points Most recent by Jim_Knicely October 3Vertica Forum
• Backup restore failed: INTERNAL 5445: VIAssert(oidMap.count(depOid)) failed

  8 views 1 comment 0 points Most recent by Jim_Knicely October 3Vertica Forum
• Spark/Scala connecting to Vertica DB with jdbc is failling

  Answered 20 views 1 comment 0 points Most recent by Connyrt-emp1 October 2Vertica Forum
• Rotating Column Data Using SQL Analytics

  14 views 0 comments 0 points Started by Jim_Knicely October 2 Vertica Tips
• regarding data model

  31 views 2 comments 0 points Most recent by punnareddy October 2Vertica Forum
• Install Vertica 8.0 on CentOS 7.5

  14 views 0 comments 0 points Started by andre_silva October 1 Vertica Forum
• Return Zero Instead of NULL

  11 views 0 comments 0 points Started by Jim_Knicely October 1 Vertica Tips
• I have a situation

  21 views 1 comment 0 points Most recent by Jim_Knicely October 1Vertica Forum
• Parser for syslog.

  11 views 0 comments 0 points Started by Kaito October 1 Vertica Forum
• SCD type 1 with merge table data

  22 views 2 comments 0 points Most recent by marcothesane September 28Vertica Forum
• Using RSQUARED function over multiple data sets

  Answered 15 views 1 comment 0 points Most recent by ekilby September 27Vertica Forum
• Limit Memory Usage of Vertica

  24 views 2 comments 0 points Most recent by anshulupadhyay September 27Vertica Forum
• Column "‘mergeout’" does not exist?

  Accepted Answer 16 views 1 comment 0 points Most recent by wardmw September 27Vertica Forum
• T lock on a table X Lock timeout on another table.

  52 views 6 comments 0 points Most recent by matt92 September 27Vertica Forum
• Unable to close session "shutdown error: Transport endpoint is not connected"

  569 views 3 comments 0 points Most recent by ashendra September 26Vertica Forum
• How to force a session to end when close_session does not work.

  1.4K views 8 comments 0 points Most recent by ashendra September 26Vertica Forum
• Vertica and OBIEE 12c

  9 views 0 comments 0 points Started by mpedroso September 26 Vertica Forum
• Display the Current Statement Number Within the Current Transaction

  13 views 0 comments 0 points Started by Jim_Knicely September 26 Vertica Tips
• Class Not Found - com.vertica.spark.datasource.DefaultSource

  Answered 23 views 1 comment 0 points Most recent by Jim_Knicely September 26Vertica Forum
• Getting only delta from the Vertica DB using Spark (Java)

  Question 10 views 0 comments 0 points Started by bala_8383 September 25 Vertica Forum
• Spark/Scala using jdbc to connect to Vertica DB is failling

  Answered 27 views 2 comments 0 points Most recent by nrodriguez September 25Vertica Forum
• Need to compare column value and identify outlier records which shows huge spike in data

  21 views 1 comment 0 points Most recent by Jim_Knicely September 25Vertica Forum
• Update from Vertica v8.0.1-1 to Vertica v9.1.1-1

  16 views 0 comments 0 points Started by tumchik September 25 Vertica Forum