@Ken Jiiii You could create another file and call it from h_script.hql, or you just add lines to h_script.hql like the following: This set statements will override the global settings for that specific job session. Example of line: set mapred.reduce.tasks=32;
Almost anything that is Hive global environments XML is game for override at session level. Look at this post: https://community.hortonworks.com/articles/22419/hive-on-tez-performance-tuning-determining-reducer.html This shows a lot of these set statements which you can include in your set_h_script.hql invoked from h_script.hql or in the block added the beginning of your h_script.hql. Personally, I prefer a separate file invoked from my job script.
... View more
