Peeyush Gupta created ASTERIXDB-3323:
----------------------------------------

             Summary: 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


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)

Reply via email to