Hey @smdas , thanks for your feedback, i will rephrase it for better understanding. Hive table name =hive_t1 External hive hbase table name= hb_t2 They both have identical data as per now 100 rows each Senario 1: Select t1.c1,t1.c2 from hive_t1 t1 left join(select KEY, c1 from hb_t2 where KEY like 'abc%') t2on (t1.c1=t2.c1); Here the values which i get from hbase external table are null , but expected results should be having matching values.  When i was analysing found these results also. Senario 2: select KEY, c1 from hb_t2 where KEY like 'abc%'; => returns 0 rows or no result But if i run this  select * from hb_t2 where KEY like 'abc%'; => Then i am able to see the data all the 100 rows, not able to understand this behaviour.   -Shivam   ... View more