HP Vertica Essentials

HP Vertica Essentials
eBook: $23.99
Formats: PDF, PacktLib, ePub and Mobi formats
save 15%!
Print + free eBook + free PacktLib access to the book: $63.98    Print cover: $39.99
save 37%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Table of Contents
Sample Chapters
  • Learn cluster management and techniques to improve performance in Vertica
  • Deploy local segmentation and get to grips with the concept of projections
  • A simple, step-by-step guide covering the common administration-related activities in HP Vertica

Book Details

Language : English
Paperback : 106 pages [ 235mm x 191mm ]
Release Date : May 2014
ISBN : 1782171568
ISBN 13 : 9781782171560
Author(s) : Rishabh Agrawal
Topics and Technologies : All Books, Big Data and Business Intelligence, Enterprise

Table of Contents

Chapter 1: Installing Vertica
Chapter 2: Cluster Management
Chapter 3: Monitoring Vertica
Chapter 4: Backup and Restore
Chapter 5: Performance Improvement
Chapter 6: Bulk Loading
  • Chapter 1: Installing Vertica
    • Understanding the preinstallation steps
      • Swap space
      • Dynamic CPU frequency scaling
      • Understanding disk space requirements
    • Steps to install Vertica
    • Summary
  • Chapter 2: Cluster Management
    • Comprehending the elastic cluster scaling factor
      • Enabling and disabling an elastic cluster
      • Viewing and setting the scaling factor settings
      • Enabling and disabling local segmentation
      • Understanding the best practices in cluster management
      • Monitoring elastic cluster rebalancing
    • Adding nodes in Vertica
      • Method
        • Using the Management Console to add nodes
      • Adding nodes using administration tools
    • Removing nodes in Vertica
      • Lowering the K-safety level
      • Removing nodes using administration tools
      • Removing nodes using the Management Console
      • Removing hosts from a cluster
    • Replacing nodes
      • Replacing a node using the same name and IP address
      • Replacing a failed node using a different name and IP address
      • Redistributing configuration files to nodes
      • Using administration tools to replace nodes with different names and IP addresses
    • Changing the IP addresses of a Vertica cluster
    • Summary
  • Chapter 3: Monitoring Vertica
    • Monitoring through the system tables
      • Understanding a system table example
    • Looking at events
      • Looking at events through logfiles
      • Looking at events through the ACTIVE_EVENTS system table
    • Monitoring Vertica through the Management Console
    • Retaining monitoring information
      • Enabling and disabling Data Collector
      • Viewing the current data retention policy
      • Configuring data retention policies
    • Monitoring data collection components
    • Summary
  • Chapter 4: Backup and Restore
    • Requirements for backup hosts
    • Generating the vbr.py configuration file
      • Miscellaneous settings
      • Database access settings
      • Data transmission during the backup process
      • Mapping
    • Creating full and incremental backups
      • Understanding the requirements
      • Running vbr.py
      • Incremental snapshots
      • Creating schema and table snapshots
    • Restoring full database snapshots
      • Restoring from a specific snapshot
      • Restoring from the most recent snapshot
      • Restoring schema and table snapshots
      • Copying a database from one cluster to another
        • Copying the database
    • Using database snapshot functions
      • Creating database snapshots
      • Removing snapshots
    • Summary
  • Chapter 5: Performance Improvement
    • Understanding projections
      • Looking into high availability and recovery
        • Comprehending unsegmented projections
        • Comprehending segmented projections
      • Creating projections using Database Designer
        • The comprehensive design
        • The query-specific design
      • Creating projections manually
        • Column list and encoding
        • The base query
        • The sort order
        • Segmentation
        • Keeping K-safety (K-Safe) in mind
    • Understanding the storage model in Vertica
      • Tuple Mover operations
        • Moveout
        • Mergeout
        • Tuning Tuple Mover
      • Adding storage locations
        • Adding a new location
        • Measuring location performance
        • Setting location performance
        • Understanding storage location tweaking functions
    • Summary
  • Chapter 6: Bulk Loading
    • Using the COPY command
      • Aborting the COPY command
    • Load methods
    • Data transformation
    • Summary

Rishabh Agrawal

Rishabh Agrawal is currently working as a senior database research engineer and consultant at Impetus India. He has been tinkering with databases since 2010 and has gained expertise in a variety of NoSQL, massively parallel processing (MPP), and relational databases in the Big Data domain in a short span of time. A MongoDB Certified DBA, he has working knowledge of more than 20 databases, namely Cassandra, Oracle NoSQL, FoundationDB, Riak, Gemfire, Gemfire XD, HBase, Hive, Shark, HP Vertica, Greenplum, SQL Server 2008 R2, and so on. His primary focus areas are research and evaluation of new and cutting-edge database technologies and consulting with clients on the strategic use of diverse database technologies.

When not at work, he revels in photographing vivid subjects, playing badminton, writing poems, and dancing. You can connect with him on LinkedIn at in.linkedin.com/pub/rishabh-agrawal/15/ab4/186.

Sorry, we don't have any reviews for this title yet.

Code Downloads

Download the code and support files for this book.

Submit Errata

Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.

Sample chapters

You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

Frequently bought together

HP Vertica Essentials +    Mastering Object-oriented Python =
50% Off
the second eBook
Price for both: $34.95

Buy both these recommended eBooks together and get 50% off the cheapest eBook.

What you will learn from this book

  • Successfully install Vertica
  • Manage clusters in Vertica
  • Create backups and restore databases
  • Master different techniques to improve performance
  • Understand the concept of projections in Vertica
  • Make effective projections in Vertica
  • Monitor performance in Vertica
  • Get to grips with the concept of bulk loading in Vertica

In Detail

With the rise of Massively Parallel Processing (MPP) and NewSQL databases, many users are confused about which MPP technology to opt for. Today, HP Vertica is gaining a lot of traction as a major MPP technology. Vertica's distributed architecture allows fast query processing, and it is a highly fault-tolerant architecture, thus making it one of the most sought-after MPP databases today.

HP Vertica Essentials will help you to learn day-to-day administration activities in a step-by-step format. You will start by learning how to install Vertica, followed by its management and monitoring. You will learn about the different backup and restore techniques, including the concept of projections in Vertica. Finally, you will explore the various techniques to improve performance and bulk loading in Vertica. By the end of this book, you will be able to install, manage, and monitor Vertica efficiently.


This is a step-by-step guide with an easy-to-follow approach. A variety of diagrams and images support the concepts explored in the book. This book also contains important tips and tricks, thus making it a really useful reference for Vertica administration activities.

Who this book is for

If you are a Vertica user or DBA who wants to perform basic administration and fi ne tuning, then this book is for you. Prior knowledge of Vertica will help you to understand the concepts better, but is not mandatory. Some intermediate knowledge of RDBMS, SQL, Linux, and scripting languages such as Perl or Python will be helpful.

Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software