\sql

SET GLOBAL local_infile = 1;

DROP DATABASE IF EXISTS heatwaveml_bench;

CREATE DATABASE heatwaveml_bench;

USE heatwaveml_bench;

CREATE TABLE creditcard_train ( Time INT, V1 FLOAT, V2 FLOAT, V3 FLOAT, V4 FLOAT, V5 FLOAT, V6 FLOAT, V7 FLOAT, V8 FLOAT, V9 FLOAT, V10 FLOAT, V11 FLOAT, V12 FLOAT, V13 FLOAT, V14 FLOAT, V15 FLOAT, V16 FLOAT, V17 FLOAT, V18 FLOAT, V19 FLOAT, V20 FLOAT, V21 FLOAT, V22 FLOAT, V23 FLOAT, V24 FLOAT, V25 FLOAT, V26 FLOAT, V27 FLOAT, V28 FLOAT, Amount FLOAT, Class INT);

CREATE TABLE creditcard_test LIKE creditcard_train;

\js

util.importTable("creditcard_train.csv",{table: "creditcard_train", dialect: "csv-unix", skipRows:1})

util.importTable("creditcard_test.csv",{table: "creditcard_test", dialect: "csv-unix", skipRows:1})

\sql

CALL sys.ML_TRAIN('heatwaveml_bench.creditcard_train', 'Class', JSON_OBJECT('task', 'classification'), @model_creditcard);

CALL sys.ML_MODEL_LOAD(@model_creditcard, NULL);

CALL sys.ML_SCORE('heatwaveml_bench.creditcard_test', 'Class', @model_creditcard, 'balanced_accuracy', @score_creditcard, null);

SELECT @score_creditcard;

DROP DATABASE heatwaveml_bench;