用于HBase/Phoenix的ODBC驱动程序 [英] ODBC driver for HBase/Phoenix

问题描述

我需要将Tableau连接到HBase或Phoenix，并且Tableau不支持JDBC.糟透了！

I need to connect Tableau to HBase or Phoenix and Tableau does not support JDBC. Bummer!

我已经阅读了有关Simba专有驱动程序的信息，但尚未看到有关使用它的人的任何报道.在不理想的时候，我不想花钱，而我的雇主也有同样的感觉.

I've read about the proprietary Simba driver but haven't seen any reports of people using it. I don't feel like forking over money when it's not ideal, and my employer feels the same way.

是否存在将Tableau连接到HBase或Phoenix的另一种方法?别人如何做?我不喜欢使用Hive连接到HBase的想法，因为离开Hive的主要原因之一是其性能不佳，所以我希望这不是我的最佳"选择.

Is there another way to connect Tableau to HBase or Phoenix? How are other people doing it? I don't like the idea of using Hive to connect to HBase because one of the main reasons to go away from Hive is its atrocious performance, so I hope that's not my 'best' alternative.

另一方面，如果人们使用过Simba并且效果很好，我很想知道这一点.

On the other hand, if people have used Simba and it works well, I'm curious to hear about that.

推荐答案

我是Simba Phoenix驱动程序的开发人员. Hortonworks，Cloudera，Databricks，Microsoft，Amazon，Google等都为各种产品选择Simba的驱动程序.

I am the developer on Simba's Phoenix driver. Hortonworks, Cloudera, Databricks, Microsoft, Amazon, Google, etc all choose Simba's drivers for a variety of products.

即. http://hortonworks.com/partner/simba/，

此外，您需要为所有应用程序选择HBase上的Phoenix或HBase独立版本.两种类型的驱动程序以不同的二进制表示形式编码数据.字符串和无符号整数将正确解释，但无符号整数和更复杂的数据类型将以不同的方式解码. IE. 凤凰城无法正确显示负整数值

Also, you need to choose either Phoenix on HBase or HBase standalone for all of your applications. The two types of drivers encode data in different binary representations. String and unsigned integers will be interpreted correctly, but unsigned integers and more complex data-types will be decoded differently. ie. Phoenix doesn't display negative integer values correctly

因此，如果在/应用程序中使用Phoenix JDBC，则您不能在Tableau中使用HBase ODBC驱动程序(除非您的数据源中只有字符串和无符号整数).在其他帖子中，您确实使用了Phoenix JDBC.因此，HBase ODBC不是您的选择.

So if you use Phoenix JDBC for your / applications, you cannot use an HBase ODBC driver with Tableau (unless you have nothing but strings and unsigned integers in your datasource). From your other postings, you do use Phoenix JDBC. So HBase ODBC is not an option for you.

这篇关于用于HBase/Phoenix的ODBC驱动程序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！