Convert oracle code to hive to get variable from unix shell script to hive
<p>Following is the query: 
Oracle procedure query:</p>

<p><code>Select col_nam into VAR from table where &lt;conditions....&gt; ;</code>--- this brings the value into the variable which is then consumed by a function which uses it like...</p>

<pre><code>select colnam from tablename where variable2&gt;VAR;
</code></pre>

<p>Now how can be pull the value from the hive table to VAR variable in hive?</p>