opengauss异常场景 训练阶段

异常场景。

• 训练阶段。

  • 场景一：当超参数的设置超出取值范围，模型训练失败，返回ERROR，并提示错误，例如：

    openGauss=# CREATE MODEL patient_linear_regression USING linear_regression FEATURES second_attack,treatment TARGET trait_anxiety  FROM patients WITH optimizer='aa';
    NOTICE:  Hyperparameter batch_size takes value DEFAULT (1000)
    NOTICE:  Hyperparameter decay takes value DEFAULT (0.950000)
    NOTICE:  Hyperparameter learning_rate takes value DEFAULT (0.800000)
    NOTICE:  Hyperparameter max_iterations takes value DEFAULT (100)
    NOTICE:  Hyperparameter max_seconds takes value DEFAULT (0)
    NOTICE:  Hyperparameter optimizer takes value aa
    ERROR:  Invalid hyperparameter value for optimizer. Valid values are: gd, ngd. (default is gd)
    

  • 场景二：当模型名称已存在，模型保存失败，返回ERROR，并提示错误原因：

    openGauss=# CREATE MODEL patient_linear_regression USING linear_regression FEATURES second_attack,treatment TARGET trait_anxiety  FROM patients;
    NOTICE:  Hyperparameter batch_size takes value DEFAULT (1000)
    NOTICE:  Hyperparameter decay takes value DEFAULT (0.950000)
    NOTICE:  Hyperparameter learning_rate takes value DEFAULT (0.800000)
    NOTICE:  Hyperparameter max_iterations takes value DEFAULT (100)
    NOTICE:  Hyperparameter max_seconds takes value DEFAULT (0)
    NOTICE:  Hyperparameter optimizer takes value DEFAULT (gd)
    NOTICE:  Hyperparameter tolerance takes value DEFAULT (0.000500)
    NOTICE:  Hyperparameter seed takes value DEFAULT (0)
    NOTICE:  Hyperparameter verbose takes value DEFAULT (FALSE)
    NOTICE:  GD shuffle cache size 5502
    ERROR:  The model name "patient_linear_regression" already exists in gs_model_warehouse.
    

  • 场景三：FEATURE或者TARGETS列是*，返回ERROR，并提示错误原因：

    openGauss=# CREATE MODEL patient_linear_regression USING linear_regression FEATURES *  TARGET trait_anxiety  FROM
    patients;
    ERROR:  FEATURES clause cannot be *
    -----------------------------------------------------------------------------------------------------------------------、
    openGauss=# CREATE MODEL patient_linear_regression USING linear_regression FEATURES second_attack,treatment TARGET *  FROM patients;
    ERROR:  TARGET clause cannot be *
    

  • 场景四：对于无监督学习方法使用TARGET关键字，或者在监督学习方法中不适用TARGET关键字，均会返回ERROR，并提示错误原因：

    openGauss=# CREATE MODEL patient_linear_regression USING linear_regression FEATURES second_attack,treatment FROM patients;
    ERROR:  Supervised ML algorithms require TARGET clause
    -----------------------------------------------------------------------------------------------------------------------------
    CREATE MODEL patient_linear_regression USING linear_regression TARGET trait_anxiety  FROM patients;   ERROR:  Supervised ML algorithms require FEATURES clause
    

  • 场景五：当GUC参数statement_timeout设置了时长，训练超时执行的语句将被终止：执行CREATE MODEL语句。训练集的大小、训练轮数（iteration）、提前终止条件（tolerance、max_seconds）、并行线程数（nthread）等参数都会影响训练时长。当时长超过数据库限制，语句被终止模型训练失败。

• 详情查看：https://opengauss.org
  详情查看：https://docs-opengauss.osinfra.cn