title: change one key-value in map columns in hive table via HQL
body: <p>I have a Hive table whose schema is as below, the <code>col</code> is of <code>map</code> type:</p>
  
  <pre><code>select
      col
  from table
  
  col
  {"name":"abc", "value":"val_1"}
  </code></pre>
  
  <p>What I need to do is change the <code>val_1</code> to <code>val_2</code> and create another table from it.</p>
  
  <pre><code>create table table_2 as
  select
      col -- TODO: need to do something here
  from table
  </code></pre>
  
  <p>Any suggestions? Thanks!</p>