Phoenix and Tableau

2016-01-28 Thread Riesland, Zack
Hey folks, Everything I've read online about connecting Phoenix and Tableau is at least a year old. Has there been any progress on an ODBC driver? Any simple hacks to accomplish this? Thanks!

Re: Announcing phoenix-for-cloudera 4.6.0

2016-01-28 Thread Andrew Purtell
Looking today On Tue, Jan 26, 2016 at 11:00 PM, Kumar Palaniappan < kpalaniap...@marinsoftware.com> wrote: > Andrew, any updates? Seem HBase-11544 impacted the Phoenix and CDH 5.5.1 > isnt working. > > On Sun, Jan 17, 2016 at 11:25 AM, Andrew Purtell > wrote: > >>

Phoenix Query exception on few tables

2016-01-28 Thread kannan.ramanathan
We have started seeing PhoenixIOException exception from select query on few of our tables. The same query worked before. The query is simple select query and the exception is below: org.apache.phoenix.exception.PhoenixIOException: org.apache.phoenix.exception.PhoenixIOException: The system

Re: Phoenix and Tableau

2016-01-28 Thread Thomas Decaux
Yeah me too :/ i tried Spark , it works fine with Tableau on Mac. You should give a try! Le 28 janv. 2016 8:30 PM, "Aaron Bossert" a écrit : > Nice! It's a start...unfortunately, I use the OS X verSion. > > -- > Aaron > > On Jan 28, 2016, at 2:26 PM, Thomas Decaux

Re: Phoenix and Tableau

2016-01-28 Thread Thomas Decaux
They said only for windows OS Le 28 janv. 2016 6:36 PM, "Aaron Bossert" a écrit : > Sorry for butting in, but do you mean that tableau supports JDBC drivers? > I have wanted to connect Phoenix to tableau for some time now as well, but > have not seen any documentation from

Re: Phoenix and Tableau

2016-01-28 Thread Josh Mahonin
Hey Thomas, That's pretty neat if I read that right. You're able to use Tableau with Phoenix using the Phoenix-Spark integration? Thanks! Josh On Thu, Jan 28, 2016 at 2:31 PM, Thomas Decaux wrote: > Yeah me too :/ i tried Spark , it works fine with Tableau on Mac. > >

Re: Telco HBase POC

2016-01-28 Thread Vijay Vangapandu
Hi Guys, There is small confusion in below email. There is no deserialization issue in apache phoenix layer. Response times breakdown in the below email is by using phoenix and it’s pretty good. What i am talking about is a java client library we created to deserialize the data from phoenix

Re: Phoenix and Tableau

2016-01-28 Thread Aaron Bossert
Sorry for butting in, but do you mean that tableau supports JDBC drivers? I have wanted to connect Phoenix to tableau for some time now as well, but have not seen any documentation from tableau to suggest that they now support JDBC drivers. Just references to using a JDBC-ODBC bridge driver,

Re: Find and kill long-running queries

2016-01-28 Thread James Taylor
This sounds like a good idea. Please file a JIRA and we'll get this on the roadmap. What tooling are you using, and would support for Statement.cancel() do the trick? On Wed, Jan 27, 2016 at 7:27 PM, Ken Hampson wrote: > I would be interested in this as well, knowing how

Re: Phoenix and Tableau

2016-01-28 Thread Thomas Decaux
They (Tableau) said yes, i didnt try yet Le 28 janv. 2016 9:08 PM, "James Taylor" a écrit : > @Thomas - so Tableau has support for JDBC on Windows OS? > > On Thu, Jan 28, 2016 at 11:48 AM, Alex Kamil wrote: > >> Zack, you can also use Simba ODBC

Re: Using Sqoop to load HBase tables , Data not visible via Phoenix

2016-01-28 Thread rafa
Hi Manya, see this thread: http://mail-archives.apache.org/mod_mbox/incubator-phoenix-user/201512.mbox/%3CCAOnY4Jd6u9T8-Ce2Lp54CbH_a8zj41FVc=iXT=z8hp8-mxv...@mail.gmail.com%3E http://phoenix.apache.org/faq.html#How_I_map_Phoenix_table_to_an_existing_HBase_table regards, rafa On Thu, Jan 28,

Re: Using Sqoop to load HBase tables , Data not visible via Phoenix

2016-01-28 Thread Ravi Kiran
Hi Manya, We are working with the Sqoop team to have our patch[1] that enables data imports to Phoenix table directly. In the mean time, you can apply the patch to Sqoop 1.4.6 source and give it a try. Please do let us know how it goes . [1] https://issues.apache.org/jira/browse/SQOOP-2649

Re: to_date not working as expected

2016-01-28 Thread James Taylor
Hi Binu, Phoenix has never supported HBase 0.96, so I'm not sure where you got the release from. I recommend upgrading to a later, supported version of HBase and a later version of Phoenix. Give the 4.7.0 RC a try. One other tip in particular for views you create over existing HBase tables. Use

Re: Announcing phoenix-for-cloudera 4.6.0

2016-01-28 Thread Andrew Purtell
I pushed a new branch for CDH 5.5 (5.5.1) as https://github.com/chiastic-security/phoenix-for-cloudera/tree/4.6-HBase-1.0-cdh5.5 and renamed the branch for CDH 5.4 to https://github.com/chiastic-security/phoenix-for-cloudera/tree/4.6-HBase-1.0-cdh5.4 The changes in 4.6-HBase-1.0-cdh5.5 pass unit

Re: Phoenix and Tableau

2016-01-28 Thread Thomas Decaux
You can use jdbc driver already, also, you could use Spark as a proxy between. Le 28 janv. 2016 5:47 PM, "Riesland, Zack" a écrit : > Hey folks, > > > > Everything I’ve read online about connecting Phoenix and Tableau is at > least a year old. > > > > Has there been

Re: Announcing phoenix-for-cloudera 4.6.0

2016-01-28 Thread Kumar Palaniappan
Andrew, is it HBase 1.1? https://github.com/chiastic-security/phoenix-for-cloudera/tree/4.6-HBase-1.0-cdh5.5 On Thu, Jan 28, 2016 at 6:51 PM, Andrew Purtell wrote: > I pushed a new branch for CDH 5.5 (5.5.1) as >

Re: Announcing phoenix-for-cloudera 4.6.0

2016-01-28 Thread Andrew Purtell
The HBase version in the 5.5 POM is 1.0.0-cdh-5.5.1. It appears to be HBase 1.0.x plus some patches backported from trunk. > On Jan 28, 2016, at 9:07 PM, Kumar Palaniappan > wrote: > > Andrew, is it HBase 1.1? > > >