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

Float-point numbers are displayed with different precision in Beeline/JDBC

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersCreate sub-taskConvert to sub-taskMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.2.1
    • 1.2.2, 1.3.0, 2.0.0
    • None
    • None

    Description

      When inserting float-point numbers to a table, the values displayed on beeline or jdbc are with different precision.

      How to reproduce:

      0: jdbc:hive2://localhost:10000> create table decimals (f float, af array<float>, d double, ad array<double>) stored as parquet;
      No rows affected (0.294 seconds)
      
      0: jdbc:hive2://localhost:10000> insert into table decimals select 1.10058, array(cast(1.10058 as float)), 2.0133, array(2.0133) from dummy limit 1;
      ...
      No rows affected (20.089 seconds)
      
      0: jdbc:hive2://localhost:10000> select f, af, af[0], d, ad[0] from decimals;
      +---------------------+------------+---------------------+---------+---------+--+
      |          f          |     af     |         _c2         |    d    |   _c4   |
      +---------------------+------------+---------------------+---------+---------+--+
      | 1.1005799770355225  | [1.10058]  | 1.1005799770355225  | 2.0133  | 2.0133  |
      +---------------------+------------+---------------------+---------+---------+--+
      

      When displaying arrays, the values are displayed correctly, but if I print a specific element, it is then displayed with more decimal positions.

      Attachments

        1. HIVE-11802.3.patch
          6 kB
          Sergio Peña

        Issue Links

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            lijp87 lijp Assign to me
            spena Sergio Peña
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment