title: how to load .dat file to hive or hdfs?
body: <p>how to load  .dat file to hive or cloudera or hdfs?</p>
  
  <p>is it necessary to convert this format to structured format by using pig?</p>
  
  <p>if it is yes can someone gives pig script to convert this to structure data? </p>
  
  <p>My data looks like this when i open .dat file in notepad++</p>
  
  <pre><code>Americas¤AME  ¤ZONE¤ ¤¤¤Active¤
  Asia-Pacific¤APA  ¤ZONE¤ ¤¤¤Active¤
  Europe¤EUR  ¤ZONE¤ ¤¤¤Active¤
  Middle East, India and Africa¤MAI  ¤ZONE¤ ¤¤¤Active¤
  Unidentified¤999  ¤ZONE¤ ¤¤¤Active¤
  Afghanistan¤AF   ¤COUNTRY¤ ¤MAI  ¤ZONE¤Active¤3
  Albania¤AL   ¤COUNTRY¤ ¤EUR  ¤ZONE¤Active¤1
  Algeria¤DZ   ¤COUNTRY¤ ¤MAI  ¤ZONE¤Active¤3
  American Samoa¤AS   ¤COUNTRY¤ ¤APA  ¤ZONE¤Active¤3
  Andorra¤AD   ¤COUNTRY¤ ¤EUR  ¤ZONE¤Active¤1
  Angola¤AO   ¤COUNTRY¤ ¤MAI  ¤ZONE¤Active¤1
  </code></pre>