[
https://issues.apache.org/jira/browse/ASTERIXDB-2960?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ian Maxon closed ASTERIXDB-2960.
--------------------------------
Resolution: Fixed
> LOJ on subquery with UNNEST for array indexes throwing type error
> -----------------------------------------------------------------
>
> Key: ASTERIXDB-2960
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-2960
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: IDX - Indexes
> Reporter: Glenn Justo Galvizo
> Assignee: Glenn Justo Galvizo
> Priority: Major
>
> A query like this currently throws an error when trying to optimize for an
> LOJ INLJ:
>
> {code:java}
> SET `compiler.arrayindex` "true";
> DROP DATAVERSE TestDataverse IF EXISTS;
> CREATE DATAVERSE TestDataverse;
> USE TestDataverse;
> CREATE TYPE GenericType AS { _id: uuid };
> CREATE DATASET IndexedDataset (GenericType)
> PRIMARY KEY _id AUTOGENERATED;
> CREATE DATASET ProbeDataset (GenericType)
> PRIMARY KEY _id AUTOGENERATED;
> CREATE INDEX TestIdx
> ON IndexedDataset (
> UNNEST items
> SELECT val : bigint
> );
> FROM ProbeDataset P
> LEFT OUTER JOIN (
> FROM IndexedDataset I
> UNNEST I.items II
> SELECT VALUE II.val
> ) AS IIV
> ON IIV /* +indexnl */ = TO_BIGINT(P.val)
> SELECT DISTINCT P;
> {code}
>
>
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
