Vertica Forum

Discussion List

• Single Sign-On for Support: New Login for Passport Users

  Announcement 87 views 0 comments 0 points Started by SarahL February 27 Vertica Forum
• Before You Upgrade to Vertica 9.1 or 9.2

  Announcement 562 views 6 comments 0 points Most recent by hdk0310 December 2018Vertica Forum
• Micro Focus Vertica S/W Support: How to Move from My.Vertica.com to Software Support Online (SSO)

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

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

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

  Announcement 381 views 0 comments 0 points Started by SarahL January 2018 Vertica Forum
• Determine Number of Kafka To vertica Load jobs to run at any time.

  9 views 0 comments 0 points Started by esangrame March 22 Vertica Forum
• Conversion between timestamp and timestamptz

  9 views 0 comments 0 points Started by savioceg March 22 Vertica Forum
• Building FilterFunctions in Vertica 9.1.0-1 Fails

  92 views 2 comments 0 points Most recent by Sergey_Cherepan_1 March 20Vertica Forum
• Simulate NULLS FIRST and NULLS LAST in the ORDER BY Clause

  16 views 0 comments 0 points Started by Jim_Knicely March 20 Vertica Tips
• Using sed to Handle Empty String NULL Values Enclosed in Control Characters

  14 views 0 comments 0 points Started by Jim_Knicely March 20 Vertica Tips
• Vertica monitoring user to access all system tables

  23 views 2 comments 0 points Most recent by hdk0310 March 20Vertica Forum
• admintools returns "Bus error" message

  19 views 1 comment 0 points Most recent by SruthiA March 19Vertica Forum
• Using COPY FILLER to Handle Empty String NULL Values Enclosed in Control Characters

  22 views 0 comments 0 points Started by Jim_Knicely March 19 Vertica Tips
• VerticaError connection attempt failed:could not send SSL negotiation packet: Socket is not connect

  Answered 25 views 2 comments 0 points Most recent by mpedroso March 17Vertica Forum
• Ran out of WOS memory during LOAD

  33 views 2 comments 0 points Most recent by Jim_Knicely March 15Vertica Forum
• LDAP Intergration

  38 views 1 comment 0 points Most recent by chaima March 15Vertica Forum
• Calculate the Catalog

  28 views 0 comments 0 points Started by mytamhuyet March 15 Vertica Forum
• Calculate the Catalog Size in Memory on Each Node

  26 views 0 comments 0 points Started by mytamhuyet March 15 Vertica Forum
• Tracking the Current Transaction Start Date and Time

  28 views 0 comments 0 points Started by Jim_Knicely March 14 Vertica Tips
• increasing thread_count on Vertica

  32 views 0 comments 0 points Started by jumanji March 14 Vertica Forum
• Question about error "join inner did not fit in memory"

  3.7K views 12 comments 0 points Most recent by Jim_Knicely March 14Vertica Forum
• Inserting into a table backed by pre-join projection HASH JOIN problem

  50 views 2 comments 0 points Most recent by Jim_Knicely March 14Vertica Forum
• Time taken to complete Copycluster in Vertica?

  36 views 3 comments 0 points Most recent by Sharon_Cutter March 13Vertica Forum
• Simple ASCII Charting Using SQL

  24 views 0 comments 1 point Started by Jim_Knicely March 13 Vertica Tips
• Vertica DB performance question

  47 views 1 comment 0 points Most recent by qinchaofeng March 13Vertica Forum
• Set All User’s Default Roles to All of their Granted Roles

  39 views 1 comment 1 point Most recent by qinchaofeng March 13Vertica Tips
• 【Share my blog】

  34 views 0 comments 0 points Started by qinchaofeng March 13 Vertica Forum
• Select by date range and projections for best performance

  Answered 54 views 2 comments 0 points Most recent by qinchaofeng March 13Vertica Forum
• Explanation on the projections <table_name>_pk

  24 views 0 comments 0 points Started by Isabelle_Vela March 12 Vertica Forum
• Is it safe to use -F option on start_db of admintools?

  Accepted Answer 75 views 13 comments 0 points Most recent by Sharon_Cutter March 12Vertica Forum
• Vertica ERROR: join inner did not fit in memory

  Answered 33 views 3 comments 0 points Most recent by Sharon_Cutter March 12Vertica Forum
• Setting config parameter does not work

  20 views 1 comment 0 points Most recent by s_crossman March 12Vertica Forum
• Arithmetic Bit-shifting

  21 views 0 comments 0 points Started by Jim_Knicely March 12 Vertica Tips
• most efficient way to insert huge amount of data into vertica

  37 views 0 comments 0 points Started by phil2 March 12 Vertica Forum
• super projections

  Answered 58 views 1 comment 0 points Most recent by Nithesh March 12Vertica Forum
• Convert an Integer to a Binary

  31 views 0 comments 0 points Started by Jim_Knicely March 11 Vertica Tips
• Join Big tables (Pre-Proj, Flattened tables, ...)

  70 views 11 comments 0 points Most recent by verban March 11Vertica Forum
• partitions limit per projection

  38 views 2 comments 0 points Most recent by nirka March 10Vertica Forum
• extract schema from parquet file

  29 views 0 comments 0 points Started by ningzhong March 8 Vertica Forum
• Avoid Query going to other Nodes if segment upper and lower bound is provided.

  72 views 8 comments 0 points Most recent by esangrame March 8Vertica Forum
• Clock syncrhonisation limits in a cluster?

  Answered 28 views 1 comment 0 points Most recent by Jim_Knicely March 7Vertica Forum
• Spark Connector Read

  64 views 2 comments 0 points Most recent by Connyrt-emp1 March 7Vertica Forum
• Why some queries don't appear in Vertica's query history

  40 views 1 comment 0 points Most recent by Jim_Knicely March 7Vertica Forum
• Are These Two String Values Like Each Other?

  39 views 0 comments 0 points Started by Jim_Knicely March 7 Vertica Tips
• Self join not permitted in Updates

  404 views 6 comments 0 points Most recent by parthmalhan March 7Vertica Forum
• Why is Vertica Management Console reporting my TZ is not set

  Question 31 views 0 comments 0 points Started by BobBryan March 7 Vertica Forum
• Identify a Tables Primary Key Columns

  30 views 0 comments 0 points Started by Jim_Knicely March 6 Vertica Tips
• Integration of Vertica with Hive LLAP

  42 views 3 comments 0 points Most recent by kguan March 6Vertica Forum
• Removed a node from a cluster when the node no longer exists.

  48 views 1 comment 0 points Most recent by Jim_Knicely March 6Vertica Forum
• Can we load Excel (.xlsx or .xls) file directly to Vertica Table?

  44 views 2 comments 0 points Most recent by haroon March 6Vertica Forum
• Kafka streaming to Flex table with columns

  Answered 59 views 2 comments 0 points Most recent by mdkarkeys March 4Vertica Forum
• Customized join output

  57 views 2 comments 0 points Most recent by ManasaP March 4Vertica Forum
• manual in Germany

  42 views 0 comments 0 points Started by gaconvn March 2 Vertica Forum
• Revoke Access to Multiple System Tables from Multiple Users with a New Role

  39 views 0 comments 0 points Started by Jim_Knicely March 1 Vertica Tips
• Loading data Vertica to Vertica

  Accepted Answer 58 views 7 comments 0 points Most recent by scottpedersoli March 1Vertica Forum