Getting last year in Hive , using dual table as in oracle .

There is a simple command although it would run map reduce but still in case required .

last_year=$(hive -e "select year('${current_date}')-1")

last_year variable will have value required , or we can add any command as per scenario.