- Create a Vantage table to store the models.PMML, H2O, ONNX, Dataiku, and DataRobot models can reside in the same table. Teradata recommends having separate tables when the H2O DAI license key is in the model table. See Option 2 in Load the H2O Driverless AI License. PMML and H2O open source models do not require a license.The Model table must have sufficient permanent space to hold the models inserted to the table. One way to determine the amount of reserved space needed is to do the following:
- Calculate the average model size to insert into the model table to arrive at x
- Determine the expected number of rows in the table divided by the number of amps to arrive at y
- Multiply x and y and then by the number of AMPs to get the necessary perm space and spool space
- In VantageCloud Lake, the model table must be created in the Native Data Store (NDS)
The table must have a model identifier, which must be a single column named model_id of data type VARCHAR, and a column named Model for the model itself (see a ModelTable schema in PMMLPredict Input or H2OPredict Input).
For example, the following statement creates a ModelTable:CREATE SET TABLE pmml_models ( model_id VARCHAR (30), model BLOB ) PRIMARY INDEX (model_id);