title: How to load csv file in hive table?
body: <p>I create table in hive and load csv file also from hdfs but when try to perform select query on created table I am getting results in encrypted format, can you please provide solution for this.</p>
  
  <pre><code>create table if not exists studentsinforamtion(
    studentnumber string ,
    universityname  string,
    collegename   string,
    studentname string, 
    branch string, 
    percentage string,
    areaters string,
    rankatuniversity INT,
    eligibleforcompnay string,
    selectedcompanylist int) 
  ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
  stored as textfile;
  
  load data inpath '/user/root/jobportal/studentinfo.ods' overwrite into table studentsinforamtion;
  
  select * from studentsinforamtion limit 5;
  </code></pre>
  
  <p>ERROR:</p>
  
  <pre><code>OK
  PK5:�C�l9�.mimetypeapplication/vnd.oasis.opendocument.spreadsheetPK5:�C�{C44meta.xml&lt;?xml version="1.0" encoding="UTF-8"?&gt;  NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL    NULL
  &lt;office:document-meta xmlns:office="urn:oasis:names:tc:opendocument:xmlns:office:1.0" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:meta="urn:oasis:names:tc:opendocument:xmlns:meta:1.0" xmlns:ooo="http://openoffice.org/2004/office" xmlns:grddl="http://www.w3.org/2
  </code></pre>