HP Big Data Quick Start Guide

HP ConvergedSystem 300 for VerticaGetting Started GuideAbstractThis document provides an overview of the HP ConvergedSystem 300 for Vertica appliance.

3. The HP Insight CMU page appears:4. Under Using Insight CMU, click Launch Insight Cluster Management Utility.See the HP Insight Cluster Management U

To monitor servers from a single window, HP Insight CMU provides a default set of sensors fortasks such as CPU load, memory usage, I/O performance, an

3 Using HP VerticaOverviewThe HP Vertica Analytics Platform (HP Vertica) is pre-installed on the HP ConvergedSystem 300for Vertica (HP CS300 Vertica).

Table 3 Interfaces (continued)DescriptionInterfacedbadmin user can run the Administration Tools. See Usingthe Administration Tools in the HP Vertica P

NOTE: Non-dbadmin users cannot log in to the vsql client until the dbadmin user creates adatabase user account for them.1. Log on to an HP Vertica nod

4. The first time you launch Management Console you must accept the Enterprise Edition licenseagreement. After reading the agreement, click the box ne

NOTE: You can use the HP CS300 Vertica home page to link to other management tools toperform various device-management tasks. On the HP CS300 Vertica

• Create an example database named VMart• Connect to the database• Define the database schema• Load sample dataIMPORTANT: To get started, see Advanced

Performing common database administrator tasksThis section describes some of the common tasks the HP Vertica database administrator performs.This sect

Creating tablesYou can create two types of tables in HP Vertica, columnar and flexible.• Columnar— Columnar tables store data the way it is typically

© Copyright 2014 Hewlett-Packard Development Company, L.P.NoticesThe information contained herein is subject to change without notice. The only warran

Table 5 HP Vertica Management Console tasks (continued)Read:If you want to:About MC Users and About MC Privileges and Roles inthe HP Vertica Administr

Changing the dbadmin passwordFor security, factory-default passwords were changed during the HP CS300 Vertica Installation &Startup Service. The H

Table 7 HP Vertica documentationRead:If you want to:HP Vertica 7.x.x Supported PlatformsView supported operating and file systems, client drivers,and

4 Support and other resourcesInformation to collect before contacting HPBe sure to have the following information available before you contact HP:• So

5 Documentation feedbackHP is committed to providing documentation that meets your needs. To help us improve thedocumentation, send any errors, sugges

Contents1 Overview...4Who should use this guide...

1 OverviewThe HP ConvergedSystem 300 for Vertica is a purpose-built solution developed through collaborativeengineering efforts between the HP Converg

2 The HP CS300 Vertica applianceThis section provides information about your servers and will help you to locate components inyour HP CS300 Vertica ap

Appliance overviewThe appliance is scalable from 3 to 16 servers per rack as shown in “Hardware configuration”(page 6). There are two management serve

Figure 2 Appliance naming conventionInstallationDuring the HP CS300 Vertica Installation & Startup Service, your appliance was connected usingeith

Figure 3 IP addressesNOTE: There are two HP 40GbE QSFP+ ports per switch. Each 40 GbE QSFP+ port is convertibleto 10GbE SFP+ with an adapter. Two adap

Management softwareYour installation includes HP Insight Control management tools. Insight Control delivers a set ofsoftware and tools that combine wi