Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

FROM SQL Server 2016 when i try to run a query i am getting Could not obtain block

FROM SQL Server 2016 when i try to run a query i am getting Could not obtain block

New Contributor

Hi,

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?

regards,

Sendhil

1 REPLY 1

Re: FROM SQL Server 2016 when i try to run a query i am getting Could not obtain block

New Contributor

@Sendhil Murugan just wondering did you resolve this issue? I encountered the same problem and could not find a solution..