@Sindhu @Raja Sudhan I am not sure if you can perform SMB join in TEZ.I could clearly see SMB join in explain plan ,when I was running it on MR but it wasn't showing up in tez. You can find my query below https://community.hortonworks.com/questions/107180/is-smb-join-or-smb-map-join-enabled-in-tez.html#comment-108854 ... View more