SME_METADATA_AUTOPILOT_JOBS needs fix to meet length constraints

exasol / sagemaker-extension

An Exasol extension to interact with AWS SageMaker from inside the database

MIT License

3 stars 1 forks source link

SME_METADATA_AUTOPILOT_JOBS needs fix to meet length constraints #94

Closed DirkatExasol closed 1 year ago

DirkatExasol commented 1 year ago

When specifying problem_type und objective the trsining script raises the following error:

[Code: 0, SQL State: 43000] "E-SME-7: Error occurred in training with Sagemaker Autopilot: data exception - string data, right truncation; Valuelength: 22 Maxlength: 20 Value: '{ "MetricName": "F1" }'" caught in script "CREDIT"."SME_TRAIN_WITH_SAGEMAKER_AUTOPILOT" at line 189 (Session: 1775197807069429760)

tkilias commented 1 year ago

After a first analysis, we found that the UDF SME_AUTOPILOT_TRAINING_UDF defines problem_type and objective only as VACHAR(20)