Dear Sachin,

We hope you are doing good.

You can use Pentaho Report designer tool to display the data. 

Install Pentaho Report designer tool:
  • Open browser and download Pentaho from below link. 
  • Open terminal and extract the downloaded file prd-ce-3.7.0-stable.tar.gz using the following command. 
Command: tar -zxvf prd-ce-3.7.0-stable.tar.gz
  • Copy the extracted folder (prd-ce-3.7.0-stable) into “/usr/local/” directory using the following command. 
Command: mv prd-ce-3.7.0-stable /usr/local/
  • Open “/usr/local/prd-ce-3.7.0-stable/report-designer” directory and start Pentaho Reporting Designer using the following commands. 
Command: cd /usr/local/prd-ce-3.7.0-stable/report-designer
Command: report-designer.sh
Please refer to the below link that would guide you in Integrating Hive with Pentaho
Please refer to the below link that would guide you in reporting hive data

If you are interested in learning more about Pentaho,  you can enroll to "Pentaho BI" course. 
 
Below is the link to enroll for this course. We will able to help unless you are enrolled for this course.

Hope this helps you.
 
Please feel free to revert if you need any further help we will be glad to assist you.
 
Kindly leave your feedback by clicking on any one of the below smileys 

Please note if you are not happy with the response on this ticket, please escalate it to escalations@edureka.in.
We assure you that we will get back to you within 24 hours