Icon

m_​100_​db_​create_​bigdata_​tables

This workflow group demonstrates several methods to use DB nodes, Hive/SQL and SparkSQL with KNIME and a Big Data environment
Load into local Big Data DB This workflow group demonstrates several methods to use DB nodes, Hive/SQL and SparkSQL with KNIME and a Big Data environmentThe data is from the classic MS Access sample DB "Northwind" (https://github.com/jpwhite3/northwind-SQLite3) enter yourImpalaHDFSSparkconnectionNorthwind_small.h2COMPUTE STATS $${Sv_big_data_schema}$$.tmp_order;COMPUTE STATS $${Sv_big_data_schema}$$.tmp_customer;COMPUTE STATS $${Sv_big_data_schema}$$.tmp_orderdetail;COMPUTE STATS $${Sv_big_data_schema}$$.tmp_product;var_path_datav_big_data_schema your bigdata connectenvironment H2 Connector DB SQL Executor Order Customer Product OrderDetail Merge Variables(deprecated) String Input String Input Load into local Big Data DB This workflow group demonstrates several methods to use DB nodes, Hive/SQL and SparkSQL with KNIME and a Big Data environmentThe data is from the classic MS Access sample DB "Northwind" (https://github.com/jpwhite3/northwind-SQLite3) enter yourImpalaHDFSSparkconnectionNorthwind_small.h2COMPUTE STATS $${Sv_big_data_schema}$$.tmp_order;COMPUTE STATS $${Sv_big_data_schema}$$.tmp_customer;COMPUTE STATS $${Sv_big_data_schema}$$.tmp_orderdetail;COMPUTE STATS $${Sv_big_data_schema}$$.tmp_product;var_path_datav_big_data_schemayour bigdata connectenvironment H2 Connector DB SQL Executor Order Customer Product OrderDetail Merge Variables(deprecated) String Input String Input

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: A9699459
Created at: 2020-09-21
On NodePit since: 2020-09-25
Last update: 2024-04-18
Created with KNIME version: v4.4.1
Tags: DBSQLnodeMSaccessnorthwind

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

Try NodePit Runner!