Vertica Forum

Discussion List

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

  Announcement 346 views 9 comments 0 points Most recent by Tom June 19Vertica Forum
• Micro Focus Vertica S/W Support: How to Move from My.Vertica.com to Software Support Online (SSO)

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

  Announcement 109 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 660 views 2 comments 0 points Most recent by mleuchtenburg January 24Vertica Forum
• IMPORTANT: What you need to know about hardware security flaws

  Announcement 266 views 0 comments 0 points Started by SarahL January 4 Vertica Forum
• Geospatial Functions Vertica St_GeomFromText

  19 views 2 comments 0 points Most recent by elghali July 14Vertica Forum
• how to find data type of each record in table

  Answered 35 views 3 comments 0 points Most recent by Jim_Knicely July 13Vertica Forum
• How to trim leading 0s

  Answered 15 views 2 comments 0 points Most recent by vvasireddy9 July 13Vertica Forum
• how to see table data in tabular grid form

  5 views 0 comments 0 points Started by Anand July 13 Vertica Forum
• Query

  29 views 5 comments 0 points Most recent by Jim_Knicely July 13Vertica Forum
• Uploading images into Vertica

  11 views 0 comments 0 points Started by dhenriquez July 11 Vertica Forum
• Permission denied. admintools.conf.lock

  46 views 3 comments 0 points Most recent by Avihaim July 11Vertica Forum
• Windows ODBC Dirver connection Docs missing

  18 views 1 comment 0 points Most recent by Jim_Knicely July 11Vertica Forum
• Strange Error message during query

  13 views 3 comments 0 points Most recent by GayleE20 July 10Vertica Forum
• Connecting Vertica to R through JDBC

  39 views 5 comments 0 points Most recent by shubhamb July 8Vertica Forum
• Hex value of database varchar field / removing non utf-8 characters

  33 views 3 comments 0 points Most recent by Jim_Knicely July 7Vertica Forum
• Kafka scheduler

  767 views 9 comments 0 points Most recent by SruthiA July 6Vertica Forum
• Changing MC authentication type post-installation

  14 views 1 comment 0 points Most recent by SruthiA July 6Vertica Forum
• problems uploading queries using the designer

  12 views 2 comments 0 points Most recent by joracab July 6Vertica Forum
• Vertica licensing

  26 views 1 comment 0 points Most recent by Jim_Knicely July 6Vertica Forum
• Add a randomint to a kafka load stream

  22 views 1 comment 0 points Most recent by cbonf63 July 6Vertica Forum
• ROS per node per partition

  Answered 51 views 9 comments 0 points Most recent by Sergey_T July 4Vertica Forum
• GROUPING() on current time in HAVING clause in subquery and outer query grouping

  Accepted Answer 117 views 4 comments 0 points Most recent by Jim_Knicely July 4Vertica Forum
• [Vertica][VJDBC](3007) ERROR: DDL statement interfered with this statement

  1.6K views 9 comments 0 points Most recent by Jim_Knicely July 3Vertica Forum
• Why does sql query give more results than expected?

  17 views 1 comment 0 points Most recent by Jim_Knicely July 3Vertica Forum
• What's wrong with our memory settings?

  34 views 2 comments 0 points Most recent by pm2018 July 3Vertica Forum
• how to copy a file from Host machine to vertica VM

  15 views 2 comments 0 points Most recent by s_crossman July 3Vertica Forum
• use same vertica vm after OS change

  20 views 2 comments 0 points Most recent by Anand July 2Vertica Forum
• Upgrading from vertica 8.0 to 9.0 - Machine learning package fails to install

  31 views 2 comments 0 points Most recent by Arvind_Sugurr June 29Vertica Forum
• Announcing Vertica in Eon Mode for Amazon Linux 2, now available in AWS Marketplace

  10 views 0 comments 1 point Started by SarahL June 28 Vertica Forum
• can not create an access policy. keep getting "Cannot reserve JVM while holding global locks"

  Answered 13 views 1 comment 0 points Most recent by Ben_Vandiver June 28Vertica Forum
• Changing the Data Type of a Column in an External Table

  21 views 0 comments 0 points Started by SarahL June 28 Vertica Tips
• Partition Swap

  9 views 2 comments 0 points Most recent by LazyDBA June 27Vertica Forum
• NULL Equals NULL with NULLSEQUAL

  14 views 0 comments 0 points Started by SarahL June 27 Vertica Tips
• Limiting a User’s Open Session Count

  19 views 0 comments 0 points Started by SarahL June 27 Vertica Tips
• Disable Purge

  25 views 3 comments 0 points Most recent by Jim_Knicely June 27Vertica Forum
• Create Type command in Vertica

  24 views 2 comments 0 points Most recent by he437580 June 26Vertica Forum
• fromExprRelids.size()

  16 views 2 comments 0 points Most recent by vcarusi June 26Vertica Forum
• Vertica Quick Tip: Handling NULL Equality in a WHERE Clause

  20 views 0 comments 0 points Started by SarahL June 25 Vertica Tips
• Last Good Epoch/Ancient History Mark not advancing

  1.7K views 11 comments 0 points Most recent by Jim_Knicely June 25Vertica Forum
• Restore Failed (Password file is not read/write protected).

  18 views 1 comment 0 points Most recent by Jim_Knicely June 25Vertica Forum
• Technical white paper: Benchmarks prove you need an analytical database for Big Data

  30 views 0 comments 0 points Started by JaredZh June 22 Vertica Forum
• Vertica connector for Spark from Kerberos enabled to non Kerberos enabled Vertica cluster

  18 views 6 comments 0 points Most recent by nrodriguez June 21Vertica Forum
• Be Careful with the Sequence CACHE Value

  16 views 0 comments 0 points Started by SarahL June 21 Vertica Tips
• Merge on table having Identity Column

  23 views 3 comments 0 points Most recent by Jim_Knicely June 20Vertica Forum
• HOW TO INSTALL VERTICA S3EXPORT -- Data movement from vertica to S3

  7 views 1 comment 0 points Most recent by Jim_Knicely June 20Vertica Forum
• dump varbinary data using VSQL

  26 views 6 comments 0 points Most recent by Jim_Knicely June 20Vertica Forum
• Faster CTAS Statements

  12 views 0 comments 0 points Started by SarahL June 20 Vertica Tips
• Analyze Statistics at the Schema Level (Part 2): Quick Tip

  6 views 0 comments 0 points Started by SarahL June 20 Vertica Tips
• Silent Installation for Vertica Driver (ODBC)

  25 views 6 comments 0 points Most recent by Kaito June 20Vertica Forum
• How to get exact size of a table??

  715 views 8 comments 0 points Most recent by orahow June 19Vertica Forum
• Where to see query execution error detail

  17 views 2 comments 0 points Most recent by Anand June 19Vertica Forum
• Restore database in another directory

  13 views 2 comments 0 points Most recent by andre_silva June 19Vertica Forum
• view all query log - v_monitor.query_profiles

  16 views 2 comments 0 points Most recent by nirka June 18Vertica Forum