Uploaded image for project: 'Apache AsterixDB'
  1. Apache AsterixDB
  2. ASTERIXDB-1520

Preclustered Group by is displayed incorrectly in the web UI

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: UI - Web Interface
    • Labels:
      None

      Description

      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|

        Attachments

          Activity

            People

            • Assignee:
              buyingyi Yingyi Bu
              Reporter:
              amoudi Abdullah Alamoudi
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: