title: Skip first line of csv while loading in hive table
body: <p><strong>Hello Friends,</strong></p>
  
  <p>I created table in hive with help of following command - </p>
  
  <pre><code>CREATE TABLE db.test 
    ( 
       fname STRING, 
       lname STRING, 
       age   STRING, 
       mob   BIGINT 
    ) row format delimited fields terminated BY '\t' stored AS textfile; 
  </code></pre>
  
  <p>Now to load data in table from file, I am using following command -</p>
  
  <pre><code>load data local inpath '/home/cluster/TestHive.csv' into table db.test;
  </code></pre>
  
  <p>Problem is, all the rows are getting inserted, and I don't want first row because it contains only column names.</p>
  
  <p>Please suggest me a way to skip first line.</p>
  
  <p><strong>Thanks in advance.</strong></p>