How to call a stored procudre in Sqoop

[#1]

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: --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')

[#2 · Accepted solution]

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.