background image

Table 7 HP Vertica documentation

Read:

If you want to:

HP Vertica 7.x.x Supported Platforms

View supported operating and file systems, client drivers,
and packs, plug-ins, and connectors for the HP Vertica
server and client systems

HP Vertica 7.x.x New Features

Learn about new features, performance improvements, and
behavior changes in the current release

HP Vertica Getting Started Guide

Work through the entire HP Vertica Getting Started Tutorial

HP Vertica Concepts Guide

Gain a quick understanding of the HP Vertica approach
and its primary components

http://www.hp.com/go/convergedsystem/cs300vertica/
docs

Learn how to set up and maintain an HP Vertica Analytics
Platform database, including:

Implement security and manage users, roles, and
privileges.

Create tables and load data into them.

Run the Database Designer (create projections).

Back up, restore, and recover the database.

Monitor and profile database performance.

HP Vertica Flex Tables Guide

Learn about a different kind of table that’s designed
especially for loading and querying unstructured data

HP Vertica SQL Reference Manual

Look up SQL syntax, arguments, and examples for data
types, functions, statement, and system tables

HP Vertica Programmer’s Guide

Learn how to perform various programming tasks, such as:

Install supported drivers and connect to an HP Vertica
database using client drivers.

Optimize complex SQL queries.

Develop user-defined functions.

HP Vertica Hadoop Integration Guide

Learn about how to integrate Apache Hadoop and its
components (HCatalog and HDFS) with the HP Vertica
server

Packs, Plug-ins, and Connectors for HP Vertica Server

Read about the optional modules HP provides for the HP
Vertica server

HP Vertica Java SDK API

Look up Java classes, structs, unions, and interfaces

HP Vertica C++ SDK API

Look up C++ classes, structs, unions, and interfaces

HP Vertica JDBC API

Look up JDBC packages and classes

HP Vertica Glossary

Look up common database terms and those specific to HP
Vertica

22

Using HP Vertica

Summary of Contents for ConvergedSystem 300

Page 1: ...ides an overview of the HP ConvergedSystem 300 for Vertica appliance It is intended to be used by system administrators and technical professionals involved with planning operations and administration of the appliance or database HP Part Number 5900 3765 Published March 2014 Edition 1 ...

Page 2: ...hnical or editorial errors or omissions contained herein Confidential computer software Valid license from HP required for possession use or copying Consistent with FAR 12 21 1 and 12 212 Commercial Computer Software Computer Software Documentation and Technical Data for Commercial Items are licensed to the U S Government under vendor s standard commercial license Microsoft Windows and Windows Ser...

Page 3: ...inistrator tasks 18 Creating a database 18 Rules for database and password names 18 Starting and stopping the database 18 Reconnecting to the database 18 Implementing security 18 Creating new database users 18 Creating tables 19 Loading data into the database 19 Monitoring the database 19 Using HP Vertica Management Console 19 Performing advanced database administrator tasks 20 Installing HP Verti...

Page 4: ...y higher levels of I O throughput than is available on a scale up symmetric multiprocessing SMP system Table 1 Related documentation Location Topic HP ProLiant DL380p Gen8 Server User Guide HP ProLiant Gen8 Server HP ProLiant DL360p Gen8 Server User Guide http h20628 www2 hp com km ext kmcsdirect emr_na c04015665 2 pdf HP Insight Cluster Management Utility http www hp com go insightmanagement docs...

Page 5: ...agement servers HP ProLiant DL360p Gen8 server 1U Rack form factor One Intel Xeon E5 2660 v2 CPU 64 GB four 16GB 2Rx4 PC3 14900R 13 kit memory Four 600 GB 6G SAS 10K 2 5in SC ENT HDD Ethernet 10 Gb 2P 51FLR T FIO adapter Two 460W CS Plat PL hot plug power supply kit HP Insight Control HP Vertica Analytics Platform HP Insight Control Flex license RHEL Server 2 Skt 1 Guest 24x7 3 year license HP Ins...

Page 6: ...onfiguring in multiples of 4 per rack Figure 1 Hardware configuration The appliance uses a simple naming convention to distinguish servers Each server is represented using the rack number server type and server number as shown below rxxx rack number dd indicates type vn Vertica server mn Management server sw Ethernet switch pd Power distribution unit yyy number in the rack The example in Figure 2 ...

Page 7: ...ured for your corporate network Your organization supplied passwords and IP addresses to HP Technical Services For a high level overview of your configuration including IP addresses see the file at opt hp CS300 HPCS300 xml on the Linux management server r001mn001 as shown in IP addresses page 8 IMPORTANT Do not edit or change the opt hp CS300 HPCS300 xml file Appliance overview 7 ...

Page 8: ... RJ45 ports per switch There are two Ethernet switches each switch with fourteen available ports for a total of fifty six available 10Gb 1Gb ports on both switches There are also two 40Gb ports on each switch TIP HP recommends assigning Ethernet ports beginning at port 44 and working backward ending at port 17 Available ports are shown in Ethernet ports page 8 Figure 4 Ethernet ports 8 The HP CS30...

