Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

How to call a stored procudre in Sqoop

avatar
Expert Contributor

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

1 ACCEPTED SOLUTION

avatar
Guru
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login
1 REPLY 1

avatar
Guru
hide-solution

This problem has been solved!

Want to get a detailed solution you have to login/registered on the community

Register/Login