How to proceed 2 executions in 1 step in hive? I am wondering if there is a way to proceed 2 exectuions in 1 step in hive.
For example:

SELECT * FROM TABLE1
SELECT * FROM TABLE2
;


Do this in one window, and do not have to open 2 hive windows to execute each line separetly.

Can it be done on HUE?
You can use HiveCLI Tool to run HiveQL with a given sql file.


  $HIVE_HOME/bin/hive -f /home/my/hive-script.sql


Please see official document: https://cwiki.apache.org/confluence/display/Hive/LanguageManual+Cli

What you need to do is to


Put your HiveQLs in a file as below
SELECT * FROM TABLE1;
SELECT * FROM TABLE2;
Use HiveCLI and run with above file