Support Questions
Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Innovation Accelerator group hub.

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

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 .

1 ACCEPTED SOLUTION

@Anurag Mishra,

Run your script as below

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

Thanks,

Aditya

View solution in original post

1 REPLY 1

@Anurag Mishra,

Run your script as below

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

Thanks,

Aditya