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

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

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Blocker
    • Resolution: Unresolved
    • 1.1.0
    • None
    • File Formats, Hive
    • None
    • CDH 5.7

    • 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

          People

            Unassigned Unassigned
            surendranatha_reddy Surendranatha Reddy
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated: