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

Incorrect rounding in decimal data types

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Critical
    • Resolution: Unresolved
    • None
    • None
    • Database/Schema
    • None

    Description

      I have a numeric field in a file in my data lake and created a hive external table pointing to this field. The field value is 0.3333333333333333333333333333333333333333 but when I fetched this record using the query it display only 0.3333333333333333. I tried using DECIMAL and DOUBLE data types but nothing worked.is this a bug or am I not using the exact data type for this?

      Thanks,
      NIkesh

      Attachments

        1. ANA_AUTO_E.csv
          0.1 kB
          Nikesh

        Activity

          People

            Unassigned Unassigned
            Nikesh Nikesh
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated: