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 4‑14 shows an example of an HQL query specified in the data set editor.
Figure 4‑14 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 4‑15.
Figure 4‑15 Data set editor displaying the output columns
5 Choose Preview Results to view the data rows returned by the data set.
