ql/src/test/results/clientpositive/llap/subquery_full_aggregate.q.out

PREHOOK: query: create table alltypestiny(
    smallint_col smallint,
    date_string_col varchar(100),
    string_col varchar(100),
    timestamp_col timestamp,
    bigint_col bigint)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@alltypestiny
POSTHOOK: query: create table alltypestiny(
    smallint_col smallint,
    date_string_col varchar(100),
    string_col varchar(100),
    timestamp_col timestamp,
    bigint_col bigint)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@alltypestiny
PREHOOK: query: insert into alltypestiny values (1, '2020-03-02', '2020-03-02', '2020-03-02 10:10:10', 1),
(2, '2020-02-02', '2020-02-02', '2020-03-02 10:15:10', 11),
(3, '2020-02-02', '2020-01-02', '2020-03-02 11:10:10', 12),
(null, '2020-03-02', '2020-03-02', '2020-03-02 10:10:10', 1),
(4, '2020-03-02', '2020-03-02', '2020-03-02 10:10:10', null)
PREHOOK: type: QUERY
PREHOOK: Input: _dummy_database@_dummy_table
PREHOOK: Output: default@alltypestiny
POSTHOOK: query: insert into alltypestiny values (1, '2020-03-02', '2020-03-02', '2020-03-02 10:10:10', 1),
(2, '2020-02-02', '2020-02-02', '2020-03-02 10:15:10', 11),
(3, '2020-02-02', '2020-01-02', '2020-03-02 11:10:10', 12),
(null, '2020-03-02', '2020-03-02', '2020-03-02 10:10:10', 1),
(4, '2020-03-02', '2020-03-02', '2020-03-02 10:10:10', null)
POSTHOOK: type: QUERY
POSTHOOK: Input: _dummy_database@_dummy_table
POSTHOOK: Output: default@alltypestiny
POSTHOOK: Lineage: alltypestiny.bigint_col SCRIPT []
POSTHOOK: Lineage: alltypestiny.date_string_col SCRIPT []
POSTHOOK: Lineage: alltypestiny.smallint_col SCRIPT []
POSTHOOK: Lineage: alltypestiny.string_col SCRIPT []
POSTHOOK: Lineage: alltypestiny.timestamp_col SCRIPT []
PREHOOK: query: explain cbo
SELECT t1.bigint_col
FROM alltypestiny t1
WHERE t1.bigint_col > 1 AND NOT EXISTS
  (SELECT SUM(smallint_col) AS int_col
   FROM alltypestiny
   WHERE t1.date_string_col = string_col AND t1.timestamp_col = timestamp_col)
GROUP BY t1.bigint_col
PREHOOK: type: QUERY
PREHOOK: Input: default@alltypestiny
#### A masked pattern was here ####
POSTHOOK: query: explain cbo
SELECT t1.bigint_col
FROM alltypestiny t1
WHERE t1.bigint_col > 1 AND NOT EXISTS
  (SELECT SUM(smallint_col) AS int_col
   FROM alltypestiny
   WHERE t1.date_string_col = string_col AND t1.timestamp_col = timestamp_col)
GROUP BY t1.bigint_col
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alltypestiny
#### A masked pattern was here ####
CBO PLAN:
HiveValues(tuples=[[]])

PREHOOK: query: SELECT t1.bigint_col
FROM alltypestiny t1
WHERE NOT EXISTS
  (SELECT SUM(smallint_col) AS int_col
   FROM alltypestiny
   WHERE t1.date_string_col = string_col AND t1.timestamp_col = timestamp_col)
GROUP BY t1.bigint_col
PREHOOK: type: QUERY
PREHOOK: Input: default@alltypestiny
#### A masked pattern was here ####
POSTHOOK: query: SELECT t1.bigint_col
FROM alltypestiny t1
WHERE NOT EXISTS
  (SELECT SUM(smallint_col) AS int_col
   FROM alltypestiny
   WHERE t1.date_string_col = string_col AND t1.timestamp_col = timestamp_col)
GROUP BY t1.bigint_col
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alltypestiny
#### A masked pattern was here ####
PREHOOK: query: explain cbo
SELECT t1.bigint_col
FROM alltypestiny t1
WHERE EXISTS
  (SELECT SUM(smallint_col) AS int_col
   FROM alltypestiny
   WHERE t1.date_string_col = string_col AND t1.timestamp_col = timestamp_col)
GROUP BY t1.bigint_col
PREHOOK: type: QUERY
PREHOOK: Input: default@alltypestiny
#### A masked pattern was here ####
POSTHOOK: query: explain cbo
SELECT t1.bigint_col
FROM alltypestiny t1
WHERE EXISTS
  (SELECT SUM(smallint_col) AS int_col
   FROM alltypestiny
   WHERE t1.date_string_col = string_col AND t1.timestamp_col = timestamp_col)
GROUP BY t1.bigint_col
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alltypestiny
#### A masked pattern was here ####
CBO PLAN:
HiveAggregate(group=[{4}])
  HiveTableScan(table=[[default, alltypestiny]], table:alias=[t1])

PREHOOK: query: SELECT t1.bigint_col
FROM alltypestiny t1
WHERE EXISTS
  (SELECT SUM(smallint_col) AS int_col
   FROM alltypestiny
   WHERE t1.date_string_col = string_col AND t1.timestamp_col = timestamp_col)
GROUP BY t1.bigint_col
PREHOOK: type: QUERY
PREHOOK: Input: default@alltypestiny
#### A masked pattern was here ####
POSTHOOK: query: SELECT t1.bigint_col
FROM alltypestiny t1
WHERE EXISTS
  (SELECT SUM(smallint_col) AS int_col
   FROM alltypestiny
   WHERE t1.date_string_col = string_col AND t1.timestamp_col = timestamp_col)
GROUP BY t1.bigint_col
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alltypestiny
#### A masked pattern was here ####
11
1
12
NULL