queries with SUM(big integer) throw NPE (amazon athena) ------------------------------------------------------- Key: TEIID-5945 URL: https://issues.redhat.com/browse/TEIID-5945 Project: Teiid Issue Type: Bug Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Major Both queries: {code:java} 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); {code} 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.