DB Query Reader
Source
Executes an entered SQL query and returns the result as KNIME data table.
Input ports
- Type: DB Session DB Connection to the database.
Output ports
- Type: Data KNIME data table with the result from the database query.
-
School of Hive - with KNIME's local Big Data environment (SQL for Big Data)
hive school learn sql hql cloudera big data big data partitionSchool of Hive - with KNIME's local Big Data environment (SQL for Big Data) Demonstrates a collection of Hive functions …mlauber71 > Public > kn_example_hive_school_of -
Rossmann - DB - Time Series
mwysocki > Public > Rossmann - DB - Time Series -
Data Blending and ETL
Sources SQLite Data Blending ETLTask. Starting from different data sources this workflow shows how to blend data (extract value from multiple data sourc…foretj > Public > Data Blending -
Oracle Data Pagination using ROWNUM
db oracle loop windowThis workflow loops over data in an Oracle database using the ROWNUM function and between.tobias.koetter > Public > DB > Oracle Data Pagination -
DB Looping and Parameterized Reader Nodes
This workflow demonstrates the legacy Database Looping and Parameterized Database Query node as well as the new Paramete…tobias.koetter > Public > DB > dbLooping_parameterized -
DB reading on a server from inside the workflow
beginner DB database sqliteAn example how to access an SQLite DB file inside workflow. Works both locally and on a KNIME Server. Example for https:…lisovyi > Public > forum > 11962_rel372 -
DB Looping Component for new DB Framework
This workflow provides a component that emulates the functionality of the Database Looping (legacy) node for the nde dat…tobias.koetter > Public > DB > dbLooping -
KNIME and SQLite - simple example (4.0 New DB nodes)
DB sqlite r RSQLite databasethis demonstrates the use of a local SQLite database where you can store data and keep the variable type and perform dat…mlauber71 > Public > sqlite_knime_40 > t_001_sqlite_knime_40_db_nodes -
Listado EESS
tomasmaria > Public > Listado EESS -
KNIME and Hive - load multiple CSV files at once via external table
knime hive external table csv load multiple partitionKNIME and Hive - load multiple CSV files at once via external table. Also: toy around with internal and external tables …mlauber71 > Public > kn_example_bigdata_hive_csv_loader > m_001_import_hive_csv