You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "Glenn Justo Galvizo (Jira)" <ji...@apache.org> on 2021/07/19 16:24:00 UTC
[jira] [Updated] (ASTERIXDB-2932) Failing to create open array
indexes of multiple UNNESTs + record types.
[ https://issues.apache.org/jira/browse/ASTERIXDB-2932?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Glenn Justo Galvizo updated ASTERIXDB-2932:
-------------------------------------------
Description:
The following CREATE INDEX throws an error:
{code:java}
DROP DATAVERSE TestDataverse IF EXISTS;
CREATE DATAVERSE TestDataverse;
USE TestDataverse;
CREATE TYPE TestType AS {
_id: uuid
};
CREATE DATASET Dataset1 (TestType)
PRIMARY KEY _id AUTOGENERATED;
CREATE INDEX d1Idx
ON Dataset1 ( UNNEST f1.f2
SELECT f3 : bigint );
{code}
An CREATE INDEX like "UNNEST f1.f2" works, but adding the SELECT throws an error.
was:
The following CREATE INDEX throws an error:
{code:java}
DROP DATAVERSE TestDataverse IF EXISTS;
CREATE DATAVERSE TestDataverse;
USE TestDataverse;
CREATE TYPE TestType AS {
_id: uuid
};
CREATE DATASET Dataset1 (TestType)
PRIMARY KEY _id AUTOGENERATED;
CREATE INDEX d1Idx
ON Dataset1 ( UNNEST f1.f2
SELECT f3 : bigint );
{code}
An CREATE INDEX like "UNNEST f1.f2" works, but adding the SELECT throws this error.
> Failing to create open array indexes of multiple UNNESTs + record types.
> ------------------------------------------------------------------------
>
> Key: ASTERIXDB-2932
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-2932
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: IDX - Indexes
> Reporter: Glenn Justo Galvizo
> Assignee: Glenn Justo Galvizo
> Priority: Major
>
> The following CREATE INDEX throws an error:
> {code:java}
> DROP DATAVERSE TestDataverse IF EXISTS;
> CREATE DATAVERSE TestDataverse;
> USE TestDataverse;
> CREATE TYPE TestType AS {
> _id: uuid
> };
> CREATE DATASET Dataset1 (TestType)
> PRIMARY KEY _id AUTOGENERATED;
> CREATE INDEX d1Idx
> ON Dataset1 ( UNNEST f1.f2
> SELECT f3 : bigint );
> {code}
> An CREATE INDEX like "UNNEST f1.f2" works, but adding the SELECT throws an error.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)