[jira] [Updated] (ASTERIXDB-2965) Predicate with constant on join query for composite atomic array indexes prevents acceleration

["Ian Maxon (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/ASTERIXDB-2965?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ian Maxon updated ASTERIXDB-2965:
---------------------------------
    Summary: Predicate with constant on join query for composite atomic array indexes prevents acceleration  (was: Predicate with constant on join query for array indexes prevents acceleration)

> Predicate with constant on join query for composite atomic array indexes prevents acceleration
> ----------------------------------------------------------------------------------------------
>
>                 Key: ASTERIXDB-2965
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-2965
>             Project: Apache AsterixDB
>          Issue Type: Bug
>          Components: IDX - Indexes
>            Reporter: Glenn Justo Galvizo
>            Assignee: Glenn Justo Galvizo
>            Priority: Major
>
> *Found with RQG.
> Specifying a constant on an indexed field along with a join on that same indexed field prevents INLJ acceleration.
> {code:java}
> USE TestDataverse;
> DROP DATASET IndexedDataset IF EXISTS;
>  CREATE DATASET IndexedDataset (TestType)
>  PRIMARY KEY _id AUTOGENERATED;
>  CREATE INDEX testIndex ON IndexedDataset ( container_object_1.double_rand_4.contained_object_2: DOUBLE, ( UNNEST string_rand_26_c.contained_object_1 : STRING ) );
>  SET `compiler.arrayindex` "true";
>  USE TestDataverse;
>  FROM ProbeDataset1 AS D2,
>  IndexedDataset AS D1
>  WHERE ( D1.container_object_1.double_rand_4.contained_object_2 /* +indexnl */ >= (TO_DOUBLE(D2.integer_rand_4) + 0.5) ) AND
>  ( SOME V1 IN D1.string_rand_26_c.contained_object_1 SATISFIES ( V1 /* +indexnl */ <= CODEPOINT_TO_STRING([100 + D2.string_rand_26_c]) ) ) AND
>  D1.container_object_1.double_rand_4.contained_object_2 = 2
>  SELECT D1._id AS PK1, D2._id AS PK2
>  ORDER BY D1._id, D2._id
>  LIMIT 100;{code}
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)