asterixdb/asterix-app/src/test/resources/optimizerts/results_parser_sqlpp/distinct_aggregate.ast

DataverseUse tpch
TypeDecl LineItemType [
  closed RecordType {
    l_orderkey : integer,
    l_partkey : integer,
    l_suppkey : integer,
    l_linenumber : integer,
    l_quantity : double,
    l_extendedprice : double,
    l_discount : double,
    l_tax : double,
    l_returnflag : string,
    l_linestatus : string,
    l_shipdate : string,
    l_commitdate : string,
    l_receiptdate : string,
    l_shipinstruct : string,
    l_shipmode : string,
    l_comment : string
  }
]
DatasetDecl LineItems_q1(LineItemType) partitioned by [[l_orderkey], [l_linenumber]]
WriteOutputTo asterix_nc1:rttest/tpch_q1_pricing_summary_report_nt.adm
Query:
SELECT ELEMENT [
RecordConstructor [
  (
    LiteralExpr [STRING] [l_returnflag]
    :
    Variable [ Name=$l_returnflag ]
  )
  (
    LiteralExpr [STRING] [l_linestatus]
    :
    Variable [ Name=$l_linestatus ]
  )
  (
    LiteralExpr [STRING] [count_suppkey]
    :
    FunctionCall tpch.sql-count@1[
      (
        SELECT ELEMENT [
        FieldAccessor [
          Variable [ Name=#3 ]
          Field=g
        ]
        ]
        FROM [          Variable [ Name=#2 ]
          AS Variable [ Name=#3 ]
        ]
      )
    ]
  )
]
]
FROM [  (
    SELECT ELEMENT [
    RecordConstructor [
      (
        LiteralExpr [STRING] [l_returnflag]
        :
        Variable [ Name=$l_returnflag ]
      )
      (
        LiteralExpr [STRING] [l_linestatus]
        :
        Variable [ Name=$l_linestatus ]
      )
      (
        LiteralExpr [STRING] [l_suppkey]
        :
        Variable [ Name=$l_suppkey ]
      )
    ]
    ]
    FROM [      FunctionCall Metadata.dataset@1[
        LiteralExpr [STRING] [LineItems_q1]
      ]
      AS Variable [ Name=$l ]
    ]
    Where
      OperatorExpr [
        FieldAccessor [
          Variable [ Name=$l ]
          Field=l_shipdate
        ]
        <=
        LiteralExpr [STRING] [1998-09-02]
      ]
    Groupby
      Variable [ Name=$l_returnflag ]
      :=
      FieldAccessor [
        Variable [ Name=$l ]
        Field=l_returnflag
      ]
      Variable [ Name=$l_linestatus ]
      :=
      FieldAccessor [
        Variable [ Name=$l ]
        Field=l_linestatus
      ]
      Variable [ Name=$l_suppkey ]
      :=
      FieldAccessor [
        Variable [ Name=$l ]
        Field=l_suppkey
      ]
      GROUP AS Variable [ Name=#1 ]
      (
        l:=Variable [ Name=$l ]
      )

  )
  AS Variable [ Name=$g ]
]
Groupby
  Variable [ Name=$l_returnflag ]
  :=
  FieldAccessor [
    Variable [ Name=$g ]
    Field=l_returnflag
  ]
  Variable [ Name=$l_linestatus ]
  :=
  FieldAccessor [
    Variable [ Name=$g ]
    Field=l_linestatus
  ]
  GROUP AS Variable [ Name=#2 ]
  (
    g:=Variable [ Name=$g ]
  )

Orderby
  Variable [ Name=$l_returnflag ]
  ASC
  Variable [ Name=$l_linestatus ]
  ASC