RapidMiner Hadoop Configuration For apache distribution

prawin213

Hi All,

I am new to rapidminer i have succesfully installed and configured rapidminer7.3 version its works fine the problem is when i am trying to configure hadoop it gives the below error

[Nov 23, 2016 12:39:42 PM] SEVERE: java.util.concurrent.TimeoutException
[Nov 23, 2016 12:39:42 PM] SEVERE: Hive server 2 connection test timed out. Please check that the server/daemon runs and is accessible on the address and port you specified.
[Nov 23, 2016 12:39:42 PM] SEVERE: Test failed: Hive connection
[Nov 23, 2016 12:39:42 PM] SEVERE: Connection test for 'Hadoop' failed.

My Hadoop Distribution is Apache

my hive version is hive1.2.1

and all my ports are default ports. If anybody knows please help me

Thanks in advance,

Praveen G

phellinger

Hi Praveen,

it is difficult to figure out the problem only from this information, but there are a couple of hints:

The error simply states that there were no response from the HiveServer2 instance (specified by either the Master Address or the Hive Server Address fields, and the Hive Port) in a given time.

I would try the following:

• Check the Hive log on the cluster. Does the SHOW TABLES command that the test sends appear in the log? (It can take seconds on first try.) That confirms that Hive may be accessible, but it may take longer time than the timeout.
• If the log shows that the command was sent to Hive, then you can increase the timeout in Studio: go toPreferences->Radoop, and increase theConnection timeoutandHive command timeoutvalues to, let's say,30. (These timeouts are used for detecting connection problems.)
• If there is nothing in the log, then I would make sure that the specified address and port can be reached from the machine that runs Studio. If that works, I would check the health of Hive on the cluster from Beeline, for example.

Best,

Peter

prawin213

Hi Peter,

Thanks for the Reply

I have verified hive cluster through beeline it working fine . Now if i am trying to connect i am getting below error.

I have attached the hive working using beeline scrren shot and Hadoop connection in RapidMiner

If u know please help me out . Any Way thanks for ur reply

regards,

Praveen

[Nov 25, 2016 9:43:25 AM] SEVERE: java.lang.RuntimeException: java.lang.NoClassDefFoundError: org/apache/hadoop/hive/metastore/api/MetaException
[Nov 25, 2016 9:43:25 AM] SEVERE: Hive server 2 connection test failed. Please check that the server/daemon runs and is accessible on the address and port you specified.
[Nov 25, 2016 9:43:25 AM] SEVERE: Test failed: Hive connection
[Nov 25, 2016 9:43:25 AM] SEVERE: Connection test for 'Hadoop' failed.

phellinger

Hi Praveen,

The screenshots help.

The first thing is thatJDBC URL Postfixfield is only there foradditional, custom postfix (the URL is constructed automatically). So it should be empty in your case. That could already solve the connection problem.

然而,java.lang.NoClassDefFoundErrorindicates that probably temporary files or folders (for example, usually in/tmp/on Linux) of Studio may have been deleted, since the software has been started. Is that possible? If you keep getting this error, a Studio restart should help.

The address in the connection islocalhost, does that mean that you are running Studio on the master node? (Beeline, of course, runs on the Hadoop node, but Studio may not.)

I would also make sure that54310is the port to use for the NameNode. If you navigate tolocalhost:50070, is that the port that the Overview page shows?

Best,

Peter

asmahassani08

hello,

i have the same problem when i configure radoop rapidminer

this is what have in logs:

(2018年8月11日10:28:23 AM]: Integration test for 'hadoop' started.
(2018年8月11日10:28:23 AM]: Removed test Kerberos beacuse Security is not enabled
(2018年8月11日10:28:23 AM]: Using Radoop version 9.0.0.
(2018年8月11日10:28:23 AM]: Running 25 tests: [Hive connection, Fetch dynamic settings, Java version, NameNode networking, DataNode networking, YARN services networking, HDFS, MapReduce, Radoop temporary directory, MapReduce staging directory, Spark staging directory, Spark assembly jar existence, UDF jar upload, Create permanent UDFs, HDFS upload, Radoop jar upload, Hive load data, Import job, SQL query (aggregation), Spark job, Hive export, UDF query, Distributed Cache, UDAF query, Job kill]
(2018年8月11日10:28:23 AM]: Running test 1/25: Hive connection
(2018年8月11日10:28:23 AM]: Hive server 2 connection (localhost:10000) test started.
(2018年8月11日10:28:24 AM] SEVERE: Test failed: Hive connection
(2018年8月11日10:28:24 AM]: Cleaning after test: Hive connection
(2018年8月11日10:28:24 AM]: Total time: 1.093s
(2018年8月11日10:28:24 AM]: java.lang.NoClassDefFoundError: org/apache/hadoop/hive/metastore/api/MetaException
at org.apache.hadoop.hive.jdbc.HiveDriver.connect(HiveDriver.java:104)
at com.rapidminer.extension.jdbc.tools.jdbc.DriverAdapter.connect(DriverAdapter.java:40)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at eu.radoop.datahandler.hive.PooledStatement.lambda$connect$0(PooledStatement.java:214)
at eu.radoop.tools.ExceptionTools.check(ExceptionTools.java:301)
at eu.radoop.datahandler.hive.PooledStatement.connect(PooledStatement.java:189)
at eu.radoop.datahandler.hive.StatementPool.getStatement(StatementPool.java:314)
at eu.radoop.datahandler.hive.StatementPool.getStatement(StatementPool.java:181)
at eu.radoop.datahandler.hive.HiveHandler.runFastQueryPrivilegedAction(HiveHandler.java:1010)
at eu.radoop.datahandler.hive.HiveHandler.runFastQuery(HiveHandler.java:986)
at eu.radoop.datahandler.hive.HiveHandler.getSimpleListFast(HiveHandler.java:2575)
at eu.radoop.datahandler.hive.HiveHandler.getTableList(HiveHandler.java:2507)
at eu.radoop.connections.service.test.connection.TestHiveConnection.call(TestHiveConnection.java:51)
at eu.radoop.connections.service.test.connection.TestHiveConnection.call(TestHiveConnection.java:25)
at eu.radoop.connections.service.test.RadoopTestContext.lambda$runTest$1(RadoopTestContext.java:279)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.lang.ClassNotFoundException: org.apache.hadoop.hive.metastore.api.MetaException
at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
at java.lang.ClassLoader.loadClass(ClassLoader.java:424)
at java.lang.ClassLoader.loadClass(ClassLoader.java:357)
... 20 more

(2018年8月11日10:28:24 AM] SEVERE: java.lang.NoClassDefFoundError: org/apache/hadoop/hive/metastore/api/MetaException
(2018年8月11日10:28:24 AM] SEVERE: Hive server 2 connection test failed. Please check that the server/daemon runs and is accessible on the address and port you specified.
(2018年8月11日10:28:24 AM] SEVERE: Test failed: Hive connection
(2018年8月11日10:28:24 AM] SEVERE: Integration test for 'hadoop' failed.

is there any solution?

当我运行jps我有这个

1472 NameNode
3856 DataNode
12756 Jps
14164 SparkSubmit
14228 NodeManager
7544 GUILauncher
10860 RunJar
12524 ResourceManager

感谢他lp