Details

    • Sprint:
      DV Sprint 63
    • Story Points:
      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.

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  shawkins Steven Hawkins
                  Reporter:
                  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