CODE EXAMPLE FOR SHELL

store select output hive

##store a result of select operation in your local .
insert overwrite local directory '/tmp/output' row format delimited fields terminated by '|' select * from wine_red;