Column name or type mismatches
Column names, column types, and column count specified in the R Execute operator must match those returned by the R script.
If Pass Output Table/Pass Output File is set to Yes and Results Table Structure/Results File Structure is provided, but the output data frame returned by R has different column names, column types or column count than that specified in Results Table Structure/Results File Structure, then the R Execute operator displays an error reporting that part of the flow is terminated. This error report informs you that what the specified inputs for the subsequent operator is at odds with what R actually returned.
You can either change the names or types in Results Table Structure/Results File Structure to match those that R returns (and adjust the subsequent operators), or you can change the R script so that the R output matches Results Table Structure/Results File Structure.
For example, if you expect an integer column (for example, for database storage), but R returns a floating-point number, then the column type can be changed to a FLOAT or DOUBLE, or you can cast the floating-point values for that data frame column to an integer using the R function call as.integer().
Execution of 'R Execute' failed. Error details: There is a mismatch between the column names in the 'Results Table Structure' and those returned by R. Expected column names: [humidity, outlook, temperature, wind] Returned column names: [humidity, outlook, play, temperature, wind]
or
Execution of 'R Execute' failed. Error details: There is a mismatch between the column types in the 'Results Table Structure' and those returned by R. Column 'play': Expected INTEGER, returned VARCHAR. Please correct types returned by R to match design time types or change design tme types to match.
The status results provide an option to download the SQL log for further information.