Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-5945

queries with SUM(big integer) throw NPE

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Critical
    • 14.0, 13.0.3, 13.1.1
    • None
    • Query Engine
    • None
    • DV Sprint 63
    • 0.5

    Description

      Both queries:

      SELECT A.INTKEY, A.BIGINTEGERVALUE, (SELECT SUM(B.BIGINTEGERVALUE) FROM bqt.SMALLA AS B WHERE B.INTKEY = A.INTKEY) FROM bqt.SMALLA AS A;
SELECT INTKEY, BIGINTEGERVALUE FROM bqt.SMALLA AS A WHERE BIGINTEGERVALUE >= (SELECT SUM(BIGINTEGERVALUE) FROM bqt.SMALLA AS B WHERE A.INTKEY = B.INTKEY);

      throw NPE when they are run against amazon athena vdb.

      The same queries return the right data when they are run against amazon athena directly.

      Attached stacktrace points that the problem is in SUM(big integer).
      A similar query with SUM(long) works fine.

      Attachments

        Issue Links

          clones

          Bug - A problem that impairs or prevents the functions of the product. ENTESB-13656 [DV] queries with SUM(big integer) throw NPE (amazon athena)

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Done

          Activity

            People

              rhn-engineering-shawkins Steven Hawkins
              rhn-engineering-shawkins Steven Hawkins
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 4 hours
                  4h
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 4 hours
                  4h