Re: Error while attempting join query

2016-04-07 Thread James Heather
I'm also interested to hear about this! Please do give more info! On 7 Apr 2016 7:00 p.m., "James Taylor" wrote: > I'm interested in the "how". Thanks for sharing this info, Steve. > > James > > On Thu, Apr 7, 2016 at 8:30 AM, Steve Terrell >

Re: Error while attempting join query

2016-04-07 Thread Steve Terrell
OK, check out http://stackoverflow.com/questions/32208549/how-to-use-newer-versions-of-hbase-on-amazon-elastic-mapreduce . Worked for me! I'm using EMR AMI.3.10.0 . On Thu, Apr 7, 2016 at 1:00 PM, James Taylor wrote: > I'm interested in the "how". Thanks for sharing

Re: Error while attempting join query

2016-04-07 Thread James Taylor
I'm interested in the "how". Thanks for sharing this info, Steve. James On Thu, Apr 7, 2016 at 8:30 AM, Steve Terrell wrote: > I've been successful at running HBase 0.98.15 and Phoenix 4.6.0 on EMR. > Found someone else's solution for this on the internet. Been

Re: Error while attempting join query

2016-04-06 Thread Deepak Gopalakrishnan
Hello All, I apologise if I sounded persistent. It was not my intention at all, was just adding more detail to the thread in hope of getting a solution. I completely understand the issue, but Amazon EMR does not support anything > 0.94.18. But, we've decided to move away from EMR and embrace

Re: Error while attempting join query

2016-04-06 Thread Josh Elser
(-cc dev@phoenix) Deepak, As the name suggests, that release is targeted for HBase-0.98.x release lines. Any compatibility of an older release of HBase than 0.98 is likely circumstantial. I can't speak on behalf of the HBase community, but I feel relatively confident in suggesting that it

Re: Error while attempting join query

2016-04-06 Thread Deepak Gopalakrishnan
Hello All, Does the package available here : http://a.mbbsindia.com/phoenix/phoenix-4.6.0-HBase-0.98/bin/ support HBase-0.94.18 ? If not, is there a version that is supported for HBase-0.94.18 ? Please help! On Wed, Apr 6, 2016 at 10:42 AM, Deepak Gopalakrishnan wrote: >

Re: Error while attempting join query

2016-04-05 Thread Deepak Gopalakrishnan
Adding Dev group On Wed, Apr 6, 2016 at 10:35 AM, Deepak Gopalakrishnan wrote: > Hello All, > > I did move on to 4.7 and my HBase version is 0.98+. Below is the script I > execute in order to get it installed before HBase is started. > > > > After doing this on all nodes (

Re: Error while attempting join query

2016-04-05 Thread Deepak Gopalakrishnan
Hello All, I did move on to 4.7 and my HBase version is 0.98+. Below is the script I execute in order to get it installed before HBase is started. After doing this on all nodes ( including master ), when I try a ./sqline.py localhost, it just freezes and doesnt proceed. Can someone please help

Re: Error while attempting join query

2016-04-05 Thread Deepak Gopalakrishnan
Hello James, Sure I understand. But any idea why JOIN fails on the server ? Is it not supported on 2.1.2 ? Thanks Deepak On Tue, Apr 5, 2016 at 9:48 PM, James Taylor wrote: > Support for the 2.x line was dropped over a year ago. I'd recommend > encouraging the EMR

Re: Error while attempting join query

2016-04-05 Thread James Taylor
Support for the 2.x line was dropped over a year ago. I'd recommend encouraging the EMR folks to upgrade to the latest version of Phoenix and HBase. On Tuesday, April 5, 2016, Deepak Gopalakrishnan wrote: > Hello, > > I'm trying to join two tables that I created using Phoenix.

Error while attempting join query

2016-04-05 Thread Deepak Gopalakrishnan
Hello, I'm trying to join two tables that I created using Phoenix. My tables are A and B. I've setup phoenix on EMR using https://phoenix.apache.org/phoenix_on_emr.html. I've used the phoenix-2.1.2 version and I can do basic queries like SELECT. But when I try a join, I get an error. It looks