[teiid-issues] [JBoss JIRA] (TEIID-5945) queries with SUM(big integer) throw NPE (amazon athena)

[Steven Hawkins (Jira)]

     [ https://issues.redhat.com/browse/TEIID-5945?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins moved ENTESB-13658 to TEIID-5945:
------------------------------------------------

           Project: Teiid  (was: Red Hat Fuse)
               Key: TEIID-5945  (was: ENTESB-13658)
          Workflow: classic default workflow  (was: ENTESB Planned Work)
       Component/s: Query Engine
                        (was: Data Integration)
    Target Release:   (was: fuse-next-GA)


> 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.



--
This message was sent by Atlassian Jira
(v7.13.8#713008)