Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-24189

Enable logging executed raw sql statements for HiveServer2 before parsing

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Trivial
    • Resolution: Unresolved
    • Affects Version/s: 3.1.0
    • Fix Version/s: None
    • Component/s: HiveServer2
    • Labels:
      None
    • Target Version/s:

      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

        Attachments

          Activity

            People

            • Assignee:
              jichen0919@126.com ji.chen
              Reporter:
              jichen0919@126.com ji.chen
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: