[
https://issues.apache.org/jira/browse/ASTERIXDB-3305?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ian Maxon updated ASTERIXDB-3305:
---------------------------------
Labels: triaged (was: )
> 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
> Labels: triaged
> 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)
