Icon

01_​Flight_​Delay_​Statistics_​Impala

Step 1: Connect to Impala (with Kerberos): - Replace hostname with actual host - JDBC Parameters: Replace KrbHostFQDN and KrbRealm with actualhostname and realm Step 2: Upload airline dataset (included) - DB Table Creator/DB Loader: Choose table schema and name - HttpFS Connection: Replace hostname with actual HttpFS server Step 3: Aggregate and visualize flight delays per day of week Demo workflow: Flight delay statistics using Impala - Connect to Kerberized Impala - Load the airline dataset into Impala - Aggregate and visualize data (flight delay per day-of-week)Data source: - http://www.transtats.bts.gov/Fields.asp?Table_ID=236 - All US flights from Jan 2020 HttpFS Connection DB Loader DB Table Creator Impala Connector DB GroupBy DB Sorter DB Reader Bar Chart Number To String DB Table Selector Read airline data Step 1: Connect to Impala (with Kerberos): - Replace hostname with actual host - JDBC Parameters: Replace KrbHostFQDN and KrbRealm with actualhostname and realm Step 2: Upload airline dataset (included) - DB Table Creator/DB Loader: Choose table schema and name - HttpFS Connection: Replace hostname with actual HttpFS server Step 3: Aggregate and visualize flight delays per day of week Demo workflow: Flight delay statistics using Impala - Connect to Kerberized Impala - Load the airline dataset into Impala - Aggregate and visualize data (flight delay per day-of-week)Data source: - http://www.transtats.bts.gov/Fields.asp?Table_ID=236 - All US flights from Jan 2020 HttpFS Connection DB Loader DB Table Creator Impala Connector DB GroupBy DB Sorter DB Reader Bar Chart Number To String DB Table Selector Read airline data

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: bjoern
Created at: 2020-05-14
On NodePit since: 2020-05-15
Last update: 2024-04-20
Created with KNIME version: v4.1.2

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

Try NodePit Runner!