[
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)
