You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@asterixdb.apache.org by "Abdullah Alamoudi (JIRA)" <ji...@apache.org> on 2016/07/06 12:20:10 UTC

[jira] [Created] (ASTERIXDB-1520) Preclustered Group by is displayed incorrectly in the web UI

Abdullah Alamoudi created ASTERIXDB-1520:
--------------------------------------------

             Summary: Preclustered Group by is displayed incorrectly in the web UI
                 Key: ASTERIXDB-1520
                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-1520
             Project: Apache AsterixDB
          Issue Type: Bug
          Components: Web Interface
            Reporter: Abdullah Alamoudi



To reproduce, uncheck execute query, check show optimized plan and run the following:

drop dataverse test if exists;
create dataverse test;
use dataverse test;

create type AuxiliaryType as open {
  id:int32,
  num:int32
}

create type LineType as open {
}

create dataset Book(LineType) with meta(AuxiliaryType)
primary key meta().id;

create index NumIndex1 on Book(meta().num);
create index NumIndex2 on Book(linenum:int32) enforced;
create index NumIndex3 on Book(count1:int32) enforced;
create index NumIndex4 on Book(count2:int32) enforced;

for $t1 in dataset Book
where $t1.linenum < 10
order by $t1.linenum
return {
"linenum1": $t1.linenum,
"count1":$t1.count1,
"t2info": for $t2 in dataset Book
          where $t1.count1 /* +indexnl */= $t2.count2
          order by $t2.linenum
          return {"linenum2": $t2.linenum,
                  "count2":$t2.count2}
};


-- PRE_CLUSTERED_GROUP_BY[$$19]  |PARTITIONED|
                          {
                            -- AGGREGATE  |LOCAL|
                              -- STREAM_SELECT  |LOCAL|
                                -- NESTED_TUPLE_SOURCE  |LOCAL|
                          }

will show incorrectly as:
                          {
                            -- AGGREGATE  |LOCAL|
                              -- STREAM_SELECT  |LOCAL|
                                -- NESTED_TUPLE_SOURCE  |LOCAL|
                          }
-- PRE_CLUSTERED_GROUP_BY[$$19]  |PARTITIONED|



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)