Dear Biswa,

Hope you are doing well

Kindly accept our sincere apologies for the delay.

What Is the use of below /* */ comment.

This is  a C-style comment which should be placed immediately following the SELECT. It directs Hive to load aliasname (which is a table of very small size) into memory.

Hope this resolves your query

In case of any further issue,feel free to revert.