Icon

kn_​example_​bigdata_​hive_​add_​column

add fields to Hive table

There has been no description set for this workflow's metadata.

Use KNIME and Hive/SQL syntax to add columnd to a Big Data tablehttps://forum.knime.com/t/database-query-node-error/14569 SELECT * , CAST(NULL AS BIGINT) as new_number, CAST("" AS STRING) as new_stringFROM #table# retrievedata1 ADD COLUMNS (new_column BIGINT )SELECT * FROM data1ADD COLUMNS (test VARCHAR(25))2 new variablesSELECT * FROM data2new_data1 Create Local Big DataEnvironment (Legacy) Table Creator Database Reader(legacy) Database SQLExecutor (legacy) Hive Loader(legacy) Database TableSelector (legacy) Database SQLExecutor (legacy) Database Query(legacy) Hive Loader(legacy) Database TableSelector (legacy) Database ConnectionTable Reader (legacy) Database ConnectionTable Writer (legacy) Use KNIME and Hive/SQL syntax to add columnd to a Big Data tablehttps://forum.knime.com/t/database-query-node-error/14569 SELECT * , CAST(NULL AS BIGINT) as new_number, CAST("" AS STRING) as new_stringFROM #table# retrievedata1 ADD COLUMNS (new_column BIGINT )SELECT * FROM data1ADD COLUMNS (test VARCHAR(25))2 new variablesSELECT * FROM data2new_data1Create Local Big DataEnvironment (Legacy) Table Creator Database Reader(legacy) Database SQLExecutor (legacy) Hive Loader(legacy) Database TableSelector (legacy) Database SQLExecutor (legacy) Database Query(legacy) Hive Loader(legacy) Database TableSelector (legacy) Database ConnectionTable Reader (legacy) Database ConnectionTable Writer (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: m_lauber
Created at: 2019-03-26
On NodePit since: 2019-10-12
Last update: 2024-04-26
Created with KNIME version: v4.0.2
Tags: hivesqlbig data

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

Try NodePit Runner!