Support Questions
Find answers, ask questions, and share your expertise

Can we use Sqoop to retrieve data from MS SQL Server function using this syntax "Select X,Y,Z from MyFunction()" ?

Highlighted

Can we use Sqoop to retrieve data from MS SQL Server function using this syntax "Select X,Y,Z from MyFunction()" ?

Contributor

They can't test right now so I am wondering if someone has already done that.

Thanks !

2 REPLIES 2
Highlighted

Re: Can we use Sqoop to retrieve data from MS SQL Server function using this syntax "Select X,Y,Z from MyFunction()" ?

@mlanciaux I don't think it's possible. You will have to run that sql to store data in mssql and then sqoop the new data.

Highlighted

Re: Can we use Sqoop to retrieve data from MS SQL Server function using this syntax "Select X,Y,Z from MyFunction()" ?

If it does not work directly, you can also try creating a MS SQL view and select * from your_view.