Machine Learning Model Functions

{{ocientml}} functionality supports these sql functions for machine learning models the scope of a machine learning model is the schema supported machine learning models supported machine learning models are divided into these categories regression models docid\ pfnkdj1fwsevxoondal9k docid\ pfnkdj1fwsevxoondal9k docid\ pfnkdj1fwsevxoondal9k docid\ pfnkdj1fwsevxoondal9k docid\ pfnkdj1fwsevxoondal9k docid\ pfnkdj1fwsevxoondal9k classification models docid 67w1y2nzakexornpizk e docid 67w1y2nzakexornpizk e docid 67w1y2nzakexornpizk e docid 67w1y2nzakexornpizk e docid 67w1y2nzakexornpizk e docid 67w1y2nzakexornpizk e clustering and dimension reduction models docid\ tlugzlmibs6dstwsbeagw docid\ tlugzlmibs6dstwsbeagw docid\ tlugzlmibs6dstwsbeagw docid\ tlugzlmibs6dstwsbeagw other models docid\ pahgmmey3oefcapzzu50i docid\ pahgmmey3oefcapzzu50i execute a query using a machine learning model to create a machine learning model and manage the model, see docid\ rqzgc5r0vigmehqdy3g5j for the corresponding syntaxes after you have the model, you can execute a query using the model with this syntax syntax select \<model name>(expression, ) from \<tablereference> example create a table with data for the model create table mldemo mlr as (select a c1 as x1, b c1 as x2, 1 + 2 a c1 + 3 b c1 as y from sys dummy10 a, sys dummy10 b); modified 100 rows create a multiple linear regression model based on the data create mlmodel mlr model type multiple linear regression on (select from mldemo mlr) options('metrics' > 'true'); modified 0 rows execute a select query against the multiple linear regression to see the actual and predicted values limit the result set to 10 rows select x1, x2, y as actual, mlr model(x1, x2) as predicted from mldemo mlr limit 10; output x1 x2 actual predicted \ 6 1 16 15 999999999999975 6 2 19 18 999999999999975 6 3 22 21 999999999999975 6 4 25 24 999999999999975 6 5 28 27 999999999999975 6 6 31 30 999999999999975 6 7 34 33 99999999999997 6 8 37 36 99999999999997 6 9 40 39 99999999999997 6 10 43 42 99999999999997 fetched 10 rows related links docid\ dqt aansysg4i2sm sixn docid\ rqzgc5r0vigmehqdy3g5j