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

Hive - how to get from DB-Connectors to Hive (or Impala) tables - KNIME 4.5+
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.
You also want to consult the "School of Hive" (https://kni.me/w/1q-JwD0cwmuEkWpy)

External resources

• Medium: KNIME, Databases and SQL
• Hive and KNIME (more examples)
• School of Hive - with KNIME's local Big Data environment (SQL for Big Data)
• Test multiline strings