Hi, All bug fixes are applied to both the 3.0 and 4.0 branch, So the fix should appear in our upcoming 3.1/4.1 release. If you can track down the JIRA, I can double check for you.
Thanks, James On Tue, Jul 15, 2014 at 7:20 PM, ashish tapdiya <[email protected]> wrote: > Hi, > > I am using Phoenix secondary index and join functionality. > > I have two tables customer and orders. > I also have an index on customer non key attribute c_uname > > One join ordering works while other gives a type mismatch error especially > with the secondary index: > > The one that works: > explain select * from customer as c inner join orders as o on c.c_id = > o.o_c_id where c.c_uname ='RI'; > > The one that doesn't work: > explain select * from orders as o inner join customer as c on c.c_id = > o.o_c_id where c.c_uname ='RI'; > > Error msg:Error: ERROR 203 (22005): Type mismatch. expected: VARCHAR but > was: INTEGER at column: C.0:C_UNAME (state=22005,code=203) > > Phoenix version: 3.0 > HBase version: .94 > > I do see in the list that some one else had reported this error before and > its fixed in 4.0 release. I do not want to upgrade since i will have to > change entire stack from hadoop upwards. Is there a way to fix it in 3.0 > release? > > Thanks, > ~Ashish
