We are using 4 node hbase cluster with phoenix with the following config:
We have two tables each containing 10 lac records. Whenever we run a query from any of the 4 clients ,which performs a join on these tables the region server crashes and we are unable to get any result. Our nodes are essentially 150Gb machines with 8 cores and 8 gb Ram except one which has 16 cores and 16gb ram. We are still analyzing Phoenix for our project. And we seem to have hit a roadblock.
Can anyone please let us know what is the problem here ?
Also, whenever we run join queries on tables having 1 lac records we can get results in 2-3 seconds.