You can check logs in /var/log/hive in Hive server
Take a look on this
Thank you. But I want to create a new log file with date and timestamp , which has only error msgs from the hive sql script . I want to save it in different folder in hdfs. Please help. Thank you.