Big data with KNIME Analytics Platform - ELT on website usage data
ELT Website Usage Data
A company tracks the website usage and aggregates the statistics table about each customer.
This workflow loads the raw data to and transforms it on Hive, imports the transformed data into Spark to impute missing values and aggregate (big) data on Spark, and, finally, saves the aggreagted (small) table.
Nodes
- DB Loader2 ×
DB Table Creator2 ×- DB Table Selector (Labs)2 ×
- Spark Row Filter2 ×
Table Reader2 ×- Create Local Big Data Environment1 ×
- DB Column Filter (Labs)1 ×
- DB Joiner (Labs)1 ×
- DB Query (Labs)1 ×
- DB Row Filter (Labs)1 ×
- Destroy Spark Context1 ×
- Hive to Spark1 ×
- Merge Variables1 ×
- Spark Category to Number1 ×
- Spark Column Filter1 ×
- Spark Concatenate1 ×
- Spark Decision Tree Learner1 ×
- Spark GroupBy1 ×
- Spark Predictor (Classification)1 ×
- Spark SQL Query1 ×
- Spark to Parquet1 ×
- Spark to Table1 ×
Extensions
- FeatureKNIME Base nodes
- FeatureKNIME Database
- FeatureKNIME Extension for Apache Spark
- FeatureKNIME Extension for Apache Spark (legacy)
Links
- No links available