You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "Ian Maxon (Jira)" <ji...@apache.org> on 2023/12/01 18:16:00 UTC
[jira] [Resolved] (ASTERIXDB-3323) array index bulkload not indexing all values
[ https://issues.apache.org/jira/browse/ASTERIXDB-3323?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ian Maxon resolved ASTERIXDB-3323.
----------------------------------
Resolution: Fixed
> array index bulkload not indexing all values
> --------------------------------------------
>
> Key: ASTERIXDB-3323
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3323
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: COMP - Compiler
> Reporter: Peeyush Gupta
> Priority: Major
> Labels: triaged
>
> The following example shows that array index has invalid entries when documents has an indexed field of a different type than the one used to create the index.
> {code:java}
> drop dataverse test if exists;
> create dataverse test;
> use test;
> CREATE TYPE dsType AS OPEN {id:int};
> CREATE DATASET ds1(dsType) primary key id;
> UPSERT INTO ds1 {"id": 5, "a": ["hello"], "b": [{"x":1}, {"x":"aa"}]};
> CREATE INDEX i2 ON ds1(UNNEST b SELECT x : int) EXCLUDE UNKNOWN KEY; {code}
> {code:java}
> SET `import-private-functions` `true`;
> FROM DUMP_INDEX("test", "ds1", "i2") AS v
> SELECT VALUE v
> ORDER BY v.values; {code}
> The output is empty instead of indexing (1, 5)
--
This message was sent by Atlassian Jira
(v8.20.10#820010)