https://community.cloudera.com/t5/Support-Questions/HdfsBridge-recordReaderFillBuffer-Unexpected-error/m-p/287913#M213319 <P>I have downloaded and configured HDP_2.6.5_virtualbox_180626, I am able to connect&nbsp; and&nbsp; upload files to HDFS and can access the files data using Hive.</P> <P>&nbsp;</P> <P>To access the data from HDFS files using SQL Server (PolyBase), i have configured the External table and File Table&nbsp;</P> <P>CREATE DATABASE SCOPED CREDENTIAL Hadoop_Cred WITH IDENTITY = 'raj_ops', Secret = 'raj_ops';<BR />GO<BR />CREATE EXTERNAL DATA SOURCE MyHadoopCluster WITH (<BR />TYPE = HADOOP,<BR />LOCATION ='hdfs://192.168.0.107:8020',<BR />CREDENTIAL = Hadoop_Cred<BR />);</P> <P>DROP EXTERNAL FILE FORMAT Hadoop_file_format<BR />CREATE EXTERNAL FILE FORMAT Hadoop_file_format WITH<BR />(<BR />FORMAT_TYPE = DELIMITEDTEXT,<BR />FORMAT_OPTIONS<BR />(<BR />FIELD_TERMINATOR =',',<BR />USE_TYPE_DEFAULT = TRUE<BR />)<BR />)</P> <P>&nbsp;</P> <P>CREATE EXTERNAL TABLE [dbo].HDFS_File<BR />(<BR />street varchar(100),<BR />city varchar(100),<BR />zip varchar(100),<BR />[state] varchar(100),<BR />beds int,<BR />baths int,<BR />sq__ft varchar(100),<BR />[type] varchar(100),<BR />sale_date varchar(100),<BR />price varchar(100),<BR />latitude varchar(100),<BR />longitude varchar(100)<BR />)<BR />WITH (<BR />LOCATION = N'/user/raj_ops/TP/',<BR />DATA_SOURCE =MyHadoopCluster,<BR />FILE_FORMAT =Hadoop_file_format,<BR />REJECT_TYPE = VALUE,<BR />REJECT_VALUE = 0<BR />);</P> <P>&nbsp;</P> <P>On accessing the table , i am getting the following error</P> <P>Msg 7320, Level 16, State 110, Line 33</P> <P>Cannot execute the query "Remote Query" against OLE DB provider "SQLNCLI11" for linked server "(null)".</P> <P>&nbsp;HdfsBridge::recordReaderFillBuffer - Unexpected error encountered filling record reader buffer: BlockMissingException: Could not obtain block: BP-243674277-172.17.0.2-1529333510191:blk_1073743046_2226 file=/user/raj_ops/TP/Sacramentorealestatetransactions.csv</P> <P>&nbsp;</P> <P>&nbsp;</P> Sun, 19 Jan 2020 13:42:51 GMT sufian 2020-01-19T13:42:51Z