Welcome to the Vertica Forum

Tips from the Team

Discussion List

• 
  Database Storage - Raw and Compressed Size

  Jim_Knicely 403 views 0 comments 0 points Started by Jim_Knicely October 2018
• 
  Display Last SQL Run Time

  Jim_Knicely 356 views 0 comments 0 points Started by Jim_Knicely October 2018
• 
  Renaming a View

  SarahL 498 views 2 comments 0 points Most recent by Jim_Knicely October 2018
• 
  Displaying the Administration Tools Process ID

  Jim_Knicely 316 views 0 comments 0 points Started by Jim_Knicely October 2018
• 
  Rotating Column Data Using SQL Analytics

  Jim_Knicely 319 views 0 comments 0 points Started by Jim_Knicely October 2018
• 
  Return Zero Instead of NULL

  Jim_Knicely 370 views 0 comments 0 points Started by Jim_Knicely October 2018
• 
  Display the Current Statement Number Within the Current Transaction

  Jim_Knicely 354 views 0 comments 0 points Started by Jim_Knicely September 2018
• 
  Changing the Owner of a View

  Jim_Knicely 497 views 0 comments 0 points Started by Jim_Knicely September 2018
• 
  Setting Variables on the VSQL Command Line

  Jim_Knicely 571 views 0 comments 0 points Started by Jim_Knicely September 2018
• 
  Enabling Inter-Node Spread Encryption

  Jim_Knicely 351 views 0 comments 0 points Started by Jim_Knicely September 2018
• 
  Exiting a DbVisualizer Script Following an Error

  Jim_Knicely 357 views 0 comments 0 points Started by Jim_Knicely September 2018
• 
  Exiting a vsql Script Following an Error

  Jim_Knicely 491 views 0 comments 0 points Started by Jim_Knicely September 2018
• 
  The Parts of a Session ID

  Jim_Knicely 326 views 0 comments 1 point Started by Jim_Knicely September 2018
• 
  Using admintools to List Nodes for a Particular Database

  Jim_Knicely 319 views 0 comments 0 points Started by Jim_Knicely September 2018
• 
  Faster Data Loads with Apportioned Load

  Jim_Knicely 378 views 0 comments 0 points Started by Jim_Knicely September 2018
• 
  Self-Descriptive Constraint Names

  Jim_Knicely 316 views 0 comments 0 points Started by Jim_Knicely September 2018
• 
  Database and Node Uptime

  Jim_Knicely 346 views 0 comments 0 points Started by Jim_Knicely September 2018
• 
  Mimicking Enumerated Types

  Jim_Knicely 318 views 0 comments 0 points Started by Jim_Knicely September 2018
• 
  Changing the Field Separator in VSQL

  Jim_Knicely 336 views 0 comments 0 points Started by Jim_Knicely September 2018
• 
  Monitoring Resource Pool Cascade Events

  Jim_Knicely 330 views 0 comments 0 points Started by Jim_Knicely September 2018
• 
  Setting the Table-Level Active Partition Count

  Jim_Knicely 383 views 0 comments 0 points Started by Jim_Knicely August 2018
• 
  Exporting to Parquet

  Jim_Knicely 528 views 0 comments 0 points Started by Jim_Knicely August 2018
• 
  Connection Load Balancing

  Jim_Knicely 341 views 0 comments 0 points Started by Jim_Knicely August 2018
• 
  Dealing with Subquery Restrictions

  Jim_Knicely 437 views 0 comments 0 points Started by Jim_Knicely August 2018
• 
  Ensure Data Integrity with Check Constraints

  Jim_Knicely 316 views 0 comments 0 points Started by Jim_Knicely August 2018
• 
  Listing Invalid Views

  Jim_Knicely 378 views 0 comments 0 points Started by Jim_Knicely August 2018
• 
  Maximum Number of Rows per Load

  Jim_Knicely 338 views 0 comments 0 points Started by Jim_Knicely August 2018
• 
  Setting the Max Memory Available by Query

  Jim_Knicely 414 views 0 comments 0 points Started by Jim_Knicely August 2018
• 
  Converting CHAR and VARCHAR to BINARY or VARBINARY

  SarahL 391 views 0 comments 0 points Started by SarahL August 2018
• 
  Getting Help with Command-Line Tools

  SarahL 349 views 0 comments 0 points Started by SarahL August 2018