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

PREHOOK: query: create table emps_mv_rewrite_empty (
  empid int,
  deptno int,
  name varchar(256),
  salary float,
  commission int)
stored as orc TBLPROPERTIES ('transactional'='true')
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@emps_mv_rewrite_empty
POSTHOOK: query: create table emps_mv_rewrite_empty (
  empid int,
  deptno int,
  name varchar(256),
  salary float,
  commission int)
stored as orc TBLPROPERTIES ('transactional'='true')
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@emps_mv_rewrite_empty
PREHOOK: query: create materialized view emps_mv_rewrite_empty_mv1 as
select * from emps_mv_rewrite_empty where empid < 150
PREHOOK: type: CREATE_MATERIALIZED_VIEW
PREHOOK: Input: default@emps_mv_rewrite_empty
PREHOOK: Output: database:default
PREHOOK: Output: default@emps_mv_rewrite_empty_mv1
POSTHOOK: query: create materialized view emps_mv_rewrite_empty_mv1 as
select * from emps_mv_rewrite_empty where empid < 150
POSTHOOK: type: CREATE_MATERIALIZED_VIEW
POSTHOOK: Input: default@emps_mv_rewrite_empty
POSTHOOK: Output: database:default
POSTHOOK: Output: default@emps_mv_rewrite_empty_mv1
PREHOOK: query: explain
select * from emps_mv_rewrite_empty where empid < 120
PREHOOK: type: QUERY
PREHOOK: Input: default@emps_mv_rewrite_empty
PREHOOK: Input: default@emps_mv_rewrite_empty_mv1
#### A masked pattern was here ####
POSTHOOK: query: explain
select * from emps_mv_rewrite_empty where empid < 120
POSTHOOK: type: QUERY
POSTHOOK: Input: default@emps_mv_rewrite_empty
POSTHOOK: Input: default@emps_mv_rewrite_empty_mv1
#### A masked pattern was here ####
STAGE DEPENDENCIES:
  Stage-0 is a root stage

STAGE PLANS:
  Stage: Stage-0
    Fetch Operator
      limit: -1
      Processor Tree:
        TableScan
          alias: default.emps_mv_rewrite_empty_mv1
          filterExpr: (empid < 120) (type: boolean)
          Filter Operator
            predicate: (empid < 120) (type: boolean)
            Select Operator
              expressions: empid (type: int), deptno (type: int), name (type: varchar(256)), salary (type: float), commission (type: int)
              outputColumnNames: _col0, _col1, _col2, _col3, _col4
              ListSink

PREHOOK: query: select * from emps_mv_rewrite_empty where empid < 120
PREHOOK: type: QUERY
PREHOOK: Input: default@emps_mv_rewrite_empty
PREHOOK: Input: default@emps_mv_rewrite_empty_mv1
#### A masked pattern was here ####
POSTHOOK: query: select * from emps_mv_rewrite_empty where empid < 120
POSTHOOK: type: QUERY
POSTHOOK: Input: default@emps_mv_rewrite_empty
POSTHOOK: Input: default@emps_mv_rewrite_empty_mv1
#### A masked pattern was here ####
PREHOOK: query: drop materialized view emps_mv_rewrite_empty_mv1
PREHOOK: type: DROP_MATERIALIZED_VIEW
PREHOOK: Input: default@emps_mv_rewrite_empty_mv1
PREHOOK: Output: default@emps_mv_rewrite_empty_mv1
POSTHOOK: query: drop materialized view emps_mv_rewrite_empty_mv1
POSTHOOK: type: DROP_MATERIALIZED_VIEW
POSTHOOK: Input: default@emps_mv_rewrite_empty_mv1
POSTHOOK: Output: default@emps_mv_rewrite_empty_mv1
PREHOOK: query: drop table emps_mv_rewrite_empty
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@emps_mv_rewrite_empty
PREHOOK: Output: default@emps_mv_rewrite_empty
POSTHOOK: query: drop table emps_mv_rewrite_empty
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@emps_mv_rewrite_empty
POSTHOOK: Output: default@emps_mv_rewrite_empty