在Excel 2013中连接Hortonworks Hive ODBC时出错 [英] Error connecting Hortonworks Hive ODBC in Excel 2013

问题描述

我正在尝试通过Excel 2013中的ODBC驱动程序查询Hortonworks Hive.

I am trying to query Hortonworks Hive via ODBC Driver in Excel 2013.

我在这里下载了驱动程序(32位):

I downloaded the driver here (32-bit):

http://hortonworks.com/downloads/

Hortonworks 2.5 蜂巢2.5.0.0-1245

Hortonworks 2.5 Hive 2.5.0.0-1245

然后我将配置添加到ODBC数据源管理器(32位)中

Then I add the config in ODBC Data Source Administrator (32-bit)

一切似乎都很好.

然后，当我进入Excel 2013构建查询时:

Then when I go into Excel 2013 to build the query:

我收到此错误:

有人知道为什么吗?

推荐答案

问题是Hortonworks的Hive驱动程序.由于某些原因，它与Excel或Power BI不兼容.

The problem is the Hive driver from Hortonworks. For some reason, it's not compatible with Excel or Power BI.

我从 https://www .microsoft.com/en-us/download/details.aspx?id = 40886 ，一切运行正常.创建用户DSN时，请确保选择SASL而不是HTTP.

I downloaded Microsoft Hive ODBC from https://www.microsoft.com/en-us/download/details.aspx?id=40886 and everything works perfectly. Make sure to choose SASL and not HTTP when creating User DSN.

这篇关于在Excel 2013中连接Hortonworks Hive ODBC时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！