question Re: How to put data into hdfs from sqlserver on azure spark hdi in Archives of Support Questions (Read Only)

How to put data into hdfs from sqlserver on azure spark hdi

ash_darkstar99 — Tue, 21 Apr 2026 12:16:08 GMT

Hi I can read data from sqlserver. Converted it into ORC and now trying to push it into HDFS.

My PutHDFS config are below.

I'm just putting data into hdfs to PutHDFS is terminated at success. Can you guys please help me get past the error below

Re: How to put data into hdfs from sqlserver on azure spark hdi

arald — Tue, 17 Jul 2018 17:53:47 GMT

please check here for the config of the putHDFS processor to write to Azure: https://community.hortonworks.com/content/kbentry/71916/connecting-to-azure-data-lake-from-a-nifi-dataflow.html

Re: How to put data into hdfs from sqlserver on azure spark hdi

ash_darkstar99 — Wed, 18 Jul 2018 15:19:16 GMT

@Harald Berghoff I will try this and try to push data into HDFS. I'll update . Thanks

Re: How to put data into hdfs from sqlserver on azure spark hdi

ash_darkstar99 — Wed, 18 Jul 2018 18:11:12 GMT

@Harald Berghoff I tried the steps in the article. But I'm getting the same error. I was hoping that this would atleast change the error but it didn't . Any suggestions?

Re: How to put data into hdfs from sqlserver on azure spark hdi

ash_darkstar99 — Tue, 24 Jul 2018 22:55:30 GMT

The solution provided by @Harald via link is good enough as a solution. The only prequesite is that the cluster should be on top of Azure Data Lake and not azure datastorage. If its a cluster then solution should be replicated on all nodes. If it's only Edge node then solution should only be applied only edge node. By solution I mean the solution in https://community.hortonworks.com/content/kbentry/71916/connecting-to-azure-data-lake-from-a-nifi-dataflow.html. Thanks