[
https://issues.apache.org/jira/browse/ASTERIXDB-3305?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17784625#comment-17784625
]
ASF subversion and git services commented on ASTERIXDB-3305:
------------------------------------------------------------
Commit b85429f33698ad0e35adfa8291d372f62473d885 in asterixdb's branch
refs/heads/master from Wail Alkowaileet
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=b85429f336 ]
[MULTIPLE ISSUES][COMP] Fix multiple pushdown issues
- user model changes: no
- storage format changes: no
- interface changes: yes
Details:
- ASTERIXDB-3304: Some fields are not projected
- ASTERIXDB-3305: ClassCastException in left outer joins
Change-Id: I826ec12d598ef9fc38ded47f6f29e28ed75a047b
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/17933
Integration-Tests: Jenkins <[email protected]>
Tested-by: Jenkins <[email protected]>
Reviewed-by: Wail Alkowaileet <[email protected]>
Reviewed-by: Ali Alsuliman <[email protected]>
> ClassCastException in columnar datasets against LEFT OUTER queries
> ------------------------------------------------------------------
>
> Key: ASTERIXDB-3305
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3305
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: COMP - Compiler
> Affects Versions: 0.9.9
> Reporter: Wail Y. Alkowaileet
> Assignee: Wail Y. Alkowaileet
> Priority: Major
> Fix For: 0.9.9
>
>
> DDL:
> {noformat}
> CREATE COLLECTION DBLP
> PRIMARY KEY (id:int)
> WITH {
> "storage-format": {"format": "column"}
> };
> CREATE COLLECTION CSX
> PRIMARY KEY (id:int)
> WITH {
> "storage-format": {"format": "column"}
> }; {noformat}
>
> DML:
> {noformat}
> INSERT INTO DBLP {"id":6, "authors":"asdaskhdaskj dhas dhkasj dsakjdh"};
> INSERT INTO CSX {"id":7, "authors":"asdaskhdaskj dhas dhkasj dsakjdh"};
> {noformat}
>
> Query:
> {noformat}
> SELECT a.id AS aid, b.id AS bid
> FROM DBLP AS a
> LEFT OUTER UNNEST
> (
> SELECT VALUE b
> FROM CSX AS b
> WHERE a.authors = b.authors
> ) AS b
> ORDER BY a.id; {noformat}
>
> Error:
> {noformat}
> java.lang.Exception: ClassCastException: class
> org.apache.asterix.om.types.AUnionType cannot be cast to class
> org.apache.asterix.om.types.ARecordType
> (org.apache.asterix.om.types.AUnionType and
> org.apache.asterix.om.types.ARecordType are in unnamed module of loader
> 'app') {noformat}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
