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.