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

amol_08 — Fri, 10 Nov 2017 16:03:53 GMT

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 .

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

asirna — Fri, 10 Nov 2017 16:21:32 GMT

@Anurag Mishra,

Run your script as below

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

Thanks,

Aditya

question running hive operations from script and storing script output to a text file in Archives of Support Questions (Read Only)

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

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