Error Radoop with hive connection

hfescuderohfescudero Member Posts: 1 Newbie
edited August 2019 in Help
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 ( 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(
    at eu.radoop.datahandler.hive.HiveHandler.getTableList(
    at eu.radoop.connections.service.test.RadoopTestContext.lambda$runTest$1(
    at java.util.concurrent.ThreadPoolExecutor.runWorker(
    at java.util.concurrent.ThreadPoolExecutor$
Caused by: eu.radoop.exception.NoStackTraceOperatorException: HiveQL error. Message: Error while processing statement: Cannot modify at runtime. It is not in list of params that are allowed to be modified at runtime
    at eu.radoop.RadoopTools.formattedOperatorException(
    at eu.radoop.RadoopTools.formattedOperatorException(
    at eu.radoop.datahandler.hive.HiveHandler.runFastQueryPrivilegedAction(
    at eu.radoop.datahandler.hive.HiveHandler.runFastQuery(
    at eu.radoop.datahandler.hive.HiveHandler.getSimpleListFast(

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



  • sgenzersgenzer Administrator, Moderator, Employee, RapidMiner Certified Analyst, Community Manager, Member, University Professor, PM Moderator Posts: 2,959 Community Manager
    hi @hfescudero hmm sorry no one has chimed in here. Is this still a problem?

Sign In or Register to comment.