Sqoop export SQL server

[Avinash U <av...@gmail.com>]

Hi team,

Any one faced issue with sqoop export to SQL server file had 24 columns and throwing an error ' the incoming request has too many parameters . The server supports a maximum of 2100 parameters . Reduce the number of parameters ... ' ... Executing via oozie 
Thanks
Avinash yeluri 

Re: Sqoop export SQL server

[avinash yeluri <av...@gmail.com>]

Hi Abraham,
Can't paste the --logs but i can explain the scenario.

i have 1170 rows in hdfs trying to export to sql server. In verbose it says
4 input splits and and 4 tasks are running simultaneously as i understand
and hanging after some time or fails with
"Cased by: java.io.IOException: com.microsoft.sqlserver.jdbc.sqlserver .The
incoming request has too many parameters .The Server supports a maximum of
2100 parameters.Reduce the number of parameters and resend the request.

at
org.apache.sqoop.mapreduce.AsyncSqlRecordWriter.write(AsyncSqlRecordWriter.java:220)

after that i kept export.records.per.statement = 50 and completed loading
the values for 1170 rows .. this happened for this particular scenario
other jobs(which has 100 rows 200rows 20 rows dataset has successful
without any issue) .

Do we have issue with simultaneous commits or socket closed or any issue
with sqlserver ?

attaching the image logs



On Thu, Jul 23, 2015 at 5:28 PM, Abraham Elmahrek <ab...@cloudera.com> wrote:

> Hey man,
>
> Can you run the job with --verbose and paste the output here?
>
> -Abe
>
> On Thu, Jul 23, 2015 at 9:41 AM, Avinash U <av...@gmail.com>
> wrote:
>
>> The server supports a maximum of 2100 parameters
>
>
>
>


-- 
Best Regards
Avinash Yeluri
Ph:no 408-307-3786

Re: Sqoop export SQL server

[Abraham Elmahrek <ab...@cloudera.com>]

Hey man,

Can you run the job with --verbose and paste the output here?

-Abe

On Thu, Jul 23, 2015 at 9:41 AM, Avinash U <av...@gmail.com> wrote:

> The server supports a maximum of 2100 parameters