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.