Vertica Forum

Discussion List

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

  Announcement 344 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 661 views 2 comments 5 points Most recent by Vertiguy March 29Vertica Forum
• REMINDER: Tell us about your experience with Vertica: A Quick Survey

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

  Announcement 261 views 0 comments 0 points Started by SarahL January 4 Vertica Forum
• ERROR: Unavailable: lock table for query

  5 views 2 comments 0 points Most recent by Ben_Vandiver July 19Vertica Forum
• Load data to Vertica regular table through Kafka

  Answered 14 views 7 comments 0 points Most recent by YangXu July 19Vertica Forum
• Query

  34 views 6 comments 0 points Most recent by JunaidKhan July 19Vertica Forum
• How many seconds since midnight?

  8 views 0 comments 0 points Started by SarahL July 19 Vertica Tips
• fastest way to put together 100+ columns in a single table

  26 views 2 comments 0 points Most recent by phil2 July 19Vertica Forum
• Changing the Default Database Time Zone

  10 views 0 comments 0 points Started by SarahL July 18 Vertica Tips
• Keepalive settings for AWS Network Load Balancer

  10 views 0 comments 0 points Started by SarahL July 18 Vertica Tips
• Vertica connector for Spark from Kerberos enabled to non Kerberos enabled Vertica cluster

  13 views 7 comments 0 points Most recent by MSQ July 18Vertica Forum
• Management Console hangs in Vertica CE VM

  2 views 3 comments 0 points Most recent by s_crossman July 18Vertica Forum
• COST_STATUS in EXPLAIN

  3 views 1 comment 0 points Most recent by Ben_Vandiver July 17Vertica Forum
• Check out Joy King's new blog on IOT and smart metering on the Vertica blog

  3 views 0 comments 0 points Started by SarahL July 17 Vertica Forum
• Counting Days, Week Days and Weekend Days Across the Years

  2 views 0 comments 0 points Started by SarahL July 17 Vertica Tips
• Synonyms

  1 view 0 comments 0 points Started by SarahL July 16 Vertica Tips
• why does incremental DBD proposes existing projections

  3 views 0 comments 0 points Started by Isabelle_Vela July 16 Vertica Forum
• Geospatial Functions Vertica St_GeomFromText

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

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

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

  1 view 0 comments 0 points Started by Anand July 13 Vertica Forum
• Uploading images into Vertica

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

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

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

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

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

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

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

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

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

  23 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 52 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 111 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?

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

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

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

  21 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

  1 view 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 11 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

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

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

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

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

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

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

  11 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).

  11 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

  21 views 0 comments 0 points Started by JaredZh June 22 Vertica Forum