[HIVE-25158] Beeline/hive command can't get operation logs when hive.session.id is set

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Labels: pull-request-available
• Assignee: Robbie Zhang
• Reporter: Robbie Zhang
• Created: 25/May/21 00:48
• Updated: 07/Dec/21 00:12

Description

Usually, we can see the operation logs when we run a query from beeline/hive. For example, the query ID, the time taken in compiling/executing, the application information, etc. But if we use "–hiveconf hive.session.id=xxxx" to set the session ID, we can't see the operation logs any more. Here are examples:

• Without hive.session.id

  $ hive -e "select 1"
  SLF4J: Class path contains multiple SLF4J bindings.
  ...
  Connected to: Apache Hive (version 3.1.3000.7.1.6.0-297)
  Driver: Hive JDBC (version 3.1.3000.7.1.6.0-297)
  Transaction isolation: TRANSACTION_REPEATABLE_READ
  INFO  : Compiling command(queryId=hive_20210524105207_9d0774b2-8108-4800-a5e4-3b950ae03198): select 1
  INFO  : Semantic Analysis Completed (retrial = false)
  INFO  : Created Hive schema: Schema(fieldSchemas:[FieldSchema(name:_c0, type:int, comment:null)], properties:null)
  INFO  : Completed compiling command(queryId=hive_20210524105207_9d0774b2-8108-4800-a5e4-3b950ae03198); Time taken: 0.122 seconds
  INFO  : Executing command(queryId=hive_20210524105207_9d0774b2-8108-4800-a5e4-3b950ae03198): select 1
  INFO  : Completed executing command(queryId=hive_20210524105207_9d0774b2-8108-4800-a5e4-3b950ae03198); Time taken: 0.016 seconds
  INFO  : OK
  +------+
  | _c0  |
  +------+
  | 1    |
  +------+
  1 row selected (0.318 seconds)
  Beeline version 3.1.3000.7.1.6.0-297 by Apache Hive
  

• With hive.session.id

  $ hive --hiveconf hive.session.id=abcd -e "select 1"
  SLF4J: Class path contains multiple SLF4J bindings.
  ...
  Connected to: Apache Hive (version 3.1.3000.7.1.6.0-297)
  Driver: Hive JDBC (version 3.1.3000.7.1.6.0-297)
  Transaction isolation: TRANSACTION_REPEATABLE_READ
  +------+
  | _c0  |
  +------+
  | 1    |
  +------+
  1 row selected (5.862 seconds)
  Beeline version 3.1.3000.7.1.6.0-297 by Apache Hive
  

Issue Links

• links to: GitHub Pull Request #2319