![]() ]Ī list of values for the input parameters used by the external script. ' ]Ī list of input parameter declarations that are used in the external script. If the query can be parallelized, rows are distributed according to the MAXDOP setting.įor R scripts that use RevoScaleR functions, parallel processing is handled automatically and you should not specify = 1 to the sp_execute_external_script call. For example, when using the R predict function with a model to generate new predictions, set = 1 as a hint to the query engine. If = 1 and the output is being streamed directly to the client machine, then the WITH RESULT SETS clause is required and an output schema must be specified.įor R scripts that do not use RevoScaleR functions, using the parameter can be beneficial for processing large datasets, assuming the script can be trivially parallelized. The default for this parameter is 0 (no parallelism). Default value is OutputDataSet.Įnable parallel execution of R scripts by setting the parameter to 1. For Python, the output must be a pandas data frame. The data type of the variable in the external script depends on the language. Specifies the name of the variable in the external script that contains the data to be returned to SQL Server upon completion of the stored procedure call. In the case of Python, input must be tabular. ![]() In case of R, the input variable is a data frame. Specifies the name of the column used to segment data, such as geographic region or date. ![]() Specifies the name of the column used to order the result set, for example by product name. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |