Advanced Reports

xennlake has the Apache Hive and Hive SQL support. Every report definition within the xennlake Discovery module defines a hive table in the background. The name of the table is same with the name of the report definition. Every time a report executes and processes new data, Hive table is also updates itself with the last result of the execution.

To create a report with the Hive SQL definition, xennlake uses a special report named "Advanced Report". To create an advanced report, click on the "Advanced Report" button on the left control panel when you are in the "Discovery Module".

"Report Name" and "Repository Store" should be defined first. And then press "Next" for the next step.

Second step is the Hive SQL definition part. Any SQL syntax with the Hive support is enabled by default. Here, we are giving an example of total number of sales by gender, category and subcategories. Previously created product_sales report will be used for the Hive execution which is an enhanced report, combines sales and the customers datasets. The sample SQL used is;

select

col4, col9, col10, cast(sum(col8) as int)

from product_sales

group by col4,col9,col10;

Optionally, you can test the syntax of your provided SQL command by clicking on the "testQL" button under the text box of the SQL command. If the provided SQL is syntactically correct the following information will appear.

To finish the Advanced Report definition and save it to repository, click on the Finish Button. By default the output of the report is defined as "RAW". Execute the report as of any other reports, by clicking "Run" button on the "Discovery Module" main page.

You can check the results by clicking on the name of the report on the "Discovery" Module main page.