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

Beeline output displays column heading even if --showHeader=false is set

Log workAgile BoardRank to TopRank to BottomVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 0.13.0
    • Fix Version/s: 0.14.0
    • Component/s: CLI
    • Labels:
      None

      Description

      A few minor/cosmetic issues with the beeline CLI.
      1) Tool prints the column headers despite setting the --showHeader to false. This property only seems to affect the subsequent header information that gets printed based on the value of property "headerInterval" (default value is 100).
      2) When "showHeader" is true & "headerInterval > 0", the header after the first interval gets printed after <headerInterval - 1> rows. The code seems to count the initial header as a row, if you will.
      3) The table footer(the line that closes the table) does not get printed if the "showHeader" is false. I think the table should get closed irrespective of whether it prints the header or not.

      0: jdbc:hive2://localhost:10000> select * from stringvals;
      +------+
      | val  |
      +------+
      | t    |
      | f    |
      | T    |
      | F    |
      | 0    |
      | 1    |
      +------+
      6 rows selected (3.998 seconds)
      0: jdbc:hive2://localhost:10000> !set headerInterval 2
      0: jdbc:hive2://localhost:10000> select * from stringvals;
      +------+
      | val  |
      +------+
      | t    |
      +------+
      | val  |
      +------+
      | f    |
      | T    |
      +------+
      | val  |
      +------+
      | F    |
      | 0    |
      +------+
      | val  |
      +------+
      | 1    |
      +------+
      6 rows selected (0.691 seconds)
      0: jdbc:hive2://localhost:10000> !set showHeader false
      0: jdbc:hive2://localhost:10000> select * from stringvals;
      +------+
      | val  |
      +------+
      | t    |
      | f    |
      | T    |
      | F    |
      | 0    |
      | 1    |
      6 rows selected (1.728 seconds)
      

        Attachments

        1. HIVE-7200.3.patch
          2 kB
          Naveen Gangam
        2. HIVE-7200.2.patch
          2 kB
          Naveen Gangam
        3. HIVE-7200.1.patch
          1 kB
          Naveen Gangam

        Issue Links

          Activity

          $i18n.getText('security.level.explanation', $currentSelection) Viewable by All Users
          Cancel

            People

            • Assignee:
              ngangam Naveen Gangam Assign to me
              Reporter:
              ngangam Naveen Gangam

              Dates

              • Created:
                Updated:
                Resolved:

                Issue deployment