[
https://issues.apache.org/jira/browse/ASTERIXDB-2966?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17417181#comment-17417181
]
ASF subversion and git services commented on ASTERIXDB-2966:
------------------------------------------------------------
Commit 0d222c3f1fb46c3bca2b8ed35c1eebab7296820b in asterixdb's branch
refs/heads/master from ggalvizo
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=0d222c3 ]
[ASTERIXDB-2956][IDX] Adding RQG for array indexes + fixes
- user model changes: no
- storage format changes: no
- interface changes: no
Adding RQGs for array indexes and the fixes detailed below:
- Handle conjuncts with nested ANDs (for SOME AND EVERY).
- Disable merge-select local rewrite when a join is encountered.
- Analyze for array indexes for each ASSIGN op (as opposed to the last
ASSIGN).
- Disable INLJ with cross products in probe (ASTERIXDB-2966 bug).
- Enable general theta join INLJ acceleration with array indexes.
- Fix type builder bug for getting array type (at initial ingestion).
- Small fixes to get composite-atomic index initial ingestion working
(now evaluators and record descriptors between operators are correct).
Change-Id: I25a0f34010bca6296e75c6d6bc04eb515376941f
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/13263
Integration-Tests: Jenkins <[email protected]>
Tested-by: Jenkins <[email protected]>
Reviewed-by: Dmitry Lychagin <[email protected]>
> Cross product w/ array index gives different result
> ---------------------------------------------------
>
> Key: ASTERIXDB-2966
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-2966
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: IDX - Indexes
> Reporter: Glenn Justo Galvizo
> Assignee: Glenn Justo Galvizo
> Priority: Major
>
> *Found with RQG
> The following query gives different results when the array index compiler
> flag is raised.
> {code:java}
> FROM ProbeDataset1 AS D2,
> ProbeDataset2 AS D3,
> IndexedDataset AS D1
> WHERE ( SOME AND EVERY V1 IN
> D1.container_object_2.nesting_1.contained_object_1 SATISFIES (
> V1.double_rand_4.contained_object_1 /* +indexnl */ >=
> (TO_DOUBLE(D3.integer_rand_4) + 0.5) ) )
> SELECT COUNT(*);{code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
