title: Storing result of query in hive variable
body: <p>In Hive,how to store the results of a query in a variable?
  I've tried the below command:
  SET hivevar:a=(Query);</p>
  
  <p>But instead of the result,query itself is getting stored.
  Is there any way for storing the results?</p>