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.