title: Flink SQL table backed by CSV with header
body: <p>I have been searching on google for the last 20 minutes. I have gone through the Apache Flink documentation too specifically the <a href="https://ci.apache.org/projects/flink/flink-docs-release-1.13/docs/connectors/table/formats/csv/" rel="nofollow noreferrer">CSV format</a> but haven't found a way to skip the first header row.</p>
  <p>The CSV looks like this:</p>
  <pre><code>AccountKey,InstrumentCode,Quantity,BuySell,Price
  SB11,MSFT,100,Buy,250.57
  SB11,AMZN,125,Sell,309
  </code></pre>
  <p>I really am looking for a property to set which will make the CSV reader skip the header row. The following table definition does not work:</p>
  <pre><code>CREATE TABLE trades (
      AccountNo varchar(10),
      Symbol varchar(10),
      Quantity integer,
      BuySell varchar(4),
      Price decimal    
  ) WITH ( 
      'connector' = 'filesystem',
      'path' = '/mnt/d/Work/Github/Flink-Samples/data/trade-data.csv',
      'format' = 'csv'  
  );
  </code></pre>
  <p>The error I see on sql-client.sh is:</p>
  <pre><code>[ERROR] Could not execute SQL statement. Reason:
  java.lang.NumberFormatException: For input string: &quot;Quantity&quot;
  </code></pre>
  <p>I expect the CSV reader reads the rows when I execute a</p>
  <pre><code>select * from trades
  </code></pre>
  <p>So far, the only way I have found is to put a # character to make the header appear as a comment and use the following table definition:</p>
  <pre><code>CREATE TABLE trades (
      AccountNo varchar(10),
      Symbol varchar(10),
      Quantity integer,
      BuySell varchar(4),
      Price decimal
  ) WITH ( 
      'connector' = 'filesystem',
      'path' = '/mnt/d/Work/Github/Flink-Samples/data/trade-data.csv',
      'format' = 'csv',    
      'csv.allow-comments' = 'true'
  );
  </code></pre>