0 ×

PMML to SQL

PMML to SQL Translator version 4.0.0.v201905311239 by KNIME AG, Zurich, Switzerland

Generates SQL queries from PMML models. The following model types are currently supported:

  • Regression (linear, polynomial, logistic)
  • SVM (no output of probabilities)
  • MLP
  • K-Means Clustering
  • Decision Trees (no output of probabilities)
  • Naive Bayes
  • Rulesets
Ensemble models can be translated but result in complicated joins that might not run efficiently.
IMPORTANT NOTICES:
  • The node only supports tables where the columns do not contain spaces. Spaces in the PMML document's fields are converted to an underscore (_).
  • Due to several missing functions such as 'POW' SQLite is currently not supported.

The generated SQL runs best on MySQL databases. Other databases may have limitations. Postgres BUG #6359 for example limits the size of the generated SQL so that some large queries will not work. Microsoft SQL Server limits the nesting depth of CASE WHEN statements to 10, so large decision tree models cannot be executed via SQL.

Options

Input table
The table with the data to score
Primary key column
The column which holds the primary key for each record
Database compatibility mode
The style of type conversions. Only necessary for a small fraction of queries with type conversions in the preprocessing (eg String to Number or Numer to String nodes).

Input Ports

The PMML model that is translated into SQL

Output Ports

The SQL select statement for the scoring
Table containing the generated SQL

Views

SQL statement
The generated SQL statement.

Best Friends (Incoming)

Best Friends (Outgoing)

Workflows

Installation

To use this node in KNIME, install PMML to SQL Translator from the following update site:

KNIME 4.0
Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform.