Why sp_execute_external_script doesn't return column names of data frame ?
Using R inside SQL server, in most cases, it's not possible to specify output columns before executing script. Using the RESULT SETS UNDEFINED clause, SQL server returns columns with no name.
Upvotes: 5<=-=Feb 27 2017 11:17AM=-=>
This is a known issue. We will take a look at fixing it for vNext.
Any word on a fix for this known issue?
Having R available in-database is great. But the inability to infer column names from a data frame mostly negates my opportunities to use the feature.