[HIVE-24189] Enable logging executed raw sql statements for HiveServer2 before parsing

• Type: Improvement
• Status: Open
• Priority: Trivial
• Resolution: Unresolved
• Affects Version/s: 3.1.0
• Component/s: HiveServer2
• Target Version/s: 3.1.0
• Assignee: ji.chen
• Reporter: ji.chen
• Created: 22/Sep/20 11:19
• Updated: 23/Sep/20 09:49

Description

Current Hiveserver2 lacks the feature of logging command related statement in hiveserver2 log files. It will cause inconvenience for customer to debug command related statement. 

We have follow case:

HiveServer2 is crashed when our customer executed SET statement, however we can't find exact SET  statement customer was executed before.If raw statement is recorded in hiveserver2 logs, it will facilitate us to debugging command related statement issue.

So we propose a improvement to write the raw statement in hiveserver2 log

property  hive.session.raw.statement.verbose is introduced to control output of raw sql statement, by default, it is enabled.

it can be disabled by setting hive.session.raw.statement.verbose to false.

 

 

We have attached patch