title: HIVE STRING TO DATE CASTING
body: <p>I am facing problem in converting string to date type. While importing the data using hive I have got a column activation_date with type string (as I was unable to import it as date type) and I want to convert it into date type.</p>
  
  <p>Example</p>
  
  <p>Activation_date
  7-MAR-13
  12-APR-12</p>
  
  <p>I want it as 07-03-2013 in hive.</p>