I am getting the following error when attempting Hive JDBC connectivity from Orchestration (Data Collector) Pipeline, using a “JDBC Lookup” processor:
Has anyone else seen this? If so, what can be done to rectify?
Kindly confirm if jdbc connectivity is working fine in the pipeline without orchestration.
Thanks & Regards
Hello, I have managed to resolve the issue by using an Impala connection instead, but solution also involved adding an INVALIDATE METADATA statement in the advanced options part of the JDBC Lookup processer (in the “Init Query” box).
Nice , you found the solution for the issue.
If you don’t mind kindly provide the solution details with no sensitive information in it for others reference.