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

["Yingyi Bu (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/ASTERIXDB-1520?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Yingyi Bu resolved ASTERIXDB-1520.
----------------------------------
    Resolution: Fixed

The plan displayed on the Web UI has a different format from optimizer tests.  The plans used in optimizer tests only show physical operators.

> 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
>            Assignee: Yingyi Bu
>            Priority: Critical
>
> 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)