Icon

kn_​example_​hive_​create_​table_​show_​describe

Create HIVE table and show the way it was created and describe the structure

Create a Big Data table, show the structiure and fields

CREATE TABLE `default`.`test1`(`ID` STRING, `Var1` STRING)ROW FORMAT SERDE'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'WITH SERDEPROPERTIES ('serialization.format' = '1')STORED AS INPUTFORMAT 'org.apache.hadoop.mapred.TextInputFormat' OUTPUTFORMAT'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'TBLPROPERTIES ('transient_lastDdlTime' = '1574786628') Create HIVE table and show the way it was created and describe the structurehttps://forum.knime.com/t/is-it-possible-to-have-a-sql-script-from-a-knime-workflow/19634/4?u=mlauber71 dbms_metadatahttps://stackoverflow.com/questions/18264584/show-create-table-equivalent-in-oracle-sql 1st cretae (empty)hive tableload datainto hivetableSHOW CREATE TABLE `default`.`data3_new`DESCRIBE EXTENDED `default`.`test1` Table Creator Extract ContextProperties Extract SystemProperties Merge Variables Create Local BigData Environment DB Table Creator DB Table Remover DB Loader DB Query Reader DB Query Reader Table Columnto Variable CREATE TABLE `default`.`test1`(`ID` STRING, `Var1` STRING)ROW FORMAT SERDE'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'WITH SERDEPROPERTIES ('serialization.format' = '1')STORED AS INPUTFORMAT 'org.apache.hadoop.mapred.TextInputFormat' OUTPUTFORMAT'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'TBLPROPERTIES ('transient_lastDdlTime' = '1574786628') Create HIVE table and show the way it was created and describe the structurehttps://forum.knime.com/t/is-it-possible-to-have-a-sql-script-from-a-knime-workflow/19634/4?u=mlauber71 dbms_metadatahttps://stackoverflow.com/questions/18264584/show-create-table-equivalent-in-oracle-sql 1st cretae (empty)hive tableload datainto hivetableSHOW CREATE TABLE `default`.`data3_new`DESCRIBE EXTENDED `default`.`test1`Table Creator Extract ContextProperties Extract SystemProperties Merge Variables Create Local BigData Environment DB Table Creator DB Table Remover DB Loader DB Query Reader DB Query Reader Table Columnto Variable

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-11-26
On NodePit since: 2021-07-28
Last update: 2024-04-28
Created with KNIME version: v4.1.0
Tags: hivebig dataknimesqldescribeshow

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

Try NodePit Runner!