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?

New Contributor

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

2 REPLIES 2

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?

Expert Contributor

try adding this parameter to your sqoop job

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

you can micro batch your transactions.