I have connected to hive with the legacy connector and now I’m migrating to the new connector. The new on with the same setup doesn’t work. In Attachment preferences and workflow.
Hi @tebaldir,
since most here probably do not have a big data environment to test this with, could you also share the error message you are receiving? Most helpful would be the snippet from the KNIME log where the error occurred.
Kind regards
Alexander
from a quick look and experience from forum I would say URL shouldn’t be same in those two connectors. Have you checked documentation on new database framework on how to register driver, write JDBC URL and add JDBC Parameters?
Hello tebaldir,
as Ivan already pointed out, we recommend to use the specific connector nodes e.g. Hive Connector node instead of the generic DB Connector node whenever it is possible. However to use the nodes with your own driver you need to specify the correct JDBC URL which is used when connecting to the database. In the preferences file you attached I see that the URL template is not correct. It should be something like: jdbc:hive2://<host>:<port>/[database]
whereas <host>, <port> and [database] are place holders which are filled in with the values from the node dialog. For further details on JDBC URL template syntax have a look at the documentation.
Bye
Tobias