Icon

01_​Hive_​Modelling

01 Hive Modeling Exercise
Exercise: 01_Hive_Modelling This workflow implements a predictor for the COW class of the newCensus.sqlite dataset. 1. Change this workflow to run on the ss13pme table on the Hive database in the local big data environment.Make sure you have executed the /2_Hadoop/2_Exercises/00_Setup_Hive_Table workflow during your current KNIMEsession before running this workflow. select * from ss13pmeremovePUMA* &PWGTP*COW is NOT NULLCOW is NULLremove COWnewCensus.sqlitefrom 1_DB/1_DataCOW to stringappend predictedCOW columnimport all rows where COW is NOT NULLpredict COWimport all rows whereCOW is NULL DB Table Selector DB Column Filter DB Row Filter DB Row Filter DB Column Filter SQLite Connector Number To String Decision TreePredictor DB Reader DecisionTree Learner DB Reader Exercise: 01_Hive_Modelling This workflow implements a predictor for the COW class of the newCensus.sqlite dataset. 1. Change this workflow to run on the ss13pme table on the Hive database in the local big data environment.Make sure you have executed the /2_Hadoop/2_Exercises/00_Setup_Hive_Table workflow during your current KNIMEsession before running this workflow. select * from ss13pmeremovePUMA* &PWGTP*COW is NOT NULLCOW is NULLremove COWnewCensus.sqlitefrom 1_DB/1_DataCOW to stringappend predictedCOW columnimport all rows where COW is NOT NULLpredict COWimport all rows whereCOW is NULLDB Table Selector DB Column Filter DB Row Filter DB Row Filter DB Column Filter SQLite Connector Number To String Decision TreePredictor DB Reader DecisionTree Learner DB Reader

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: koetter
Created at: 2015-07-31
On NodePit since: 2020-04-22
Last update: 2024-04-23
Created with KNIME version: v4.3.0
Tags: Big DataEducation

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!