DNNClassifer

• 訓(xùn)練

%%sqlflow
SELECT * FROM iris.train TO TRAIN DNNClassifier WITH
  # 分類的數(shù)量
  model.n_classes = 3,
  # 隱藏單元個數(shù)
  model.hidden_units = [10, 10],
  # 優(yōu)化器的學習率，DNNClassifier的默認優(yōu)化器是AdaGrad，默認學習率為0.001
  optimizer.learning_rate=0.1,
  # 定義epoch，1個epoch是指把所有訓(xùn)練數(shù)據(jù)跑一遍
  train.epoch = 10
# 特征列
COLUMN sepal_length, sepal_width, petal_length, petal_width
# 標簽列
LABEL class
# 保存模型
INTO sqlflow_models.my_dnn_model;

• 自動訓(xùn)練

%%sqlflow
SELECT * FROM iris.train TO TRAIN sqlflow_models.AutoClassifier WITH
  model.n_classes = 3,
  train.epoch = 10
COLUMN sepal_length, sepal_width, petal_length, petal_width
LABEL class
INTO sqlflow_models.my_dnn_model;

• 預(yù)測

%%sqlflow
SELECT * FROM iris.test TO PREDICT iris.predict.class USING sqlflow_models.my_dnn_model;