CHAPTER 8

image

Accessing HDInsight over Hive and ODBC

If you are a SQL developer and want to cross-pollinate your existing SQL skills in the world of Big Data, Hive is probably the best place for you. This section of the book will enable you to be the Queen Bee of your Hadoop world with Hive and gain business intelligence (BI) insights with Hive Query Language (HQL) filters and joins of Hadoop Distributed File System (HDFS) datasets.

Hive provides a schema to the underlying HDFS data and a SQL-like query language to access that data. Simba, in collaboration with Microsoft, provides an ODBC driver that is the supported and recommended interface for ...

Get Pro Microsoft HDInsight: Hadoop on Windows now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.