title: hive read map value
body: <p>Here is my data in a file which i have successfully loaded into a table test and successfully get the data for:</p>
  
  <pre><code>Select * from test;
  
  
  
  Name    ph        category
  
  Name1    ph1    {"type":1000,"color":200,"shape":610}
  Name2    ph2    {"type":2000,"color":200,"shape":150}
  Name3    ph3    {"type":3000,"color":700,"shape":167}
  </code></pre>
  
  <p>But when i execute this query:</p>
  
  <pre><code>select category["type"] from test;
  </code></pre>
  
  <p>I get null values;</p>
  
  <p>Please help.
  Thanks
  Sai</p>