call:udf
差别
这里会显示出您选择的修订版和当前版本之间的差别。
| 两侧同时换到之前的修订记录 前一修订版 后一修订版 | 前一修订版 | ||
|
call:udf [2019/12/29 15:00] jinlong [程序编码] |
call:udf [2020/07/12 12:07] (当前版本) |
||
|---|---|---|---|
| 行 171: | 行 171: | ||
| + | 方法1：输入1个参数，获取json结果 | ||
| + | |||
| + | <code sql> | ||
| + | select | ||
| + | eppdev_mlib_calc_test01( | ||
| + | eppdev_to_json( | ||
| + | 'sepal.width', sepal_with, | ||
| + | 'sepal.height', sepal_height, | ||
| + | 'petal.width', petal_width, | ||
| + | 'petal.height', petal_height | ||
| + | ) | ||
| + | ) as full_result | ||
| + | from iris_data; | ||
| + | </code> | ||
| + | |||
| + | 输出结果为全量json | ||
| + | |||
| + | <code json> | ||
| + | { | ||
| + | "probability(Setosa)": 1.0, | ||
| + | "probability(Virginica)": 0.0, | ||
| + | "probability(Versicolor)": 0.0, | ||
| + | "variety": "Setosa" | ||
| + | } | ||
| + | </code> | ||
| + | |||
| + | 方法2：输入2个参数，获取具体结果 | ||
| + | |||
| + | <code sql> | ||
| + | select | ||
| + | eppdev_mlib_calc( | ||
| + | eppdev_to_json( | ||
| + | 'sepal.width', sepal_with, | ||
| + | 'sepal.height', sepal_height, | ||
| + | 'petal.width', petal_width, | ||
| + | 'petal.height', petal_height | ||
| + | ), | ||
| + | 'variety' | ||
| + | ) as variety | ||
| + | from iris_data; | ||
| + | </code> | ||
| + | |||
| + | 输出结果为veriety结果，如：Setosa | ||
call/udf.1577602814.txt.gz · 最后更改: 2020/07/12 12:07 (外部编辑)