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.

SQOOP Export to SQL Server fails with error message saying more than 2100 parameters are passed?

Highlighted

SQOOP Export to SQL Server fails with error message saying more than 2100 parameters are passed?

New Contributor

SQOOP Export to SQL Server fails with error message saying more than 2100 parameters are passed?

2 REPLIES 2

Re: SQOOP Export to SQL Server fails with error message saying more than 2100 parameters are passed?

Is it SQLServer? Can you please mention how many records are you trying to export, how many mappers you are using, and the size of the file?

Re: SQOOP Export to SQL Server fails with error message saying more than 2100 parameters are passed?

Expert Contributor

try adding this parameter to your sqoop job

-D sqoop.export.records.per.statement=100

you can micro batch your transactions.