One of the main advantages of Hive is that it provides a querying experience that is similar to that of a relational database, which is a familiar technique for many business users. Essentially, it allows all ODBC compliant clients to consume HDFS data through familiar ODBC Data Sources (DSN), thus exposing Hadoop to a wide and diverse range of client applications.
There are several ODBC drivers available presently in the market that work on top of their own distribution of Hadoop. In this book, we will focus on the Microsoft ODBC driver for Hive that bridges the gap between Hadoop and SQL Server along with its rich business intelligence and visualization tools. The driver can be downloaded from http://www.microsoft.com/en-us/download/details.aspx?id=37134.
The driver comes in two flavors, 64 bit and 32 bit, so please make sure that you download and install the appropriate driver depending upon the bit configuration of your client application. In my case, since I am going...