3.13.3 Row Predictions with Topic Modeling

This section describes how to generate predictions on a row of data with topic modeling.

Before You Begin

• Connect to your HeatWave Database System.

• Complete the steps to train the model with topic modeling. See Training a Model with Topic Modeling.

Generating Predictions with Topic Modeling

To generate predictions on a row of data with topic modeling:

1. Use the ML_MODEL_LOAD routine to load the model with topic modeling:

   mysql> CALL sys.ML_MODEL_LOAD(@topic_modeling, NULL);

2. Set the row data to generate a prediction for a JSON object literal. The following example includes the row data from the description column:

   mysql> SET @row_input = JSON_OBJECT('description', "Presidential Jet|Taichung Top Ten 
   Souvenirs|HWC Heiwo Coffee Product features: rich floral and lemon aroma, bright acid 
   value; Layered, from sour to sweet, unique lemon fragrance. Product Description: 
   Origin|Ethiopia Ethiopia Roast Level|Medium Light Processing Method|Washed Flavor 
   DescriptionTastingNotes|Floralscent, lemon, citrus, tropical fruit, lemon, Tangerine, 
   Tropical fruit Brewing method: It is recommended to brew and drink by hand Brewing 
   recommended temperature: medium and shallow roasted Yekashefi 90-92°C Hand 
   brewing thickness suggestion: a little thicker than No. 2 sugar, so that the coffee powder 
   can be extracted completely Product ingredients: 100% Arabica coffee beans Weight: 1/2 
   pound ");

   @row_input is a session variable containing a row of unlabeled data. The data is specified in JSON key-value format. The column names must match the feature column names in the training dataset.

3. Use the ML_PREDICT_ROW routine to generate the predictions with topic modeling:

   mysql> select sys.ML_PREDICT_ROW(@row_input, @topic_modeling, NULL);

   @topic_modeling is the session variable that contains the model handle. Update this name as needed.

To modify the number of word groups in the ml_results column, you can set the topk option. This option must be an integer greater or equal to one.

The following example generates predictions on the row of data with topic modeling and uses the topk option to limit the number of word groups to ten:

mysql> select sys.ML_PREDICT_ROW(@row_input, @topic_modeling, JSON_OBJECT('topk',10));