Page 9: ...rom your browser The home page provides an interface for navigating the various browser based server utilities Database Management CS300 Monitoring CS300 Management Documentation Resources Figure 5 HP CS300 Vertica home page HP Insight Cluster Management Utility HP Insight Cluster Management Utility HP Insight CMU is a collection of tools for managing and monitoring large clusters Access HP Insigh...

Page 10: ...Insight CMU page appears 4 Under Using Insight CMU click Launch Insight Cluster Management Utility See the HP Insight Cluster Management Utility User Guide for more information 10 The HP CS300 Vertica appliance ...

Page 11: ...is a software tool that is installed based on your HP Support Contract This utility continuously monitors your servers storage network and other devices alerting you to potential problems It sends information to HP call center staff or your administration staff depending on your configuration and level of support Using HP Insight Remote Support can assess issues remotely to determine if a problem ...

Page 12: ...an perform all database related tasks and others such as upgrading license keys and installing client drivers Other HP Vertica Users Before additional users can log in to HP Vertica the dbadmin user must first create a database The dbadmin user can then create database users including other database administrator DBA accounts Database and user creation topics are described in later sections HP Ver...

Page 13: ...ent such as PuTTY or a Cygwin bash shell 1 Launch the PuTTY application 2 In the Host Name or IP dialog box type the name of the host or IP address of the server to which you want to connect 3 Under Connection type verify that SSH is selected and click Open 4 At the PuTTY log in as prompt type dbadmin and then enter the dbadmin password For more information see the Notes for Remote Terminal Users ...

Page 14: ...e key is opt hp CS300 licenses cust_vlicense_xxx_bytes dat where cust_vlicense_xxx_bytes dat is named specifically for your environment When prompted type the location for your Enterprise Edition license key and click OK See Connecting From the Administration Tools in the HP Vertica Programmer s Guide for detailed information Connecting to HP Vertica using the browser based Management Console You ...

Page 15: ...rprise Edition license agreement After reading the agreement click the box next to I accept the above terms and conditions and click Next 5 The Management Console home page appears See Using Management Console in the HP Vertica Administrator s Guide Accessing HP Vertica 15 ...

Page 16: ...rtica client drivers to connect with third party applications such as Cognos or MicroStrategy For more information see HP Vertica Client Libraries in the HP Vertica Programmer s Guide Running the HP Vertica Getting Started Tutorial To help orient new users the HP Vertica Getting Started Guide includes a short tutorial This section provides tips on getting started with your first database No specia...

Page 17: ...erformance optimize projections based on their data and workload characteristics For details see Using Database Designer to Create a Comprehensive Design in the HP Vertica Getting Started Guide HP Vertica provides three ways for you to optimize projections HP Vertica Management Console Administration Tools Programmatically Generally you load queries on your development system that are representati...

Page 18: ...n to reconnect to HP Vertica see Connecting to HP Vertica using a remote terminal client page 13 1 2 Log in as the dbadmin user 3 Type admintools at the command line 4 Select Connect to Database from the Main Menu and click OK If you close your browser window while the database is running follow the steps in Connecting to HP Vertica using the browser based Management Console page 14 See Using the ...

Page 19: ...itor many operational aspects of your database and its overall health and performance For details about how and what to monitor see the following topics the HP Vertica Administrator s Guide Monitoring HP Vertica Using System Tables Using HP Vertica Management Console The Management Console MC interface lets you monitor and manage one or more database clusters You can create a new database cluster ...

Page 20: ...lled on your system for example Microsoft Visual Studio and Microsoft SQL Server see the HP Vertica Connectivity Pack Guide NOTE Each third party tool may use different drivers for connecting to HP Vertica For details and requirements refer to the vendor documentation for the tool you want to use See Learn about third party integration page 20 to learn more Table 6 Learn about third party integrat...

Page 21: ...onsole administrator s password To change this password on the Management Console click MC Settings Configuration User management IMPORTANT The HP Vertica Management Console only changes HP Vertica passwords Linux and other device passwords must be changed separately Installing or upgrading an HP Vertica license key As part of the HP CS300 Vertica Installation Startup Service your HP Vertica licen...

Page 22: ...file database performance HP Vertica Flex Tables Guide Learn about a different kind of table that s designed especially for loading and querying unstructured data HP Vertica SQL Reference Manual Look up SQL syntax arguments and examples for data types functions statement and system tables HP Vertica Programmer s Guide Learn how to perform various programming tasks such as Install supported drivers...

Page 23: ...n other locations see the Contact HP Worldwide website for contact options http www hp com go assistance Typographic conventions The following conventions are used in this document Table 8 Typographic conventions Uses Example A command name or command phrase for example ls a Command Information displayed by the computer Computer output Indicates commands and text that you type exactly as shown Use...

Page 24: ...that meets your needs To help us improve the documentation send any errors suggestions or comments to Documentation Feedback docsfeedback hp com Include the document title and part number version number or the URL when submitting your feedback 24 Documentation feedback ...

Reviews: