Re: JOIN issue, getting errors

2015-09-09 Thread Aaron Bossert
I'm not sure if that was the problem, but last night, I decided to retrace my steps from installation onwards...it turns out that I failed to delete the old Phoenix server jar files from my 48 region servers. Once I placed a fresh copy of the jar file in there and deleted the old one, the

Re: JOIN issue, getting errors

2015-09-09 Thread Josh Mahonin
This looks suspiciously like https://issues.apache.org/jira/browse/PHOENIX-2169 Are you able to perform the same queries when the tables aren't salted? Also, what versions of HBase / Phoenix are you using? On Tue, Sep 8, 2015 at 12:33 PM, M. Aaron Bossert wrote: > All, > >

JOIN issue, getting errors

2015-09-08 Thread M. Aaron Bossert
All, Any help would be greatly appreciated... I have two tables with the following structure: CREATE TABLE NG.BARS_Cnc_Details_Hist ( ip varchar(30) not null, last_active date not null, cnc_type varchar(5), cnc_value varchar(50), pull_date date CONSTRAINT cnc_pk PRIMARY