use try and catch for generic ports. The existing table will be at the resulting port
Try some generic SQL operation on your Hive (or Impala) environment. If one fails you could populate a Flow variable with some information (eg. the surviving table)
Another possibility would be to try some combination with the "Active Branch Inverter"
https://hub.knime.com/knime/extensions/org.knime.features.base/latest/org.knime.base.node.flowcontrol.trycatch.inverter.ActiveBranchInverterNodeFactory
External resources
- Leveraging Athena with KNIME in a Robust Manner, Part 2
- School of Hive - with KNIME's local Big Data environment (SQL for Big Data)
- Sending a file via EMail - use of Active Branch Inverter
- example how to use Try/Catch sequence while writing to Database
- MEDIUM Blog: KNIME, Databases and SQL
- KNIME Flow Control Guide
Used extensions & nodes
Created with KNIME Analytics Platform version 4.7.8
- Go to item
- Go to item
- Go to item
- Go to item
- Go to item
- Go to item
Loading deployments
Loading ad hoc jobs
Legal
By using or downloading the workflow, you agree to our terms and conditions.