Excel Add-In for Apache Hive

Connect to live Apache Hive from Excel

The Apache Hive Excel Add-In is a powerful tool that allows you to connect with Apache Hive, directly from Microsoft Excel. The Add-In maps SQL queries to HiveQL, enabling direct standard SQL-92 access to Apache Hive-compatible distributions. Perfect for mass exports, Excel-based data analysis, and more!

  download   buy now

CData Excel Add-In for Apache Hive
 Included in Excel Add-In Subscriptions: 125+ Excel data access Add-Ins.

Your Apache Hive Data, Your Way!

The Excel Add-In for Apache Hive provides the easiest way to connect with Apache Hadoop Hive data. Users simply supply their credentials via the connection wizard to create a connection and can immediately begin working with live Apache Hadoop Hive tables of data. The Excel Add-In is completely self-contained; no additional software installation is required.

Direct Access To Live Apache Hadoop Hive Data From Excel

The Excel Add-In for Apache Hive is integrated with the Excel toolbar and ribbon, providing direct access to live data with a single click.

Easy-To-Use, Straightforward Configuration:

  1. Install the Add-In
  2. Login with User & Password
  3. Select Tables

Installing any of the Excel Add-Ins creates a new CData data access toolbar in Excel that users can access to connect to remote data. From the Excel toolbar, users can select any of the installed CData Add-Ins to configure a connection.

Select Tables and Columns

Once the data connection is configured, just specify the table and the Excel Add-In will populate a new Excel sheet with live Apache Hadoop Hive Data.

Apache Hadoop Hive Data With The Full Power of Excel

Perfect for mass imports / exports / updates, data cleansing & de-duplication, Excel based data analysis, and more!

  • Quickly export and backup data.
  • Operate on data with Charts and Pivot Tables.