Icon

01_​Hive_​Modelling

01 Hive Modeling Exercise Solution
Missing Values Strategy: 01_Hive_Modelling This workflow implements a predictor for the COW class of the newCensus ss13pme data set. 1. It connects to ss13pme table in New Census in the local Hive database 2. filters not missing vs. missing COW data through in-database manipulation 3. predicts COW based on all other attributes (KNIME decision tree)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 COWCOW to stringappend predictedCOW columnimport all rows where COW is NOT NULLpredict COWimport all rows whereCOW is NULLConnect to Local Big DataEnvironment DB Table Selector DB Column Filter DB Row Filter DB Row Filter DB Column Filter Number To String Decision TreePredictor DB Reader DecisionTree Learner DB Reader Create Local BigData Environment Missing Values Strategy: 01_Hive_Modelling This workflow implements a predictor for the COW class of the newCensus ss13pme data set. 1. It connects to ss13pme table in New Census in the local Hive database 2. filters not missing vs. missing COW data through in-database manipulation 3. predicts COW based on all other attributes (KNIME decision tree)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 COWCOW to stringappend predictedCOW columnimport all rows where COW is NOT NULLpredict COWimport all rows whereCOW is NULLConnect to Local Big DataEnvironmentDB Table Selector DB Column Filter DB Row Filter DB Row Filter DB Column Filter Number To String Decision TreePredictor DB Reader DecisionTree Learner DB Reader Create Local BigData Environment

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-20
Created with KNIME version: v4.3.1
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!