Enabling Autocommit Is Not Supported - Error Connecting to Impala Via JDBC

Question

Hello

I am trying to connect to my Cloudera Impala instance through JDBC from Rapid Miner.  I have added the JARs to the driver config and everything looks correct.  In fact, Rapid Miner attempts to make the connection and then fails with the error "Enabling Autocommit is not Supported".

My issue is the the Impala JDBC Driver does NOT support Auto Commit.  It seems Rapid Miner tries always sets Auto Commit to true.  Therefore, is there a way I can disable the Auto Commit requirement in Rapid Miner?

Please help me out as I would really like to leverage this tool, but won't be able to if it can't connect to my data source.

Thanks

21310122 · Answer

I know Radoop can connect hive and Impala database，but what's the reason of this error?

Since you provide the Hive type in the connection configuration dialog, doesn't it mean that it will be ok if I use this way to connect?

I just want to know why it doesn't work.

Thanks a lot.

Thomas_Ott · Answer

@rajabrata is using the Radoop product not an option for you?

21310122 · Answer

Sorry, I don't understand you. Maybe I didn't describe the problem clearly.

I added all dependencies needed in the configuration of driver and want to connect the Impala in RapidMiner. But it shows "Enabling Autocommit Is Not Supported".

It was "org.apache.hive.jdbc.HiveDriver"  that I used.

C:\Users\liyuhui\lyh\software\rapidminer-8.2.0\RapidMiner Studio\lib\jdbc\hadoop-common-2.6.0-cdh5.9.0.jar,C:\Users\liyuhui\lyh\software\rapidminer-8.2.0\RapidMiner Studio\lib\jdbc\hive-common-1.1.0-cdh5.9.0.jar,C:\Users\liyuhui\lyh\software\rapidminer-8.2.0\RapidMiner Studio\lib\jdbc\hive-jdbc-1.1.0-cdh5.9.0.jar,C:\Users\liyuhui\lyh\software\rapidminer-8.2.0\RapidMiner Studio\lib\jdbc\hive-metastore-1.1.0-cdh5.9.0.jar,C:\Users\liyuhui\lyh\software\rapidminer-8.2.0\RapidMiner Studio\lib\jdbc\hive-service-1.1.0-cdh5.9.0.jar,C:\Users\liyuhui\lyh\software\rapidminer-8.2.0\RapidMiner Studio\lib\jdbc\httpclient-4.2.5.jar,C:\Users\liyuhui\lyh\software\rapidminer-8.2.0\RapidMiner Studio\lib\jdbc\httpcore-4.2.5.jar,C:\Users\liyuhui\lyh\software\rapidminer-8.2.0\RapidMiner Studio\lib\jdbc\libthrift-0.9.0.jar,C:\Users\liyuhui\lyh\software\rapidminer-8.2.0\RapidMiner Studio\lib\jdbc\libfb303-0.9.0.jar,C:\Users\liyuhui\lyh\software\rapidminer-8.2.0\RapidMiner Studio\lib\jdbc\log4j-1.2.17.jar,C:\Users\liyuhui\lyh\software\rapidminer-8.2.0\RapidMiner Studio\lib\jdbc\slf4j-api-1.7.25.jar,C:\Users\liyuhui\lyh\software\rapidminer-8.2.0\RapidMiner Studio\lib\jdbc\slf4j-log4j12-1.7.21.jar,C:\Users\liyuhui\lyh\software\rapidminer-8.2.0\RapidMiner Studio\lib\jdbc\commons-logging-1.2.jar,C:\Users\liyuhui\lyh\software\rapidminer-8.2.0\RapidMiner Studio\lib\jdbc\guava-18.0.jar

Then I used the same dependencies and writed the code to connect the Impala, it was ok.

So I thought it's something about RM configuration or... I don't know. Can you help me?