How to call a stored procudre in Sqoop

das_dineshk — Wed, 14 Jun 2017 16:22:05 GMT

While trying to call a stored procedure in sqoop eval its throwing be below error.

I wanted to truncate table before sqoop export using stored procedure.

can I please get some helps from the experts!!

<arg>${passwordAlias}</arg>
            <arg>--query</arg>
            <arg>p_filter_tbl('${FTabName}')</arg>

Error

2296 [main] ERROR org.apache.sqoop.tool.BaseSqoopTool - Unrecognized argument: --call

2296 [main] ERROR org.apache.sqoop.tool.BaseSqoopTool - Unrecognized argument: p_filter_tbll('PF_STG')

2296 [main] ERROR org.apache.sqoop.tool.BaseSqoopTool - Unrecognized argument: p_filter_tbl('PF_STG')

Re: How to call a stored procudre in Sqoop

ssahi — Wed, 14 Jun 2017 22:07:22 GMT

Hi @Dinesh Das

You might have better luck passing in the actual TRUNCATE TABLE statement in your sqoop eval using the --query option instead of trying to --call the stored procedure (I think those are only supported in sqoop export, not sqoop eval, but I could be mistaken).

As always, if you find this post useful please "accept" the answer.

question How to call a stored procudre in Sqoop in Archives of Support Questions (Read Only)

How to call a stored procudre in Sqoop

Re: How to call a stored procudre in Sqoop