PREHOOK: query: drop table invites
PREHOOK: type: DROPTABLE
POSTHOOK: query: drop table invites
POSTHOOK: type: DROPTABLE
PREHOOK: query: drop table invites2
PREHOOK: type: DROPTABLE
POSTHOOK: query: drop table invites2
POSTHOOK: type: DROPTABLE
PREHOOK: query: create table invites (foo int, bar string) partitioned by (ds string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@invites
POSTHOOK: query: create table invites (foo int, bar string) partitioned by (ds string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@invites
PREHOOK: query: create table invites2 (foo int, bar string) partitioned by (ds string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@invites2
POSTHOOK: query: create table invites2 (foo int, bar string) partitioned by (ds string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@invites2
PREHOOK: query: -- test join views: see HIVE-1989

create view v as select invites.bar, invites2.foo, invites2.ds from invites join invites2 on invites.ds=invites2.ds
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@invites
PREHOOK: Input: default@invites2
PREHOOK: Output: database:default
PREHOOK: Output: default@v
POSTHOOK: query: -- test join views: see HIVE-1989

create view v as select invites.bar, invites2.foo, invites2.ds from invites join invites2 on invites.ds=invites2.ds
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@invites
POSTHOOK: Input: default@invites2
POSTHOOK: Output: database:default
POSTHOOK: Output: default@v
PREHOOK: query: explain select * from v where ds='2011-09-01'
PREHOOK: type: QUERY
POSTHOOK: query: explain select * from v where ds='2011-09-01'
POSTHOOK: type: QUERY
STAGE DEPENDENCIES:
  Stage-1 is a root stage
  Stage-0 depends on stages: Stage-1

STAGE PLANS:
  Stage: Stage-1
    Map Reduce
      Map Operator Tree:
          TableScan
            alias: invites
            Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
            Filter Operator
              predicate: (ds = '2011-09-01') (type: boolean)
              Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
              Reduce Output Operator
                key expressions: '2011-09-01' (type: string)
                sort order: +
                Map-reduce partition columns: '2011-09-01' (type: string)
                Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                value expressions: bar (type: string)
          TableScan
            alias: invites2
            Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
            Filter Operator
              predicate: (ds = '2011-09-01') (type: boolean)
              Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
              Reduce Output Operator
                key expressions: '2011-09-01' (type: string)
                sort order: +
                Map-reduce partition columns: '2011-09-01' (type: string)
                Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
                value expressions: foo (type: int)
      Reduce Operator Tree:
        Join Operator
          condition map:
               Inner Join 0 to 1
          keys:
            0 ds (type: string)
            1 ds (type: string)
          outputColumnNames: _col1, _col6
          Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
          Select Operator
            expressions: _col1 (type: string), _col6 (type: int), '2011-09-01' (type: string)
            outputColumnNames: _col0, _col1, _col2
            Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
            File Output Operator
              compressed: false
              Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE
              table:
                  input format: org.apache.hadoop.mapred.TextInputFormat
                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                  serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe

  Stage: Stage-0
    Fetch Operator
      limit: -1
      Processor Tree:
        ListSink

PREHOOK: query: drop view v
PREHOOK: type: DROPVIEW
PREHOOK: Input: default@v
PREHOOK: Output: default@v
POSTHOOK: query: drop view v
POSTHOOK: type: DROPVIEW
POSTHOOK: Input: default@v
POSTHOOK: Output: default@v
PREHOOK: query: drop table invites
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@invites
PREHOOK: Output: default@invites
POSTHOOK: query: drop table invites
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@invites
POSTHOOK: Output: default@invites
PREHOOK: query: drop table invites2
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@invites2
PREHOOK: Output: default@invites2
POSTHOOK: query: drop table invites2
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@invites2
POSTHOOK: Output: default@invites2