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
