title: Hive External table-CSV File- Header row
body: <p>Below is the hive table i have created:</p>
  
  <pre><code>CREATE EXTERNAL TABLE Activity (
    column1 type, &lt;/br&gt;
    column2 type
  )
  ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
  LOCATION '/exttable/';
  </code></pre>
  
  <p>In my HDFS location /exttable, i have lot of CSV files and each CSV file also contain the header row. When i am doing select queries, the result contains the header row as well.</p>
  
  <p>Is there any way in HIVE where we can ignore the header row or first line ?</p>