Wail Y. Alkowaileet created ASTERIXDB-3305:
----------------------------------------------
Summary: 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
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)
