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

Decimal datatype is truncating 1st digit of the number while storing into Parquet file

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

    Details

    • Type: Bug
    • Status: Open
    • Priority: Blocker
    • Resolution: Unresolved
    • Affects Version/s: 1.1.0
    • Fix Version/s: None
    • Component/s: File Formats, Hive
    • Labels:
      None
    • Environment:

      CDH 5.7

    • Flags:
      Important

      Description

      We declared one of the Hive Parquet table column as Decimal (38,20) .
      We have inserted data from one of the intermediate table using sum function with "insert into select " statement.
      Sum value is 9389587.19800467 .
      Where as it is getting stored as 389587.19800467
      First digit of number is getting truncated while it getting stored in Table.

        Attachments

          Activity

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

            People

            • Assignee:
              Unassigned Assign to me
              Reporter:
              surendranatha_reddy Surendranatha Reddy

              Dates

              • Created:
                Updated:

                Issue deployment