Slide 88
Slide 88 text
SELECT
SELECT sys
sys.
.ML_PREDICT_ROW
ML_PREDICT_ROW(
(
JSON_OBJECT
JSON_OBJECT(
("age"
"age",
, "30"
"30",
, "job"
"job",
, "services"
"services",
,
"marital"
"marital",
, "married"
"married",
,
"education"
"education",
, "secondary"
"secondary",
,
"default1"
"default1",
, "no"
"no",
,
"balance"
"balance",
, "7032"
"7032",
,
"housing"
"housing",
, "no"
"no",
,
"loan"
"loan",
, "no"
"no",
,
"contact"
"contact",
, "cellular"
"cellular",
,
"day"
"day",
, "17"
"17",
,
"month"
"month",
, "jul"
"jul",
,
"duration"
"duration",
, "402"
"402",
,
"campaign"
"campaign",
, "1"
"1",
,
"pdays"
"pdays",
, "-1"
"-1",
,
"previous"
"previous",
, "0"
"0",
,
"poutcome"
"poutcome",
, "unknown"
"unknown"
"id"
"id",
, "0"
"0")
),
, @confoo24
@confoo24,
, NULL
NULL)
);
;
{
{ "id"
"id":
: 0.0
0.0,
,
"age"
"age":
: 30.0
30.0,
,
"day"
"day":
: 17.0
17.0,
,
"job"
"job":
: "services"
"services",
,
"loan"
"loan":
: "no"
"no",
,
"month"
"month":
: "jul"
"jul",
,
"pdays"
"pdays":
: -1.0
-1.0,
,
"balance"
"balance":
: 7032.0
7032.0,
,
...
...
"poutcome"
"poutcome":
: "unknown"
"unknown",
,
"previous"
"previous":
: 0.0
0.0,
,
"education"
"education":
: "secondary"
"secondary",
,
"Prediction"
"Prediction":
: "no"
"no",
,
"ml_results"
"ml_results":
: {
{"predictions"
"predictions":
: {
{"y"
"y":
: "no"
"no"}
},
,
"probabilities"
"probabilities":
: {
{
"no"
"no":
: 0.8799999952316284
0.8799999952316284,
,
"yes"
"yes":
: 0.11999999731779099
0.11999999731779099}
}}
} }
}
MySQL HeatWave at the service of ML
Copyright @ 2024 Oracle and/or its affiliates.
79