Database Reference
In-Depth Information
Configuring the Hive ODBC Driver
A wealth of third-party tools, such as Microsoft Excel, provide advanced
analytic features, visualizations, and toolsets. These tools are often a critical
part of a data analyst's day-to-day job, which make the Hive Open Database
Connectivity (ODBC) driver one of the most important pieces of Hive. You
can download the Hive ODBC driver from
http://www.microsoft.com/
en-us/download/details.aspx?id=40886
. It allows any ODBC-compliant
application to easily tap into and integrate with your big data store.
Configuring the Hive ODBC driver (see
Figure 4.5
) is handled using the
ODBC Data Sources configuration tool built in to the Microsoft Windows
operating system. After configuration is complete, Hive tables can be
accessed directly from not only analytics tools such as Microsoft Excel but
also from other ODBC-compliant tools such as SQL Server Integration
Services (SSIS).
Figure 4.5
Hive ODBC configuration
Exploring HCatalog: HDFS Table and Metadata
Management
In the previous examples, the source use for our Hive table is an HDFS path.
This is common within the Hadoop ecosystem. While referencing these
