Join does not returns result

A simple join of this format does not return expected result. Whereas individually, each table returns rows when queried.

SELECT a.item_id ,
FROM src_a
JOIN src_b b ON a.item_id = b.item_id
WHERE a.item_id = 51551446;

@HLNA it is hard to diagnose your problem without further details. Could you please share:

  • Query profile for this query.
  • Brief explanation of expected vs. observed results.

@can Thanks, it seems the issue was related to jdbc connection failures… on restart it worked fine.