Icon

kn_​example_​hive_​db_​loader_​37

Hive - how to get from DB-Connectors to Hive (or Impala) tables - Legacy nodes up to vers. 3.7.x

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

Hive - how to get from DB-Connectors to Hive (or Impala) tables - Legacy nodes up to vers. 3.7.xThere does not seem to be a direct way to get from the comfortable (brown) Database nodes writing SQL code to store the data in a big data (Hive) table. Via Spark there is a way. This is the standard way - but it sometimes does notseem to work properly create dummy datatest1Group byuse Sparkto HiveSELECT * FROM default.test1_group/big_data//data/hmm ok this (sometimes) worksDROP TABLE Data Generator Create Local Big DataEnvironment (Legacy) Hive Loader(legacy) Database GroupBy(legacy) Hive to Spark(legacy) Spark to Hive(legacy) Database Reader(legacy) Metadata forBig Data Database ConnectionTable Writer (legacy) Database SQLExecutor (legacy) Hive - how to get from DB-Connectors to Hive (or Impala) tables - Legacy nodes up to vers. 3.7.xThere does not seem to be a direct way to get from the comfortable (brown) Database nodes writing SQL code to store the data in a big data (Hive) table. Via Spark there is a way. This is the standard way - but it sometimes does notseem to work properly create dummy datatest1Group byuse Sparkto HiveSELECT * FROM default.test1_group/big_data//data/hmm ok this (sometimes) worksDROP TABLEData Generator Create Local Big DataEnvironment (Legacy) Hive Loader(legacy) Database GroupBy(legacy) Hive to Spark(legacy) Spark to Hive(legacy) Database Reader(legacy) Metadata forBig Data Database ConnectionTable Writer (legacy) Database SQLExecutor (legacy)

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-02
Last update: 2024-12-23
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!