O'Reilly logo

Microsoft SQL Server 2012 with Hadoop by Debarchan Sarkar

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Summary

In this chapter, we had a dive into the Hadoop supporting project Hive. Hive acts as a data warehouse on top of HDFS providing easy, familiar SQL-like query structures called HQL to fetch the underlying data. HQLs are broken down into MapReduce code internally, thus relieving the end user from writing complex MapReduce code. We also learned about the Hive ODBC driver that acts as an interface between the client consumers and Hadoop; how to install the driver and how to test that the driver is successfully able to connect to Hive. We had a brief look into SQL Server and its business intelligence components as well in this chapter. We developed a sample package, which connects to Hive using the Hive ODBC driver and imports data from the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required