title: Update , SET option in Hive
body: <p>I know there is no update of file in Hadoop but in Hive it is possible with syntactic sugar to merge the new values with the old data in the table and then to rewrite the table with the merged output but if I have the new values in another table then I can achieve the same effect by using a left outer join.</p>
  
  <p>The problem in my case is that I have to update the table by setting one value to a column with some <code>where</code> condition. It is known that <code>SET</code> is not supported.</p>
  
  <p>For example, consider the below normal query:</p>
  
  <pre><code>UPDATE temp1
  SET location=florida
  WHERE id=206;
  </code></pre>
  
  <p>I tried to convert the same in Hive but I got stuck in the place of <code>SET</code>. If anyone let me know then it would be a great help for me.</p>