Database and Analytics

W14 Using Hive and Hive ODBC with HDInsight and Power BI


1:30pm - 2:45pm

Level: Introductory to Intermediate

Steve Hughes

Steve Hughes

Business Intelligence Architect

Pragmatic Works

Has your company started working with or proposed working with Hadoop? How can you as a developer work with Hadoop data in a simple fashion? In this session, you'll learn how to use Hive to interact with data stored in an HDInsight cluster. You'll examine the details of applying schemas using DDL and executing queries with HiveQL to retrieve data from the Hadoop structure. You'll also look at how Power BI can use this to display data in compelling fashion using the ODBC driver from Microsoft.

You will learn:

  • How to use Hive to apply schemas to data in Hadoop
  • How to use Hive to query data from Hadoop
  • How to use Microsoft's ODBC Hive driver to use Hive in other applications