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

queries with SUM(big integer) throw NPE

XMLWordPrintable

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

      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.

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

              Created:
              Updated:
              Resolved:

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