Hi Madhu, Unfortunately Sqoop import does not ‘stored procedure’ yet. There is an apache jira which has been logged for the same: https://issues.apache.org/jira/browse/SQOOP-769 -Mahesh ...
Importing data from SQL server by calling a stored procedure in SQL server
I am using HDP 2. I was using Sqoop import earlier to import data from SQL server to HDFS by using queries. I would like to know if I can use stored procedures in the same way to import data. DBA suggested that their servers are getting impacted for doing query plan everytime we use queries. I need to change this as soon as possible.
If it is not possible with Sqoop, please suggest if I have any other Mapreduce or Distributed way of importing the data.
The topic ‘Importing data from SQL server by calling a stored procedure in SQL server’ is closed to new replies.
Support from the Experts
A HDP Support Subscription connects you experts with deep experience running Apache Hadoop in production, at-scale on the most demanding workloads.
Become HDP Certified
Real world training designed by the core architects of Hadoop. Scenario-based training courses are available in-classroom or online from anywhere in the world