HP Big Data Guia de Início Rápido descarregar pdf (Página 17)

• Create an example database named VMart

• Connect to the database

• Define the database schema

• 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 Dairy department with the lowest fat content:

VMart => 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. After 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:

• HP Vertica Management Console

• Administration Tools

• 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

Read:If you want to:

Physical Schema in the HP Vertica Concepts GuideUnderstand how to create projections

Database Designer in the HP Vertica Concepts GuideLearn about the Database Designer

How to create a design in the HP Vertica Administrator’s

Guide

Understand and choose from different methods to create

database designs

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

1 2 ... 12 13 14 15 16 17 18 19 20 21 22 23 24

Comentários a estes Manuais

Sem comentários

HP Big Data Guia de Início Rápido Página 17

Comentários a estes Manuais

Manuais e produtos relacionados com Software de bases de dados HP Big Data