[HIVE-20945] set conf more than 2 is not work although whitelist set in hiveserver2 in Hue or Zeppelin, ...

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Assignee: Unassigned
• Reporter: maekchi
• Created: 20/Nov/18 10:49
• Updated: 21/Oct/22 07:20

Description

I use hive 2.3.2 with Hue and Zeppellin.

and I try below statement.

set something1=1;

set something2=3;

set something3=4;

It works well in beeline, but not in Hue and Zeppelin.

The error message : Cannot modify set something2 at runtime. It is not in list of params that are allowed to be modified at runtime

however I already add it in whitelist.

After I debugging hive code, I guess this code is something strange in org/apache/hive/service/cli/operation/HiveCommandOperation.java

Line 111
String command = getStatement().trim();
String[] tokens = statement.split("
s");  
String commandArgs = command.substring(tokens[0].length()).trim();

 

I think it should be like this 

String[] tokens = command.split("
s");  

I test it, and it works very well.