enclose columns in quotes using hiveql
<pre><code>Hive Version 0.13
</code></pre>

<p>I am having a column in hive which needs to be enclosed in double quotes </p>

<p>I am trying with the below query but the output is returned as NULL</p>

<pre><code>select "\""+notes_detail+"\"" from  service_request_notes.TSS_INCIDENT_NOTES_F_SAMPLE limit 1;
</code></pre>

<p>where as the output should be this </p>

<pre><code>select notes_detail from  service_request_notes.TSS_INCIDENT_NOTES_F_SAMPLE limit 1;
</code></pre>

<p>Job 0: Map: 106   Cumulative CPU: 151.24 sec   MAPRFS Read: 0 MAPRFS Write: 0 SUCCESS
Total MapReduce CPU Time Spent: 2 minutes 31 seconds 240 msec
OK
notes_detail
From: scottw@acespower.com</p>