title: How to resolve Rows were rejected while reading from external source(s) in sqlserver Data warehouse
body: <p>I have to load the data from datalake to sql server data warehouse using the polybase tables.I have created the set up for the creation of external tables.i have created the external table and trying to do select * from ext_t1 table but i'm getting the error as Rows were rejected while reading from external source(s).Below is my external table script.Can some help me on this issue? Thanks in advance.</p>
  
  <pre><code>CREATE EXTERNAL TABLE [dbo].[EXT_TEST1]
  ( A VARCHAR(10),B VARCHAR(20)) 
  (DATA_SOURCE = [Azure_Datalake],LOCATION = N'/A/Test_CSV/',FILE_FORMAT =csvfileformat,REJECT_TYPE = VALUE,REJECT_VALUE = 1)
  </code></pre>
  
  <p>Table got created but after querying the select statement i'm getting the below issue
  Rows were rejected while reading from external source(s). 
  2 rows rejected from external table [EXT_TEST1] in plan step 2 of query execution:
      Location: '/A/Test_CSV/abc.csv' Column ordinal: 1, Expected data type: VARCHAR(20) collate SQL_Latin1_General_CP1_CI_AS.
      Location: '/A/Test_CSV/abc.csv' Column ordinal: 1, Expected data type: VARCHAR(20) collate SQL_Latin1_General_CP1_CI_AS.</p>