Hive
  1. Hive
  2. HIVE-6174

Beeline "set varible" doesn't show the value of the variable as Hive CLI

    Details

    • Type: Bug Bug
    • Status: Resolved
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 0.10.0, 0.11.0, 0.12.0
    • Fix Version/s: 0.13.0
    • Component/s: CLI
    • Labels:
      None

      Description

      Currently it displays nothing.

      0: jdbc:hive2://> set env:TERM; 
      0: jdbc:hive2://> 
      

      In contrast, Hive CLI displays the value of the variable.

      hive> set env:TERM; 
      env:TERM=xterm
      
      1. HIVE-6174.patch
        5 kB
        Xuefu Zhang
      2. HIVE-6174.2.patch
        7 kB
        Xuefu Zhang
      3. HIVE-5174.3.patch
        7 kB
        Xuefu Zhang

        Issue Links

          Activity

          Hide
          Xuefu Zhang added a comment -

          With the patch, the console now displays for both remote mode and embedded mode:

          0: jdbc:hive2://localhost:10000> set env:TERM;
          [HiveQueryResultSet/next] 0
          +-----------------+
          |       set       |
          +-----------------+
          | env:TERM=xterm  |
          +-----------------+
          
          Show
          Xuefu Zhang added a comment - With the patch, the console now displays for both remote mode and embedded mode: 0: jdbc:hive2: //localhost:10000> set env:TERM; [HiveQueryResultSet/next] 0 +-----------------+ | set | +-----------------+ | env:TERM=xterm | +-----------------+
          Hide
          Xuefu Zhang added a comment -

          Patch #2 added test case for Beeline as well.

          Show
          Xuefu Zhang added a comment - Patch #2 added test case for Beeline as well.
          Hide
          Hive QA added a comment -

          Overall: -1 at least one tests failed

          Here are the results of testing the latest attachment:
          https://issues.apache.org/jira/secure/attachment/12622443/HIVE-6174.2.patch

          ERROR: -1 due to 1 failed/errored test(s), 4919 tests executed
          Failed tests:

          org.apache.hive.jdbc.miniHS2.TestHiveServer2.testGetVariableValue
          

          Test results: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/855/testReport
          Console output: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/855/console

          Messages:

          Executing org.apache.hive.ptest.execution.PrepPhase
          Executing org.apache.hive.ptest.execution.ExecutionPhase
          Executing org.apache.hive.ptest.execution.ReportingPhase
          Tests exited with: TestsFailedException: 1 tests failed
          

          This message is automatically generated.

          ATTACHMENT ID: 12622443

          Show
          Hive QA added a comment - Overall : -1 at least one tests failed Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12622443/HIVE-6174.2.patch ERROR: -1 due to 1 failed/errored test(s), 4919 tests executed Failed tests: org.apache.hive.jdbc.miniHS2.TestHiveServer2.testGetVariableValue Test results: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/855/testReport Console output: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/855/console Messages: Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase Tests exited with: TestsFailedException: 1 tests failed This message is automatically generated. ATTACHMENT ID: 12622443
          Hide
          Hive QA added a comment -

          Overall: +1 all checks pass

          Here are the results of testing the latest attachment:
          https://issues.apache.org/jira/secure/attachment/12622514/HIVE-5174.3.patch

          SUCCESS: +1 4919 tests passed

          Test results: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/868/testReport
          Console output: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/868/console

          Messages:

          Executing org.apache.hive.ptest.execution.PrepPhase
          Executing org.apache.hive.ptest.execution.ExecutionPhase
          Executing org.apache.hive.ptest.execution.ReportingPhase
          

          This message is automatically generated.

          ATTACHMENT ID: 12622514

          Show
          Hive QA added a comment - Overall : +1 all checks pass Here are the results of testing the latest attachment: https://issues.apache.org/jira/secure/attachment/12622514/HIVE-5174.3.patch SUCCESS: +1 4919 tests passed Test results: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/868/testReport Console output: http://bigtop01.cloudera.org:8080/job/PreCommit-HIVE-Build/868/console Messages: Executing org.apache.hive.ptest.execution.PrepPhase Executing org.apache.hive.ptest.execution.ExecutionPhase Executing org.apache.hive.ptest.execution.ReportingPhase This message is automatically generated. ATTACHMENT ID: 12622514
          Hide
          Xuefu Zhang added a comment -
          Show
          Xuefu Zhang added a comment - RB: https://reviews.apache.org/r/16807/
          Hide
          Mohammad Kamrul Islam added a comment -

          +1
          Looks very straight forward.

          Show
          Mohammad Kamrul Islam added a comment - +1 Looks very straight forward.
          Hide
          Prasad Mujumdar added a comment -

          +1
          Looks fine to me.

          Show
          Prasad Mujumdar added a comment - +1 Looks fine to me.
          Hide
          Xuefu Zhang added a comment -

          Patch committed to trunk. Thanks to Prasad for the review.

          Show
          Xuefu Zhang added a comment - Patch committed to trunk. Thanks to Prasad for the review.

            People

            • Assignee:
              Xuefu Zhang
              Reporter:
              Xuefu Zhang
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development