Uploaded image for project: 'IMPALA'
  1. IMPALA
  2. IMPALA-2710

Overflows during expr evaluation should result in an error or null

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • Impala 2.0, Impala 2.3.0
    • None
    • Backend

    Description

      Currently, not all expressions will result in NULL when an overflow happens. So determining if the resulting value is valid may be very difficult.

      Easy example:

      [nightly-3.vpc.cloudera.com:21000] > select sum(99999999999999999999999999999999999999) from sample_07;
      Query: select sum(99999999999999999999999999999999999999) from sample_07
      +---------------------------------------------+
      | sum(99999999999999999999999999999999999999) |
      +---------------------------------------------+
      | -48332794867108158136654998487907173175     |
      +---------------------------------------------+
      

      the sum above should never be negative, but if it were a positive value and the sum were over a column it would be hard to tell if the value was correct.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              caseyc casey
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated: