I recently installed SQL Server 2017 on my machine and configured both Python & R services.
When running below code I am getting "STDERR" message along with the actual output.
Can someone please help me understand why I'm getting that error and how to fix it? Thanks in advance.
exec sp_execute_external_script
@language=N'R'
, @script=N'print(R.version)'
go
I assume you are running SQL server 2017 CU13, (or later CU), as what you see is a bug introduced in CU13. What you see should not be a problem, it is a warning, and t is due to an incompatibility with the R package CompatibilityAPI.
The anwwer is also in this thread: https://social.technet.microsoft.com/Forums/en-US/6ab7a0ca-836f-4d18-ac49-3239d610413d/getting-quotstderr-messages-from-external-scriptquot-message-showing?forum=MicrosoftR