Icon

12_​Hadoop Hive meets Excel-Your Flight is boarding now

Will They Blend? Hadoop Hive meets Excel.
Option 1. In-database join Option 2. In-KNIME Analytics Platform join Read .xlsx data Create local big data environment, upload data and read data from it Hadoop meets Excel Add weather data toairlines data joiningby year, month and daySelect weathertable from theLocal Big Data Env.Move fromHive to SparkCalculate statistical momentsfor the available data in SparkSelect airlinestable from theLocal Big Data Env.Read airlines tablewith origin = "ORD"Calculate statistical momentsfor the available data inKNIME Analytics PlatformCategory to number,missing valuesand normalization String to number,missing valuesand normalizationorigin = "ORD"Weather dataload thedemo tableweatherAdd weather data toairlines data joiningby year, month and dayExtract year, month andday from the datecreate the demo tableweather Read data into LocalBig Data Env. DB Joiner DB Table Selector Hive to Spark Spark CorrelationMatrix Spark Statistics DB Table Selector DB Reader Linear Correlation Statistics Spark Preprocessing Preprocessing DB Row Filter Excel Reader DB Loader Joiner Extract Date&TimeFields DB Table Creator Option 1. In-database join Option 2. In-KNIME Analytics Platform join Read .xlsx data Create local big data environment, upload data and read data from it Hadoop meets Excel Add weather data toairlines data joiningby year, month and daySelect weathertable from theLocal Big Data Env.Move fromHive to SparkCalculate statistical momentsfor the available data in SparkSelect airlinestable from theLocal Big Data Env.Read airlines tablewith origin = "ORD"Calculate statistical momentsfor the available data inKNIME Analytics PlatformCategory to number,missing valuesand normalization String to number,missing valuesand normalizationorigin = "ORD"Weather dataload thedemo tableweatherAdd weather data toairlines data joiningby year, month and dayExtract year, month andday from the datecreate the demo tableweather Read data into LocalBig Data Env. DB Joiner DB Table Selector Hive to Spark Spark CorrelationMatrix Spark Statistics DB Table Selector DB Reader Linear Correlation Statistics Spark Preprocessing Preprocessing DB Row Filter Excel Reader DB Loader Joiner Extract Date&TimeFields DB Table Creator

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: Lada.Rudnitckaia
Created at: 2020-06-15
On NodePit since: 2020-09-05
Last update: 2024-04-20
Created with KNIME version: v4.6.1
Tags: hadoopexceldata blendingWill they blend

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

Try NodePit Runner!