Icon

kn_​example_​hive_​db_​loader_​40

Hive - how to get from DB-Connectors to Hive (or Impala) tables

Hive - how to get from DB-Connectors to Hive (or Impala) tables
There does not seem to be a direct way to get from the comfortable (brown) Database nodes (up to KNIME 3.7) writing SQL code to store the data in a big data (Hive) table. Via Spark there is a way.

Hive - how to get from DB-Connectors to Hive (or Impala) tablesThere does not seem to be a direct way to get from the comfortable (brown) Database nodes (up to KNIME 3.7) writing SQL code to store the data in a big data (Hive) table. Via Spark there is a way. create dummy dataGroup byuse Sparkto HiveSELECT * FROM default.test1_group/big_data//data/1st cretae (empty)hive tableload datainto hivetablemake sure thetable is goneand the system is aware of thatCluster_Membershipno_entriestest2_grouptest2_group Data Generator DB GroupBy Hive to Spark Spark to Hive DB Query Reader Metadata forBig Data Create Local BigData Environment DB Table Creator DB Table Remover DB Loader DB SQL Executor Column Rename DB Column Rename DB ConnectionTable Writer DB Reader Hive - how to get from DB-Connectors to Hive (or Impala) tablesThere does not seem to be a direct way to get from the comfortable (brown) Database nodes (up to KNIME 3.7) writing SQL code to store the data in a big data (Hive) table. Via Spark there is a way. create dummy dataGroup byuse Sparkto HiveSELECT * FROM default.test1_group/big_data//data/1st cretae (empty)hive tableload datainto hivetablemake sure thetable is goneand the system is aware of thatCluster_Membershipno_entriestest2_grouptest2_group Data Generator DB GroupBy Hive to Spark Spark to Hive DB Query Reader Metadata forBig Data Create Local BigData Environment DB Table Creator DB Table Remover DB Loader DB SQL Executor Column Rename DB Column Rename DB ConnectionTable Writer DB Reader

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: A9699459
Created at: 2019-12-02
On NodePit since: 2019-12-03
Last update: 2024-04-18
Created with KNIME version: v4.0.2
Tags: big datahiveimpaladb nodeslegacy

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!