HP Big Data Guida di Avvio Rapido Scaricare il pdf (Pagina 12)

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, this section:

• Introduces the HP Vertica superuser.

• Describes HP Vertica interfaces.

• 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

DescriptionInterface

Use the HP CS300 Vertica home page to navigate

browser-based management tools. This page appears when

HP CS300 Vertica Home Page

you connect to the r001mn001 Linux management server

from a browser session.

A standard shell interface that sends keyboard commands

to the operating system.

Linux command line

A native, command-line utility that interacts directly with

the HP Vertica database. From vsql, run supported

vsql client interface

statements, functions, and other operations. See Using vsql

in the HP Vertica Programmer’s Guide.

A basic user interface for the database superuser (dbadmin)

to perform operational and management tasks. Only the

HP Vertica Administration Tools

12 Using HP Vertica

1 2 ... 7 8 9 10 11 12 13 14 15 16 17 ... 23 24

Commenti su questo manuale

Nessun commento

HP Big Data Guida di Avvio Rapido Pagina 12

Commenti su questo manuale

Prodotti e manuali riguardandi Software di database HP Big Data