HP Big Data Getting Started Guide
Contents
1. 2014 Hewlett Packard Development Company LP Connecting to HP Vertica using supported client drivers HP Vertica provides industry standard client drivers ODBC JDBC ADO NET for connecting your applications to HP Vertica Use HP Vertica 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 special knowledge is required to create the database although a basic knowledge of SQL commands is useful for running queries Creating the example database After you connect to HP Vertica use the tutorial to learn how to create a database and run simple queries following these short procedures e Set up the example environment 16 Using HP Vertica e Create an example database named VMart e Connect to the database e Define the database schema e Load sample data IMPORTANT To get started see Advanced Installation in the HP Vertica Getting Started Guide Querying tables in the example database The VMart database includes sample scripts These scripts contain SQL statements that represent business queries For example the following sample query returns the values for five products in the Da2. HP Vertica uses the maximum available CPU and memory resources The HP CS300 Vertica is optimized to run the database on dedicated servers for large data sets of complex workloads 20 Using HP Vertica Changing the dbadmin password whe 2 For security factory default passwords were changed during the HP CS300 Vertica Installation amp Startup Service The HP CS300 Vertica appliance was configured using a password your organization supplied for the non root system account dbadmin You should not need to change the password If you change the HP Vertica administrator password you must use the same username and password on all HP Vertica nodes and management servers To maintain password consistency across all devices in the appliance HP recommends e Change the dbadmin password from the HP Vertica management server e Manually change passwords on the switches PDUs management servers rOO1 mnOO1 and r001mn002 and HP iLOs TIP You must also change the Management Console administrator s password To change this password on the Management Console click MC Settings Configuration User management Q ce Sdbadmin Logot EN Management Console settings User management Done Configuration PESER Edit existing user SSL certificates MCusername pm Authentication MC password g Ca asoa Email address JEST isi MC configuration permissions Super Resource access DB access levels Administrators will have maxi
3. connect to the IP address of the rOOmn001 server For example http 000 000 000 000 2 If the browser displays a Certificate Error choose the option that says Continue to this website not recommended to bypass this page 3 The HP CS300 Vertica home page appears Click Database Management and click HP Vertica Management to launch Management Console Using HP Vertica HP ConvergedSystem 300 for Vertica Q Home Database Management CS300 Monitoring CS300 Management Documentation Resources HP Vertica Management 2014 Hewlett Packard Development Company LP 4 The first time you launch Management Console you must accept the Enterprise Edition license agreement After reading the agreement click the box next to 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 NOTE You can use the HP CS300 Vertica home page to link to other management tools to perform various device management tasks On the HP CS300 Vertica home page select CS300 Management from the menu bar and click Advanced Management to access e HP Vertica Management Console HP Insight Cluster Management Utility HP Insight Control HP Insight Remote Support HP ConvergedSystem 300 for Vertica Q Home Database Management CS300 Monitoring CS300 Management Documentation Resources luster Management
4. 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 e Monitoring HP Vertica e 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 or import an existing cluster optimize a database design and perform other administrative tasks on the cluster To learn more about Management Console see HP Vertica Management Console tasks page 19 Table 5 HP Vertica Management Console tasks If you want to Read Understand Management Console components and its Management Console in the HP Vertica Concepts Guide underlying architecture and security Understand the difference between the browser based Administration Tools and Management Console in the HP Management Console versus the Cll based Administration Vertica Administrator s Guide Tools functionality Connect to MC manage client connections and database Using Management Console in the HP Vertica clusters manage MC settings or change MC application Administrator s Guide and agent ports Use MC to monitor your database cluster query session Monitoring HP Vertica Using MC in the HP Vertica and node activity or view MC managed database Administrator s Guide messages and MC user
5. structs unions and interfaces HP Vertica C SDK API Look up JDBC packages and classes HP Vertica JDBC API Look up common database terms and those specific to HP Vertica Using HP Vertica HP Vertica Glossary 4 Support and other resources Information to collect before contacting HP Be sure to have the following information available before you contact HP Software product name Hardware product model number Operating system type and version Applicable error message Third party hardware or software Technical support registration number if applicable How to contact HP Use the following methods to contact HP In the United States see the Customer Service Contact HP United States website for contact options http welcome hp com country us en contact_us html In the United States call 1 800 HP INVENT 1 800 474 6836 to contact HP by telephone This service is available 24 hours a day 7 days a week For continuous quality improvement conversations might be recorded or monitored In other locations see the Contact HP Worldwide website for contact options htto www hp com go assistance Typographic conventions The following conventions are used in this document Table 8 Typographic conventions Example Uses Command A command name or command phrase for example 1s a Computer output Information displayed by the computer User input Indicates
6. the HP Vertica Concepts Guide Understand and choose from different methods to create database designs How to create a design in the HP Vertica Administrator s Guide Dropping the example database When you have finished exploring the VMart database you can drop it to restore your hosts to their original state See Restoring the status of your host in the HP Vertica Getting Started Guide Running the HP Vertica Getting Started Tutorial 17 Performing common database administrator tasks This section describes some of the common tasks the HP Vertica database administrator performs This section assumes that you are familiar with the basic concepts and terminology of relational database management systems and SQL For more information see the HP Vertica Administrator s Guide Creating a database HP Vertica provides two options to create a database Management Console or the Administration Tools See Create an Empty Database in the HP Vertica Administrator s Guide Rules for database and password names When you create a database one of your first tasks is to name the database and supply a secure password See Creating a Database Name and Password in the HP Vertica Administrator s Guide Starting and stopping the database You can start and stop your database using the Administration Tools Management Console or from the command line For details see the following topics in the HP Vertica Administrator s Guide e
7. Engineering Team and HP Vertica Designed to simplify the implementation and management of real time analytic applications HP CS300 Vertica provides excellent performance through Massively Parallel Processing MPP technology The HP CS300 Vertica architecture enables distributed query execution where each query executes on all HP Vertica clusters in parallel This architecture gives the HP CS300 Vertica application system the speed to provide user queries with significantly higher levels of O throughput than is available on a scale up symmetric multiprocessing SMP system Table 1 Related documentation Topic HP ProLiant Gen8 Server Location HP ProLiant DL380p Gen8 Server User Guide HP ProLiant DL360p Gen8 Server User Guide HP Insight Cluster Management Utility htto h20628 www2 hp com km ext kmesdirect emr_na c04015665 2 pdf HP Insight Management http www hp com go insightmanagement docs HP iLO htto www hp com go ilo docs HP Insight Remote Support hito www hp com go insightremotesupport docs HP Vertica documentation hito www hp com go convergedsystem cs300vertica docs HP Vertica Webinars Who should use this guide 4 This document is intended for system administrators and database administrators Knowledge of Linux and SQL commands is required Overview Management Console Demo Semi structured data 2 The HP CS300 Vertica ap
8. HP ConvergedSystem 300 for Vertica Getting Started Guide Abstract This document provides 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 Copyright 2014 Hewlett Packard Development Company L P Notices The information contained herein is subject to change without notice The only warranties for HP products and services are set forth in the express warranty statements accompanying such products and services Nothing herein should be construed as constituting an additional warranty HP shall not be liable for technical or editorial errors or omissions contained herein Confidential computer software Valid license from HP required for possession use or copying Consistent with FAR 12 211 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 Server are U S registered trademarks of the Microsoft group of companies Red Hat Enterprise Linux and Red Hat are trademarks of Red Hat Inc in the United States and other countries Contents Bi pase ect iph ee eb ee eee 4 Who should use this Ute wi cases ncevacaeaderabena
9. Location U25 Model DL380p Gen8 Function Vertica node Public 172 24 8 13 gt lt Node Name r001vn014 RackId 1 Location U27 Model DL380p Gen8 Function Vertica node Public 172 24 8 14 gt lt Node Name r001vn015 Rackid 1 Location U29 Model DL380p Gen8 Function Vertica node PublicIA 172 24 8 15 gt lt Node Name r001vn016 Rackid 1 Location U31 Model DL380p Gen8 Function Vertica node PublicIPX172 24 8 16 gt lt Nodes gt lt Licenses gt lt License Name Insight Control Location opt hp CS300 licenses InsightControl lic gt lt License Name Insight CMU Location opt hp CS300 licenses cmu lic gt lt License Name Vertica Enterprise Location opt hp CS300 licenses VerticaEE_HP_1TB dat gt lt Licenses gt lt Appliance gt 172 24 8 10 gt 172 24 8 11 gt 172 24 8 12 gt Your Vertica IP addresses will be different Your Vertica license file name will be different NOTE There are two HP 40GbE QSFP ports per switch Each 40 GbE QSFP port is convertible to IOGbE SFP with an adapter Two adapters are provided with each rack In addition there are thirty 1GbE 10GbE 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 wor
10. Starting the Database e Stopping the Database Reconnecting to the database e Ifyou close your terminal window while the database is running you can reconnect as follows 1 Open a remote session to reconnect to HP Vertica see Connecting to HP Vertica using a remote terminal client page 13 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 e Ifyou 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 Administration Tools in the HP Vertica Administrator s Guide Implementing security In HP Vertica there are three primary security concerns e Client authentication prevents unauthorized access to the database e Client authorization controls what users can access and change in the database e Connection encryption prevents the interception of data and authenticates the identity of the server and the client See Implementing Security in the HP Vertica Administrator s Guide Creating new database users Client authentication controls which database objects users can access and change in the database To prevent unauthorized access a superuser limits access by assigning privileges directly to users or to roles through a series of GRANT statements A Management Console administrator can also grant MC users access t
11. activity Performing common database administrator tasks 19 Table 5 HP Vertica Management Console tasks continued If you want to Read Understand the difference between the database users the About MC Users and About MC Privileges and Roles in dbadmin user creates on the server versus MC users who the HP Vertica Administrator s Guide access HP Vertica through a browser Understand how to create projections using Database Physical Schema in the HP Vertica Administrator s Guide Designer Performing advanced database administrator tasks This section describes additional tasks that HP Vertica database administrators can perform For more information see the HP Vertica Administrator s Guide Installing HP Vertica software for third party tool integration Third party products let you access your HP Vertica database using one of our supported client drivers You can use many third party tools with HP Vertica For a list of HP Vertica partners and the tools they provide see hitp www vertica com partners While you can configure many third party tools to work with HP Vertica through standard client connections HP provides additional software to help with integration of the following products e Informatica To use HP with the plug in for the Informatica PowerCenter see HP Vertica Plug in for Informatica Guide e Microsoft To integrate your HP Vertica server with an environment that include
12. ca Programmer s Guide e Connecting from the Administration Tools e Connecting from the Command Line e Connecting from a Non Cluster Host Accessing HP Vertica 13 NOTE Non dbadmin users cannot log in to the vsql client until the dbadmin user creates a database user account for them 1 Log on to an HP Vertica node using an SSH remote terminal client See the section Connecting to HP Vertica using a remote terminal client page 13 to connect using PuTTY 2 At the command line log in as the dbadmin user and then type admintools 3 If the License EULA Acceptance screen appears click the box beside accept 4 Choose a task from the Administration Tools menu options NOTE The EULA End User License Agreement appears the first time you run Administration Tools as the dbadmin user or after you upgrade your license The default location of your Enterprise Edition license 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 14 You can use the HP CS300 Vertica home page to connect to the HP Vertica Management Console using a browser connection 1 Open your browser and
13. commands and text that you type exactly as shown Replaceable The name of a placeholder that you replace with an actual value Note An alert that contains additional or supplementary information Tip Provides helpful hints or an alternative method for completing a task WARNING An alert that calls attention to important information that if not understood or followed can result in personal injury CAUTION An alert that calls attention to important information that if not understood or followed can result in data loss data corruption or damage to hardware or software Information to collect before contacting HP 23 5 Documentation feedback HP is committed to providing documentation 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
14. e One RJ 45 serial console port e One RJ 45 out of band management port e One USB 2 0 Support 3 year 4 hour 24x7 Proactive Care TIP Serial numbers are listed on the Linux management server in the opt hp CS300 CS300SN log file and on each physical device one 2 Appliance overview 6 The appliance is scalable from 3 to 16 servers per rack as shown in Hardware configuration page 6 There are two management servers running Red Hat Enterprise Linux RHEL and Microsoft Windows Server respectively The Linux server supports HP Vertica and cluster management The Windows server manages HP Insight Control and HP Insight Remote Support Advanced TIP HP recommends configuring in multiples of 4 per rack Figure 1 Hardware configuration 2 HP 5900AF 48XGT 4QSFP Switches Management servers 2 DL360p Gen 8 4 SFF Vertica Compute blocks data HP DL380p Gen 8 25 SFF Scalable from 3 to 16 nodes Y2 Rack 8 nodes Vs Rack 4 nodes ED EO ED ee O E 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 e rxxx rack number e dd indicates type vn Vertica server mn Management server o sw Ethernet switch pd Power distribution unit e yyy number in the rack The example in Figure 2 Appliance naming convention page 7 sho
15. en8 Function Management PublicfP 172 24 8 202 gt lt Node Name r001vn001 RackId 1 Location U1 Model DL380p Gen8 Function Vertica node PublicIP 172 24 8 1 gt lt Node Name r001vn002 RackIid 1 Location U3 Model DL380p Gen8 Function Vertica node PublicIP 172 24 8 2 gt lt Node Name r001vn003 RackId 1 Location U5 Model DL380p Gen8 Function Vertica node PublicIP lt Node Name r001vn004 Rackid Location U7 Model DL380p Gen8 Function Vertica node PublicIP lt Node Name r001vn005 RackId 1 Location U9 Model DL380p Gen8 Function Vertica node PublicIP lt Node Name r001vn006 RackId 1 Location U11 Model DL380p Gen8 Function Vertica node PubliclP 172 24 8 6 gt lt Node Name r001vn007 RackId 1 Location U13 Model DL380p Gen8 Function Vertica node Public 172 24 8 7 gt lt Node Name r001vn008 RackId 1 Location U15 Model DL380p Gen8 Function Vertica node Public 172 24 8 8 gt lt Node Name r001vn009 RackId 1 Location U17 Model DL380p Gen8 Function Vertica node Public 172 24 8 9 gt lt Node Name r001vn010 RackId 1 Location U19 Model DL380p Gen8 Function Vertica node Public lt Node Name r001vn011 RackId 1 Location U21 Model DL380p Gen8 Function Vertica node Public lt Node Name r001vn012 RackId 1 Location U23 Model DL380p Gen8 Function Vertica node Public lt Node Name r001vn013 RackId 1
16. g Started Guide Gain a quick understanding of the HP Vertica approach and its primary components HP Vertica Concepts Guide Learn how to set up and maintain an HP Vertica Analytics Platform database including e Implement security and manage users roles and privileges e Create tables and load data into them e Run the Database Designer create projections e Back up restore and recover the database e Monitor and profile database performance http www hp com go convergedsystem cs300vertica docs Learn about a different kind of table that s designed especially for loading and querying unstructured data HP Vertica Flex Tables Guide Look up SQL syntax arguments and examples for data types functions statement and system tables HP Vertica SQL Reference Manual Learn how to perform various programming tasks such as e Install supported drivers and connect to an HP Vertica database using client drivers e Optimize complex SQL queries e Develop user defined functions HP Vertica Programmer s Guide Learn about how to integrate Apache Hadoop and its components HCatalog and HDFS with the HP Vertica server HP Vertica Hadoop Integration Guide Read about the optional modules HP provides for the HP Vertica server Packs Plug ins and Connectors for HP Vertica Server Look up Java classes structs unions and interfaces HP Vertica Java SDK API Look up C classes
17. ght CMU provides a default set of sensors for tasks such as CPU load memory usage O performance and network performance You can use the sensor Information to ensure optimal server performance and to troubleshoot potential problems HP Insight Remote Support HP Insight Remote Support Advanced 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 can be resolved remotely without a site visit For detailed information see the HP Insight Remote Support documentation Management software TI 3 Using HP Vertica Overview The HP Vertica Analytics Platform HP Vertica is pre installed on the HP ConvergedSystem 300 for Vertica HP CS300 Vertica This section describes how to create and run an HP Vertica database and run queries View the full HP Vertica documentation set on the HP Enterprise Information Library at www hp com go convergedsystem cs300vertica docs Learning about HP Vertica For an overview of how to design build operate and maintain an HP Vertica database HP recommends that you read the HP Vertica Concepts Guide Accessing HP Vertica Before you create a database
18. iry department with the lowest fat content VMart gt SELECT fat_content FROM SELECT DISTINCT fat_content FROM product _dimension WHERE department_description IN Dairy AS food ORDER BY fat_content LIMIT 5 For more examples see Sample Scripts in the HP Vertica Getting Started Guide Atter you become familiar with the VMart schema you can create your own queries See the Appendix in the HP Vertica Getting Started Guide for more information about the VMart schema Using Database Designer to optimize a design An HP Vertica database stores its data in a physical format called projections For best performance 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 e HP Vertica Management Console e Administration Tools e Programmatically Generally you load queries on your development system that are representative of your user s workload and data Then run Database Designer using the Administration Tools See Learning about Database Designer and projections page 17 for more resources Table 4 Learning about Database Designer and projections If you want to Read Understand how to create projections Physical Schema in the HP Vertica Concepts Guide Learn about the Database Designer Database Designer in
19. king backward ending at port 17 Available ports are shown in Ethernet ports page 8 Figure 4 Ethernet ports Calor ke Vertica Customer Ethernet Switch ROO1SW002 Ethernet ports Ethernet Switch ROO1SW001 Ethernet ports ol s Customer so s2 Customer The HP CS300 Vertica appliance Management software Your installation includes HP Insight Control management tools Insight Control delivers a set of software and tools that combine with Systems Insight Manager to provide a powerful mechanism for discovering installing monitoring and managing HP ProLiant servers Insight Control enhances the system monitoring management and deployment features of Systems Insight Manager You can access both tools from the HP CS300 Vertica home page The HP CS300 Vertica home page appears after you connect to the Linux Management Server r001 mn001 from your browser The home page provides an interface for navigating the various browser based server utilities e Database Management e CS300 Monitoring e CS300 Management e Documentation e Resources Figure 5 HP CS300 Vertica home page HP ConvergedSystem 300 for Vertica Q Home Database Management CS300 Monitoring CS300 Management Documentation Resources 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 Insight CMU fro
20. le s cscecteseivnstenssensesesedasatensbivasdaesizasiasobicestarelasasacndessiee 19 Performing advanced database administrator tasks cccccccssesseeceeesesseeeeececeesseaeeeeeessessteeeeeeeees 20 Installing HP Vertica software for third party tool integration ccccscceeceeeesneceeeeeeseesteeeeeeeess 20 Managing load balancing for client CONMECTIONS cccccceeeeeeeeeceeeeeteceeeeceseessseeeeeeceetteaeess 20 Managing database TesOUIteS ic 2cin in auc accoanetiedoeee eee tee 20 Changing the dbadmin Password so 22 ccacnsncenceticcecnesnnsiishecades s ntmemtcileaa2 on ndnenenebeaedermineeenanenctdees 21 Installing or upgrading an HP Vertica license key cccccesecscceeeseeeteeeeeeeessnaeeeeeesessnseeeeeeeee 21 More information for using HP Verticd cccccccccceeseseceeeeeeeeeeceeeeceeeeseeeeeeeeseessseeeeeeeeetseeeees 21 A Oth and oner TASC eyrar ERORE OEE 23 Information to collect before contacting HP ciecscetcecdissrsiesentinwtivencesiaivannwererees 23 How to contact HP ss cnt cen toindan serena aaiouesawadlanngentennnsnnennentuaniudvuand eiaa ae Aa BE AE e EEE a aaa 23 Typographic Conventions sssrini innia ie EENE NE AEE E E EA a a ens 23 Docimeniaion odb jscssencssadsenassasssqcaasnsacasnersastantarmenatinganmnsnndiendnies 24 Contents 3 1 Overview The HP ConvergedSystem 300 for Vertica is a purpose built solution developed through collaborative engineering efforts between the HP ConvergedSystems
21. m the HP CS300 Vertica home page using the following procedure Launching HP Insight CMU 1 Open your browser and connect to the IP address of the Linux Management Server rOO1 mn001 For example http 000 000 000 000 2 The HP CS300 Vertica home page appears Click CS300 Management on the menu bar and select Cluster Management Management software 9 HP ConvergedSystem 300 for Vertica Home Database Management S300 Monitoring CS300Management Documentation Resources Cluster Management N Advanced Management 2014 Hewlett Packard Development Company LP 3 The HP Insight CMU page appears Ap Insight Cluster Management Utility v7 2 Web access Using Insight CMU Launch Insight Cluster Management Utility Cluster status Insight CMU User Guide Insight CMU Release Notes Up 0 Down 0 Insight CMU resources on the HP Web Site HP Insight CMU Web Site Insight CMU public forum Note Documentation is regularly updated on the HP Insight CMU Web Site select Technical Documentation Best viewed at 1024x768 with the latest versions of IE Firefox Chrome Older versions of Internet explorer IEG IE7 are not supported 2013 Hewlett Packard Development Company L P 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 To monitor servers from a single window HP Insi
22. mum access to all databases to the extent permitted by their database roles HP Vertica Installation Status Enabled Theme 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 amp Startup Service your HP Vertica license was installed and an employee in your organization accepted the EULA Your license is stored on the r001mn001 server in the opt hp CS300 licenses lt cust_vlicense_xxx bytes dat gt file For details about HP Vertica licensing see Understanding HP Vertica Licenses in the HP Vertica Administrator s Guide More information for using HP Vertica The full HP Vertica documentation set summarized in HP Vertica documentation page 22 is available online at htto www hp com go convergedsystem cs300vertica docs Performing advanced database administrator tasks 21 22 Table 7 HP Vertica documentation If you want to View supported operating and file systems client drivers and packs plug ins and connectors for the HP Vertica server and client systems Read HP Vertica 7 x x Supported Platforms Learn about new features performance improvements and behavior changes in the current release HP Vertica 7 x x New Features Work through the entire HP Vertica Getting Started Tutorial HP Vertica Gettin
23. neasndcesansaneawceeeeavdgeplbvaadecesdaadusnstasadeenddednsnavanencceenss 4 2 Te Hr Ss Varieco app OCE nar O PENSEE gt Appliance OVEIVIEW sisieden cee cestoeercne dincerdceretien cde pe iv eeaveden dc iguana dalam EAE 6 Installat Onea sissien ireen e aois ara ena oo ere a aR ATEO NEE tonne EE aaeth 7 Management SOM WOE 2 ariarntcranseesdvuakdnusceveustbiunaadana ened aeiiaaitc muse wide inaectaliaweaneurenatamiauues 9 HP Insight Cluster Management Utility ssiscscsntcscesatanivenennnsnedecdasesaneiead ne ddsonananeaddeasdinenciacecedendeds 9 FIP Insight Remote Supportline wacscemesseiennGeudauunieenea E eae 11 Mena PE enia E ESEE EEEE 12 Ovet ViEW seee issiron rcv eE EE E a vga men Ea ss PaA Ena EEA AEE DE EE 12 learning about HP VerticO sssserssissiiireisirirrirsriisinin tian a EEEREN Naa E EEN E aaRS 12 Accessing HP Verica caszieiascsinssstes e arnee a o fase ca adden dasa pamseatetademiasouwelaninds 12 Database superuser dbadmin sssssssssssseoessssssoenisssseeenstsssstretrsssssstntsssessrtersesssernreresrn 12 HP Vertica Wt Te 25 a cieecaissscsn sonst ev tease satntvcwnaitonswpweueo ee tases waoen aang le tol shina ea eo iem anon soheseated 12 Connecting TO HP VSMC a siccsescioaciawnesinas i ee EE Ea EE AE E EEE 13 Running the HP Vertica Getting Started WWiOGl ccsscsececvendeonndesecttaneenccendebiestieqonceeeneiestineeenentersiee 16 Creating the example eta se vcs cess cas ceeradcadlad cen seeendecuhlanceycexcusaudenidepineubaraueecbocen
24. neiaidbaks 16 Querying tables in the example database sccccescsoudatevsacensesdascacnuededeusesdsaeasduntiadinceennouledaadueces 17 Using Database Designer to optimize a CeSIGh cccccccceesssceeeeeeeeeseeeeceeseteeaaeeeeenentseeeeeeeess 17 Dropping the example ate S 6 cordce si csiscosezmycisuceseensveeenadacGebayesei Genes hte EivenmivetesedavhoaeoepGeeeabons 17 Performing common database administrator tasks ic s2i lt cnicedeaineeinardeaieeddinaviee cenideaaer aeons 18 Creating a GIGS isisisi na a E aan EEEE oat ee 18 Rules for database and password NOMES cseceeeeseeeceeeeseeceeeeeeeceseeeeeeeeeceensseeeeeeeneeieeeeeeees 18 Starting and stopping the database 02y isecsaiiciecndasswanala tanta anieacem ae eicdaiaees 18 Reconnecting to the database ec x c2vasecavancinndenssananensccraddeddeciscasanencdlaadedasdayenidd ddendsayantsenvededde 18 Implementing BCU Yeas on cudcscenaincdie cantuanebabinsieenntencke daniels EEEE EEE EE 18 Creating new database USELS cccccccesesseeeeeceeeeseeaeeeeceeseeseeeeeeesesssaseeeeesecsssseeeeesessneeaeess 18 Creating AGIOS eae geten etalon Mveccadauaiavpatevsiealdeainteretannacdlccalededblaceeet Aa E E EEES 19 Loading data into thiee itel BAtS 6 frases sort ercoseeoncnsesetedsomeeievated bapesenadieoesaihenadinnsstaseiacdboneumerstavetes 19 Monitoring the CC ISS ee coreiacah dled ecu ieeeenceblae adap seetincud acide piadalaulcohacepnnalanauarcerceineneebecs 19 Using HP Vertica Management Conso
25. ng to HP Vertica using a remote terminal client To log in to the HP Vertica server as the database user dbadmin use an SSH remote terminal client 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 verity that SSH is selected and click Open 4 Atthe PuTTY log in as prompt type dbadmin and then enter the dbadmin password For more information see the Notes for Remote Terminal Users in the HP Vertica Administrator s Guide Connecting to HP Vertica using Cll based Administration Tools The HP Vertica CLI based Administration Tools provide functionality that is not available in the browser based HP Vertica Management Console To run CLI based Administration Tools you must connect to a node that is running HP Vertica After you ve logged in to HP Vertica as the dbadmin user run the Administration Tools The Administration Tools connect to the database and transfer control to vsql For a comparison between Administration Tools and Management Console functionality see Administration Tools and Management Console in the HP Vertica Administrator s Guide You can run vsql from the command line to connect to a database from any Linux host including hosts that are not part of the HP Vertica database cluster For more information see the following topics in the HP Verti
26. o one or more HP Vertica databases through the MC interface See Managing Users and Privileges in the HP Vertica Administrator s Guide 18 Using HP Vertica Creating tables You can create two types of tables in HP Vertica columnar and flexible e Columnar Columnar tables store data the way it is typically queried for performance based on a pre defined data model Column storage is ideal for read intensive workloads because it can reduce disk I O e Flexible Flexible tables store data in a way that is designed especially for loading and querying unstructured and semi structured data such as social media files as JSON and ArcSight log files Additionally you can create either type of table as either persistent or temporary You can also create views to capture a specific set of table columns that you query frequently For details see Working with Tables in the HP Vertica Administrator s Guide and the HP Vertica Flex Tables Guide Loading data into the database If you followed the tutorial in the HP Vertica Getting Started Guide you already loaded data into the VMart example database After you create a working database you can load data in several ways depending on the frequency of new data and other requirements To learn more see the following topics in the HP Vertica Administrator s Guide e Bulk Loading Data e Trickle Loading Data Monitoring the database HP Vertica provides tools that let you monitor
27. pliance This section provides information about your servers and will help you to locate components in your HP CS300 Vertica appliance The appliance arrives at your location in a default configuration with pre loaded software as shown in Table 2 Appliance configuration Table 2 Appliance configuration Configuration HP Vertica server e HP ProLiant DL380p Gen8 server e 2U Rack form factor e Two Intel Xeon E5 2690v2 CPU e Ethernet 10Gb 2P 561FLR T FIO adapter e Two 300GB 6G SAS 10K 2 5in SC ENT HDD e Twenty three 600GB 6G SAS 10K 2 5in SC ENT HDD e Two 750W CS Plat PL hot plug power supply kit e 128 GB eight 16GB 2Rx4 PC3 14900R 13 kit HP Insight Cluster Management Utility 3 year 24x7 Flex license 2 Management e HP ProLiant DL360p Gen 8 server gaii e 1U Rack form factor e One Intel Xeon E5 2660 v2 CPU e 64 GB four 16GB 2Rx4 PC3 14900R 13 kit memory e Four 600 GB 6G SAS 10K 2 5in SC ENT HDD e Ethernet 10 Gb 2P 51FLR T FIO adapter e 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 Insight Cluster Management Utility 3 year 24x7 Flex license HP Insight Remote Support Advanced Operating System Red Hat Enterprise Linux 6 4 Operating System Windows server 2012 Networking HP 5900AF 48XGT 4QSFP switch e Forty eight RJ 45 1 10GbE ports e Four QSFP 40 GbE ports
28. s Microsoft components previously installed 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 integration If you want to Read Read about the supported client drivers that you can HP Vertica Client Drivers in the HP Vertica documentation download from HP Vertica including information about driver managers client server compatibility and client specific requirements Learn about the optional modules that HP provides for HP Packs Plug ins and Connectors for HP Vertica Clients in Vertica clients the HP Vertica documentation Managing load balancing for client connections Each client connection to an HP Vertica host in the cluster requires a small overhead in memory and processor time Many client connections to a single host can affect database performance When you use connection load balancing HP Vertica automatically spreads the overhead of client connections across the cluster by having hosts redirect connections to other hosts For details see Connection Load Balancing in the HP Vertica Administrator s Guide Managing database resources To maximize performance
29. statements functions and other operations See Using vsql in the HP Vertica Programmer s Guide HP Vertica Administration Tools A basic user interface for the database superuser dbadmin to perform operational and management tasks Only the 12 Using HP Vertica Table 3 Interfaces continued Interface Description dbadmin user can run the Administration Tools See Using the Administration Tools in the HP Vertica Programmer s Guide Use the vsql client interface or another client of your choice to run database queries and analytic functions HP Vertica Management Console MC A graphical browser based interface to monitor and manage one or more HP Vertica clusters and perform other database related tasks See Management Console in the HP Vertica Concepts Guide Client Drivers Industry standard drivers such as ODBC JDBC and ADO NET let you connect your applications to HP Vertica After you connect your application can load and exchange data generate reports and complete other database tasks You also use client drivers to connect with third party applications such as Cognos and MicroStrategy See the HP Vertica Client Libraries in the HP Vertica Programmer s Guide Connecting to HP Vertica TIP For IP address details see the file named opt hp CS300 HPCS300 xm1 on the Linux management server rOO1 mn001 as the example shown in IP addresses page 8 Connecti
30. this section e Introduces the HP Vertica superuser e Describes HP Vertica interfaces e Describes how to connect and log in to HP Vertica Database superuser dbadmin When HP Vertica was installed on HP ConvergedSystem 300 for Vertica an administrative account dbadmin was created and configured using a password your organization supplied The dbadmin account is a non root system user who is also the HP Vertica superuser The dbadmin account can 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 Vertica interfaces Use one or any combination of the following interfaces to access HP Vertica Table 3 Interfaces Interface Description HP CS300 Vertica Home Page Use the HP CS300 Vertica home page to navigate browser based management tools This page appears when you connect to the r001mn001 Linux management server from a browser session Linux command line A standard shell interface that sends keyboard commands to the operating system vsql client interface A native commandline utility that interacts directly with the HP Vertica database From vsql run supported
31. ws the management servers using the naming conventions r001mn002 Windows management server rOO1mn001 Linux management server The HP CS300 Vertica appliance Figure 2 Appliance naming convention r001sw002 r001sw001 r001mn002 r001mn001 r001vn016 r001vn003 r00 1vn002 r001vn001 Installation During the HP CS300 Vertica Installation amp Startup Service your appliance was connected using either 10Gb or 1Gb Ethernet and configured 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 xm1 on the Linux management server rOO mn001 as shown in IP addresses page 8 IMPORTANT Do not edit or change the opt hp CS300 HPCS300 xm1 file Appliance overview 7 Figure 3 IP addresses lt xml version 1 0 encoding UTF 8 gt lt Appliance gt lt Version Hardware 1 0 Software 1 0 ApplianceLevel 1 0 Model HP ConvergedSystem 300 for Vertica gt lt Network Public 255 255 255 0 Private 255 255 255 0 Gateway 172 24 8 254 DNS 172 24 8 254 NTP 172 24 8 254 Timezone US Central CEN_Vian 112 gt lt Nodes gt lt Node Name r001mn001 RackId 1 Location U39 Model DL360p Gen8 Function Management PublicIJ 172 24 8 201 jLOIP 172 24 8 211 gt lt Node Name r001mn002 RackId 1 Location U40 Model DL360p G
Download Pdf Manuals
Related Search