This node is part of the legacy database framework. For more information on how to migrate to the new database framework see the migration section of the database documentation.
This node loads a KNIME data table into Hive. Hive requires imported data to be present on the Hive server, therefore this node first copies the data onto the Hive server. You can use any of the protocols supported by the file handling nodes, e.g. SSH/SCP or FTP. The data is then loaded into a Hive table and the uploaded file is deleted.
Additionally the data can be partitioned by selecting one or more compatible columns (e.g. integer or string). The node relies on Hive's dynamic partitioning.
Options
Popular Predecessors
Database Reader2 %- String Manipulation2 %
- String Manipulation (Variable)2 %
- HTTPS Connection (legacy)2 %
- Concatenate2 %
- Secured WebHDFS Connection (legacy)2 %
Naive Bayes Learner2 %String To Number2 %- Column Rename (Regex)2 %
- Row Sampling2 %
- HttpFS Connection (legacy)2 %
- Secured HttpFS Connection (legacy)2 %
Hive Connector2 %- SAS7BDAT Reader2 %
Table Reader1 %- Decision Tree Predictor1 %
Rank Correlation1 %- Column Resorter1 %
- ARFF Reader1 %
- Sorter1 %
- WebHDFS Connection (legacy)1 %
- Azure Blob Store Connection (legacy)1 %
MySQL Connector1 %Python Script (1⇒1)1 %- Rule Engine1 %
- Math Formula (Multi Column)1 %
CSV Reader< 1 %Database SQL Executor< 1 %- String Replacer< 1 %
Database Delete< 1 %Database Connector< 1 %- Java Snippet< 1 %
- Reference Column Resorter< 1 %
- Create Temp Dir (legacy)< 1 %
- Date&Time Shift< 1 %
Database Table Selector< 1 %File Reader< 1 %- Table Creator< 1 %
- Column Combiner< 1 %
- Column Comparator< 1 %
- Cross Joiner< 1 %
- Column Filter< 1 %
Impala Connector< 1 %- FTP Connection (legacy)< 1 %
- Upload (legacy)< 1 %
Parameterized Database Query< 1 %Concatenate (Optional in)< 1 %- Ungroup< 1 %
Hive Loader (legacy)< 1 %- DB Reader< 1 %
- String to Date&Time< 1 %
- SSH Connection (legacy)< 1 %
Database Connection Table Reader< 1 %Database Table Connector< 1 %- Constant Value Column< 1 %
- GroupBy< 1 %
Joiner< 1 %Column Rename< 1 %- RowID< 1 %
- Rule-based Row Filter< 1 %
- Data Generator< 1 %
- HDFS Connection (legacy)< 1 %
- Spark to Table< 1 %
Excel Reader (XLS)< 1 %- JSON to Table< 1 %
- Date&Time to String< 1 %
- Legacy Date&Time to Date&Time< 1 %
Database End IF< 1 %- Download (legacy)< 1 %
- Download / Upload from List (legacy)< 1 %
- List Remote Files (legacy)< 1 %
- HTTP Connection (legacy)< 1 %
- Try (Data Ports)< 1 %
Table Row To Variable Loop Start< 1 %Database Row Filter< 1 %Database Update< 1 %Database Table Creator< 1 %List Files< 1 %Loop End< 1 %Recursive Loop End< 1 %- Case Converter< 1 %
Number To String< 1 %- Column Aggregator< 1 %
- Column Renamer (Dictionary)< 1 %
- Double to Integer< 1 %
- Reference Column Splitter< 1 %
Row Filter (deprecated)< 1 %- Missing Value< 1 %
String Replace (Dictionary)< 1 %- IF Switch< 1 %
Parquet Reader< 1 %- HDFS File Permission (legacy)< 1 %
- Amazon S3 Connection (legacy)< 1 %
- DB Query Reader< 1 %
- Python Source (legacy)< 1 %
- Test Data Generator< 1 %
- Date&Time to legacy Date&Time< 1 %
- Time to String (legacy)< 1 %
- Duplicate Row Filter< 1 %
Views
- This node has no views
Workflows
01_Big_Data_Preprocessing_ExampleKNIME Hub- 01_Big_Data_Preprocessing_ExampleKNIME Hub
- 01_Big_Data_Preprocessing_ExampleKNIME Hub
- kn_example_bigdata_hive_add_columnKNIME Hub
- kn_example_hive_db_loader_37KNIME Hub
Links
Developers
You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.