[Step By Step]SAP HANA PAL邏輯回歸預測分析Logistic Regression程式設計執行個體FORECASTWITHLOGISTICR（預測）

SET SCHEMA PAL;

-- PAL setup

CREATE TYPE PAL_T_RGP_DATA AS TABLE (ID INTEGER, LIFESPEND INTEGER); 

CREATE TYPE PAL_T_RGP_FITTED AS TABLE (ID INTEGER, FITTED DOUBLE, GENDER INTEGER);

CREATE COLUMN TABLE PAL_RGP_SIGNATURE (ID INTEGER, TYPENAME VARCHAR(100), DIRECTION VARCHAR(100)); 

INSERT INTO PAL_RGP_SIGNATURE VALUES (1, 'PAL_T_RGP_DATA', 'in'); 

INSERT INTO PAL_RGP_SIGNATURE VALUES (2, 'PAL_T_RG_PARAMS', 'in'); 

INSERT INTO PAL_RGP_SIGNATURE VALUES (3, 'PAL_T_RG_COEFF', 'in'); 

INSERT INTO PAL_RGP_SIGNATURE VALUES (4, 'PAL_T_RGP_FITTED', 'out');

CALL SYSTEM.AFL_WRAPPER_GENERATOR ('PAL_RGP', 'AFLPAL', 'FORECASTWITHLOGISTICR', PAL_RGP_SIGNATURE);

-- app setup

CREATE COLUMN TABLE RGP_PREDICT LIKE PAL_T_RGP_DATA; 

CREATE COLUMN TABLE RGP_PREDICTED LIKE PAL_T_RGP_FITTED;

-- app runtime

TRUNCATE TABLE RGP_PREDICT; 

INSERT INTO RGP_PREDICT VALUES (1,3000); 

INSERT INTO RGP_PREDICT VALUES (2,5000); 

INSERT INTO RGP_PREDICT VALUES (3,9000); 

INSERT INTO RGP_PREDICT VALUES (4,12000); 

INSERT INTO RGP_PREDICT VALUES (5,14000);

TRUNCATE TABLE RGP_PREDICTED;

CALL _SYS_AFL.PAL_RGP (RGP_PREDICT, RG_PARAMS, RG_COEFF, RGP_PREDICTED) WITH OVERVIEW;

專注于企業資訊化，最近對股票資料分析較為感興趣，可免費分享股票個股主力資金實時變化趨勢分析工具，股票交流QQ群：457394862

本文轉自滄海-重慶部落格園部落格，原文連結：http://www.cnblogs.com/omygod/archive/2013/05/16/3081371.html，如需轉載請自行聯系原作者