Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.
Error Radoop with hive connection
hfescudero
Member Posts: 1 
Learner I
Hello . I am configuring Radoop with Hadoop HDP hortonworks (import from cluster manager) and when I run tests in hive it return the following error
[Aug 9, 2019 10:02:36 AM]: Integration test for 'DL_LMK_DESA 2' started.
[Aug 9, 2019 10:02:36 AM]: Using Radoop version 9.3.0.
[Aug 9, 2019 10:02:36 AM]: Running 11 tests: [Hive connection, Fetch dynamic settings, UDF jar upload, Create permanent UDFs, HDFS upload, Hive load data, SQL query (aggregation), Hive export, UDF query, Distributed Cache, UDAF query]
[Aug 9, 2019 10:02:36 AM]: Running test 1/11: Hive connection
[Aug 9, 2019 10:02:36 AM]: Hive server 2 connection (10.134.193.248:10000) test started.
[Aug 9, 2019 10:02:36 AM] SEVERE: Test failed: Hive connection
[Aug 9, 2019 10:02:36 AM]: Cleaning after test: Hive connection
[Aug 9, 2019 10:02:36 AM]: Total time: 0.214s
[Aug 9, 2019 10:02:36 AM]: com.rapidminer.operator.OperatorException: Error retrieving Hive object list. Please check your Hive server 2 connection settings.
at eu.radoop.datahandler.hive.HiveHandler.getSimpleListFast(HiveHandler.java:2586)
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:280)
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)
[Aug 9, 2019 10:02:36 AM]: Using Radoop version 9.3.0.
[Aug 9, 2019 10:02:36 AM]: Running 11 tests: [Hive connection, Fetch dynamic settings, UDF jar upload, Create permanent UDFs, HDFS upload, Hive load data, SQL query (aggregation), Hive export, UDF query, Distributed Cache, UDAF query]
[Aug 9, 2019 10:02:36 AM]: Running test 1/11: Hive connection
[Aug 9, 2019 10:02:36 AM]: Hive server 2 connection (10.134.193.248:10000) test started.
[Aug 9, 2019 10:02:36 AM] SEVERE: Test failed: Hive connection
[Aug 9, 2019 10:02:36 AM]: Cleaning after test: Hive connection
[Aug 9, 2019 10:02:36 AM]: Total time: 0.214s
[Aug 9, 2019 10:02:36 AM]: com.rapidminer.operator.OperatorException: Error retrieving Hive object list. Please check your Hive server 2 connection settings.
at eu.radoop.datahandler.hive.HiveHandler.getSimpleListFast(HiveHandler.java:2586)
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:280)
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: eu.radoop.exception.NoStackTraceOperatorException: HiveQL error. Message: Error while processing statement: Cannot modify hive.remove.orderby.in.subquery at runtime. It is not in list of params that are allowed to be modified at runtime
at eu.radoop.RadoopTools.formattedOperatorException(RadoopTools.java:1700)
at eu.radoop.RadoopTools.formattedOperatorException(RadoopTools.java:1704)
at eu.radoop.datahandler.hive.HiveHandler.runFastQueryPrivilegedAction(HiveHandler.java:1048)
at eu.radoop.datahandler.hive.HiveHandler.runFastQuery(HiveHandler.java:986)
at eu.radoop.datahandler.hive.HiveHandler.getSimpleListFast(HiveHandler.java:2575)
at eu.radoop.RadoopTools.formattedOperatorException(RadoopTools.java:1700)
at eu.radoop.RadoopTools.formattedOperatorException(RadoopTools.java:1704)
at eu.radoop.datahandler.hive.HiveHandler.runFastQueryPrivilegedAction(HiveHandler.java:1048)
at eu.radoop.datahandler.hive.HiveHandler.runFastQuery(HiveHandler.java:986)
at eu.radoop.datahandler.hive.HiveHandler.getSimpleListFast(HiveHandler.java:2575)
I have test the connetion from same Machine with DBeaber and it connect ok.
Hive is configured with no authetication ( no security)
Can anybody help me with this?
thank you
Fernando1
Answers
Scott