> #### How to specify what data to retrieve from a Hadoop system

> 1 | In Data Explorer, right-click Data Sets, then choose New Data Set.

> 2 | In New Data Set, specify the following information:

> 1 | In Data Source Selection, select the Hive data source to use. Data Set Type displays HQL Select Query.

> 2 | In Data Set Name, type a name for the data set.

> 3 | Choose Next.

> 3 | In HQL Query, in Query Text, type a HQL statement that indicates what data to retrieve. Figure 2-12 shows an example of an HQL query specified in the data set editor.

> Figure 2-12 Data set editor displaying an HQL query

> 4 | Choose Finish to save the data set. Edit Data Set displays the columns, and provides options for editing the data set, as shown in Figure 2-13.

> Figure 2-13 Data set editor displaying the output columns

> 5 | Choose Preview Results to view the data rows returned by the data set.

(c) Copyright Actuate Corporation 2013