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

[#1]

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

Thanks !

[#2]

@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.

[#3]

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