Hi Sonu,

You can store data processed data in HDFS in raw form or as well in Structured or Semi-Structured form using Hive, HBase, Solr, etc. MapReduce is the first processing tool which was shipped with Hadoop to process Big Data, but these days there are many processing frameworks available which include Hive, Pig, Spark, Casandra, Crunch, Tez, Drill, Impala and Presto.

The available data processing frameworks can be mainly classified into categories as: General-Purpose Processing Frameworks, Abstraction Frameworks, SQL Frameworks, Graph processing Frameworks, Machine Learning Frameworks, Real-Time / Streaming Frameworks.

Based on your use-case and requirement, you choose the framework to process the data. Now the processed data is used for Business Analytics purposes and there are various tools available to do analytics on the processed data. Hadoop Framework is an enabler which provides us the facility to store and process Big Data on distributed envrironment consisting cluster of computer so that the processed data can be leveraged by analytics tools to do analyses on the available data.

Among the analytics tools widely used in market are: R, SAS, Mahout, etc.

Hope this answer helps.

Thanks for the information.

I want to generate report in excel sheet after processing the data using M/R or hive.

How we generate report in excel sheet? Can we use these tools (R,SAS,Mahout etc) to generate excel report.

As per my understanding we can use these tools for data visualization like creating graph,chart etc.

How these tools gets the data? Can they connect to Hive or Hbase for getting data?

How these tools different from Tablaue/Obiee?

Team, can you please look and revert on above query.

Query is - 

I want to generate report in excel sheet after processing the data using M/R or hive.

How we generate report in excel sheet? Can we use these tools (R,SAS,Mahout etc) to generate excel report.

As per my understanding we can use these tools for data visualization like creating graph,chart etc.

How these tools gets the data? Can they connect to Hive or Hbase for getting data?

How these tools different from Tablaue/Obiee?