Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

Solved Go to solution
Highlighted

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

Accepted Solutions

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

@Anurag Mishra,

Run your script as below

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

Thanks,

Aditya

1 REPLY 1

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

@Anurag Mishra,

Run your script as below

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

Thanks,

Aditya

Don't have an account?
Coming from Hortonworks? Activate your account here