This workflow demonstrates the usage of the database nodes in conjunction with the Hive Connector node, which is part of the KNIME Big Data Extension. The Hive Connector together with the database nodes allows complex data preprocessing without the need of manual SQL coding.
The table name is controled by a workflow variable which can be altered via the context menu of the workflow in the KNIME explorer.
EXAMPLES Server: 10_Big_Data/01_Big_Data_Connectors/01_Big_Data_Preprocessing_Example10_Big_Data/01_Big_Data_Connectors/01_Big_Data_Preprocessing_Example*
Download a zip-archive
* Find more about the Examples Server here.
The link will open the workflow directly in KNIME Analytics Platform (requirements: Windows; KNIME Analytics Platform must be installed with the Installer version 3.2.0 or higher). In other cases, please use the link to a zip-archive or open the provided path manually