Hub
WorkflowWorkflow

Spark SQL meets Hive SQL

Spark Hive Hadoop Big Data SQL
+2

Last edited: 

Drag & drop
Like
Download workflow
Copy short link
Workflow preview
This workflow builds a line plot of the age distribution for men and women in Maine (US) over the last 5 years. In particular, women's data is processed via Hive SQL, and men's data via Spark SQL. Will they blend? The whole data set is initially read from a Hadoop Hive installation. .... and yes, Spark SQL and Hive SQL do blend!

Used extensions & nodes

Created with KNIME Analytics Platform version 4.4.0
  • KNIME Base nodes Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.4.0

  • KNIME Database Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.4.0

  • KNIME Data Generation Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.1.0

  • KNIME Extension for Apache Spark Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.4.0

  • KNIME Extension for Local Big Data Environments Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.4.0

  • KNIME JavaScript Views Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.4.0

Discussion