I have created an Hadoop environment using HDP 2.4 on an Azure environment. I have create external table using SQL Server with proper data source and file format.
When i select top 1000 rows on the external table, i am getting this error:
Cannot execute the query "Remote Query" against OLE DB provider "SQLNCLI11" for linked server "(null)". Could not obtain block: BP-595454498-172.16.137.143-1456768655900:blk_1073742471_1656 file=/input/test.csv
Could you please let me know what is wrong?
@Sendhil Murugan just wondering did you resolve this issue? I encountered the same problem and could not find a solution..