running hive operations from script and storing script output to a text file

[#1]

I am trying to run a script which contains command hive -f hive.hql . This script asks user to provide input when it gets executed

flow of script :

sh myscript.sh > output.txt

then it asks user to provide input like service name, when user provide input like hive then some hive operations are executed like create , load and drop and all status like logging to hive and OK for creation of table , loading data into table and dropping table get displayed in console but this is not saved in text file. I want to save all this whatever displayed to text file but when hive logging initiates but nothing goes to output.txt .

[#2 · Accepted solution]

@Anurag Mishra,

Run your script as below

sh myscript.sh > output.txt 2>&1

Thanks,

Aditya