KNIME and Hive - load multiple Parquet files at once via external table

This workflow demonstrates how to import several Parquet files at once without iteration using an external HIVE table.

The initial structure wil be derived from a sample of one of the files. The rule are very basic: String, Double and Int. You might add rules for BIGINT if you need them
You could use a column as partition.

Please Download the complete folder at: https://hub.knime.com/mlauber71/spaces/Public/latest/kn_example_bigdata_hive_parquet_loader/

External resources

• KNIME Big Data Extensions User Guide
• KNIME and Big Data and Spark
• Hive - how to get from DB-Connectors to Hive (or Impala) tables - KNIME 4.5+
• School of Hive - with KNIME's local Big Data environment (SQL for Big Data)