phoenix join operation not working with hbase

Question

I am using hbase-1.1.0.1 and phoenix-4.4.0-HBase-1.1-bin versions. To run SQL query I am using SQuirrel SQL client.

Simple queries such as Select *, Select count(*), where clause and sub queries are working fine, but JOIN operation is not working at all. Please help me on this.

Answer 1

I got the solution for this. Actually I did a mistake where I copied "phoenix-core-4.4.0-HBase-1.1.jar" into my hbase's lib directory. When I replaced it with "phoenix-4.4.0-HBase-1.1-server.jar" problem got resolved ! Now join operation is working.