Support Questions
Find answers, ask questions, and share your expertise

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?

Highlighted

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.

Don't have an account?