The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here
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