query1.setResourceID(resource);
query1.addExpression("SELECT * FROM weather ORDER BY id");
SQLQuery query2 = new SQLQuery();
query2.setResourceID(resource);
query2.addExpression("SELECT * FROM measurements ORDER BY id");
TupleMergeJoin join = new TupleMergeJoin();
join.addColumnIds1(0);
join.addColumnIds2(0);
join.connectData1Input(query1.getDataOutput());
join.connectData2Input(query2.getDataOutput());
join.addProjectColumnIds1(new int[] {1,2,3});
join.addProjectColumnIds2(new int[] {1,2});
SprintClassifier classifier = new SprintClassifier();
classifier.addClassName("play");
classifier.addClassValues(new String[] {"yes", "no"});
classifier.connectDataInput(join.getResultOutput());
DeliverToRequestStatus deliverDT = new DeliverToRequestStatus();
deliverDT.connectInput(classifier.getResultOutput());
Evaluate evaluate = new Evaluate();
evaluate.connectPMMLTreeInput(classifier.getResultOutput());
evaluate.connectDataInput(join.getResultOutput());
DeliverToRequestStatus deliver = new DeliverToRequestStatus();
deliver.connectInput(evaluate.getResultOutput());
PipelineWorkflow workflow = new PipelineWorkflow();
workflow.add(query1);