Icon

m_​001_​db_​create_​local_​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) Northwind_small.h2v_big_data_schema=> deletes the wholelocal big data folder../big_dataif you encouter any problems, closeKNIME and delete all data from the folder/big_data/ H2 Connector String Input local bigdatacontext create OrderDetail Product Order Customer 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) Northwind_small.h2v_big_data_schema=> deletes the wholelocal big data folder../big_dataif you encouter any problems, closeKNIME and delete all data from the folder/big_data/H2 Connector String Input local bigdatacontext create OrderDetail Product Order Customer

Nodes

Extensions

Links