connect to Hive database failed in manage database connection dialog
MavenI watched the video about how to connect to database in your youtube channel(https://www.youtube.com/watch?v=gPwTgo_iJE8&index=8&t=0s&list=PLssWC2d9JhOZLbQNZ80uOxLypglgWqbJA)
Then I add a database driver "hive2" and add a connection to get my data.
But when I click the button "Test", it cannot connect to my database and the error message shows like this:
It seems to be something with the driver dependency. RM didn't find the right class to connect.
But I don't know why. I added hive dirver jar correctly.
Does anybody know the answer? Thanks a lot.
Best Answer
-
phellinger
Employee-RapidMiner, Member Posts: 103 
RM Engineering
Hi,
unfortunately, even the Hive JDBC driver requires further Hadoop-related dependencies, and it is not even explicitly documented anywhere, see this answer https://stackoverflow.com/a/36005379/5488728.
I recommend, though, to try the Hive Connector RapidMiner extension that you can download from the Marketplace: https://marketplace.rapidminer.com/UpdateServer/faces/product_details.xhtml?productId=rmx_hive. We did the hard work there, hopefully it is a good fit for your use case.
Best,
Peter
0
Answers
Hi,
I tried two ways and not one of them worked.
1. connect the hive database using "manage connections" dialog.
I added all hadoop-related dependencies as you suggested before and tried to connect it, but it showed "enabling autocommit is not supported."
I test the connection in my own code in case the dependecies is not ok and I got the right results. So I think it isn't the dependencies issue anymore.
2.connect to hive database using "Radoop Nest".
I used "Radoop Extension" and it showed another problem. This is the detail message:
https://community.rapidminer.com/t5/RapidMiner-Radoop-Forum/Could-not-initialize-class-org-apache-hadoop-conf-Configuration/m-p/51025
I really need your help.
hello, could you tell me if you can resolve this problem? I have this same issue that I can't find a solution.
thank you.