The process for running an R script using the Aster Stream function is shown here.
- Use the ta.create() function to create a data table in the Aster Database.
The function input can be an Aster Database table or view.
- Create the R script.
An R script for the Stream function must include reading input from STDIN and writing output to STDOUT. If the script output columns are different from the input table columns, the user must define the names and data types of the output columns inside the script.
- Install the script onto the Aster Database.If the user needs to update an existing script, the previous version must first be removed or uninstalled before installing the updated version.
- Install any additional required files, such as dictionaries for text applications or models for prediction applications, onto the Aster Database.
- Execute the SQL-MR Stream function that specifies the script, the input table, any additional resources required, and the output columns.