在Mac中使用ODBC连接从Excel查询Hive时，HortonWorks“找不到表或视图”

I am using Hortonworks sandbox 2.1 with Apache Hive ODBC driver 2.1 and iODBC.

我正在使用Hortonworks沙盒2.1与Apache Hive ODBC驱动程序2.1和iODBC。

The ODBC connection is successful when I test it using the iODBC software. But, when I open excel and use Microsoft query to return the data to excel spreadsheet I get this error when I run SQL SELECT query

使用iODBC软件测试时，ODBC连接成功。但是，当我打开Excel并使用Microsoft查询将数据返回到excel电子表格时，我运行SQL SELECT查询时出现此错误

: [Hortonworks][SQLEngine] (31740) Table or view not found: HIVE.default.tweetsbi.

：[Hortonworks] [SQLEngine]（31740）未找到表格或视图：HIVE.default.tweetsbi。

I am able to view the tables inside the database, but I can't view the content of them. Whenever I press Run I get the aforementioned error.

我能够查看数据库中的表，但我无法查看它们的内容。每当我按Run，我都会得到上述错误。

I am getting the same error in both Excel 2011 and 2016

我在Excel 2011和2016中都遇到了同样的错误

2 个解决方案

#1

I've got it to work by :

我有它的工作：

Editing the configuration of Hortonworks Hive ODBC Driver by changing UseNativeQuery from 0 to 1.
通过将UseNativeQuery从0更改为1来编辑Hortonworks Hive ODBC驱动程序的配置。
Give permission to the user "sandbox"

授予用户“沙盒”权限
```
 hive
 grant SELECT on table tweetsbi to user sandbox;
```

#2

Congrats, that you found a solution! However it may be that you don't want to grant sandbox access to your tables. I regard it as a bug in the Hortonworks driver, that this default HIVE databasename appears in the path.

恭喜，您找到了解决方案！但是，您可能不希望授予对表的沙箱访问权限。我认为它是Hortonworks驱动程序中的一个错误，这个默认的HIVE数据库名称出现在路径中。

Another - more general purpose - solution: Install the Microsoft Hive driver. Works fine and doesn't have the bug :-)

另一个 - 更通用的 - 解决方案：安装Microsoft Hive驱动程序。工作正常，没有错误:-)

https://www.microsoft.com/en-us/download/confirmation.aspx?id=40886

ATB!

ATB！

Croco

鳄鱼

#1