tHiveLoad it is not a sql query, it is more similar to sqoop, bcp or mysqlimport commands and all of them do not mean sql-style comments because it is not a code, it is commands.
if you want to have some comments in Talend Job - use Documentation tab of tHiveLoad component, there is a proper place for comments in Talend