[jira] [Commented] (ASTERIXDB-2959) Composite atomic-array indexes not ingesting data on creation

["ASF subversion and git services (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/ASTERIXDB-2959?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17415196#comment-17415196 ] 

ASF subversion and git services commented on ASTERIXDB-2959:
------------------------------------------------------------

Commit 2ee6d37456c6149cd088d236b12bcb6701d2004f in asterixdb's branch refs/heads/master from ggalvizo
[ https://gitbox.apache.org/repos/asf?p=asterixdb.git;h=2ee6d37 ]

[ASTERIXDB-2959][IDX] Fix initial composite atomic-array index ingestion on creation

- user model changes: no
- storage format changes: no
- interface changes: no

Composite atomic-array indexes were not ingesting properly, due to the
wrong source column being UNNESTed in the loading job. This small change
addresses this.

Change-Id: I86af26a7649e0631a0555e1f98fb5fea8e63528e
Reviewed-on: https://asterix-gerrit.ics.uci.edu/c/asterixdb/+/13163
Tested-by: Jenkins <je...@fulliautomatix.ics.uci.edu>
Integration-Tests: Jenkins <je...@fulliautomatix.ics.uci.edu>
Reviewed-by: Dmitry Lychagin <dm...@couchbase.com>


> Composite atomic-array indexes not ingesting data on creation
> -------------------------------------------------------------
>
>                 Key: ASTERIXDB-2959
>                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-2959
>             Project: Apache AsterixDB
>          Issue Type: Bug
>          Components: IDX - Indexes
>            Reporter: Glenn Justo Galvizo
>            Assignee: Glenn Justo Galvizo
>            Priority: Major
>
> The following sequence of events does not deliver the right result. The issue lies with ingestion job created on CREATE INDEX.
> {noformat}
> SET               `compiler.arrayindex` "true";
> DROP DATAVERSE    TestDataverse IF EXISTS;
> CREATE DATAVERSE  TestDataverse;
> USE               TestDataverse;
> CREATE TYPE       GenericType AS { _id: bigint  };
> CREATE DATASET    TestDataset (GenericType)
> PRIMARY KEY       _id;
> INSERT INTO       TestDataset [
>     { "_id": 100, "f": 1, "a": {"b": [{"c": {"d": 1}}]} },
>     { "_id": 101, "f": "a", "a": null },
>     { "_id": 102, "f": "a", "a": {"b": null} },
>     { "_id": 103, "f": "a", "a": {"b": [{"c": null}]} },
>     { "_id": 104, "f": "a", "a": {"b": [{"c": {"d": null}}]} }
>     ];
> CREATE INDEX      TestIdx
> ON                TestDataset (
>     f : bigint,
>     UNNEST a.b
>     SELECT c.d : bigint
> );
> FROM TestDataset D
> UNNEST D.a.b AB
> WHERE D.f = 1 AND AB.c.d = 1
> SELECT D._id;{noformat}



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