Hadoop Query Designer

In this chapter

This chapter explains about querying data stored on cluster based on metadata extracted by creating big queries and reports .

Introduction

Query Designer can be used to query the metadata extracted from the files. QueryIO provides a user interface for defining work item queries.

Query designer is composed of two modules:

Query Builder allows us to define grouping, sorting and constructing criteria in a simple and direct way. It also allows you to save queries and use them again later.

Query builder is basically used to filter out the files available on the cluster. Files can be filtered on the basis of file types(table name).

Using report builder interface of QueryIO, you can build reports to format the result of queries.

You can easily create Select query with the help of Query Designer.

Creating Queries

Query Designer provides interface to create queries easily. Following are the steps to build query:

Compose Query

If you have not yet uploaded any files to the cluster, please go through the Data Migration doc to check how to upload files to HDFS cluster using QueryIO.

By default, the metadata for unregistered file types is saved in hdfs_metadata table

Report Builder

Using report builder interface of QueryIO, you can build reports to present the contents of the queries that you can perform using the query builder interface.

Report builder comprises of three modules:


This section will show you how easily you can build reports using QueryIO.

To build reports, go to Analytics > Query Designer.

Create new query using Query Builder view or load existing query using Query Manager page.

Following are the steps to build customized reports:

Report Designer

report-designer

Report Header

The Report Header section generally contains the report title and other information you want to appear only at the beginning of the report. Charts in this section contain data for the entire report.

Group Header

It contains the part of the message used to indicate the start of a functional group of documents. Group Headers are useful and often necessary to make your report data clear and easily understood.

Column Header

The column header is the colored row of letters used to identify each column within the table. The column header row is located above the row one.

Column Details

Column details refer to the contents of the columns of non header rows in the table.

Group Footer

It contains the part of the message used to indicate the end of a functional group of documents. Group Footers are useful and often necessary to make your report data clear and easily understood.

Report Footer


Chart Designer

report-designer

Add Chart

Clone Chart

Delete Chart


Chart Preferences

QueryIO provides you highly customized your charts and make them the way you want them to look. This feature drastically improves overall report.

Chart Preference UI is divided into three sections :

Chart Preferences include following configurable property categories

Note : For global chart preferences, all categories are shown and preview contains pie chart and line chart. For individual chart preferences, categories not applicable on respective chart are not displayed and preview contains selected chart type.


Report Preview

report-designer

Here you can see the preview of the report that will be generated with the current configuration.



Copyright 2017 QueryIO Corporation. All Rights Reserved.

QueryIO, "Big Data Intelligence" and the QueryIO Logo are trademarks of QueryIO Corporation. Apache, Hadoop and HDFS are trademarks of The Apache Software Foundation.