0 ×

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

Workflow

This workflow group demonstrates several methods to use DB nodes, Hive/SQL and SparkSQL with KNIME and a BIg Data environment
DBSQLnodeMSaccessnorthwind
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_schema your bigdata connectenvironment H2 Connector DB SQL Executor Order Customer Product OrderDetail Merge Variables(deprecated) String Input String Input

Download

Get this workflow from the following link: Download

Nodes

m_​100_​db_​create_​bigdata_​tables consists of the following 32 nodes(s):

Plugins

m_​100_​db_​create_​bigdata_​tables contains nodes provided by the following 7 plugin(s):