Business Intelligence on Hadoop (BIoH)

This document gives insight into BI/SQL query processing for analytics over Hadoop data. Lately SQL on Hadoop or BI-On-Hadoop has gained significant acceptance in the Big Data Market. Out of all the solutions providing SQL over Hadoop, Hive is the most popular access mechanism on top of Big Data system as most of the BI tools support it. But is it the right and performant access mechanism on Hadoop. In this research, detailed analysis and experimental results, we evaluate various access mechanism using BI tool on top of Hadoop which includes Hive, Drill, Presto, Spark, Tez and Jethro. Various features, advantages and disadvantages of each access mechanism is described.