hd.hive.select driver=hiveserver2 hql='SELECT linkid from mwrecord' out='tmp/linkid.hql'
See also related wiki page.