I am going through documentation mentioned here https://github.com/apache/pinot/issues/8260. and https://docs.pinot.apache.org/users/user-guide-query/query-syntax/joins#joins-overview