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

PREHOOK: query: drop table emps_n1
PREHOOK: type: DROPTABLE
POSTHOOK: query: drop table emps_n1
POSTHOOK: type: DROPTABLE
PREHOOK: query: create table emps_n1 (empno int, deptno int, empname string)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@emps_n1
POSTHOOK: query: create table emps_n1 (empno int, deptno int, empname string)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@emps_n1
PREHOOK: query: insert into table emps_n1 values (1,2,"11"),(1,2,"11"),(3,4,"33"),(1,3,"11"),(2,5,"22"),(2,5,"22")
PREHOOK: type: QUERY
PREHOOK: Input: _dummy_database@_dummy_table
PREHOOK: Output: default@emps_n1
POSTHOOK: query: insert into table emps_n1 values (1,2,"11"),(1,2,"11"),(3,4,"33"),(1,3,"11"),(2,5,"22"),(2,5,"22")
POSTHOOK: type: QUERY
POSTHOOK: Input: _dummy_database@_dummy_table
POSTHOOK: Output: default@emps_n1
POSTHOOK: Lineage: emps_n1.deptno SCRIPT []
POSTHOOK: Lineage: emps_n1.empname SCRIPT []
POSTHOOK: Lineage: emps_n1.empno SCRIPT []
PREHOOK: query: select * from emps_n1
PREHOOK: type: QUERY
PREHOOK: Input: default@emps_n1
#### A masked pattern was here ####
POSTHOOK: query: select * from emps_n1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@emps_n1
#### A masked pattern was here ####
1	2	11
1	2	11
3	4	33
1	3	11
2	5	22
2	5	22
PREHOOK: query: select * from emps_n1 where (int(empno+deptno/2), int(deptno/3)) in ((2,0),(3,2))
PREHOOK: type: QUERY
PREHOOK: Input: default@emps_n1
#### A masked pattern was here ####
POSTHOOK: query: select * from emps_n1 where (int(empno+deptno/2), int(deptno/3)) in ((2,0),(3,2))
POSTHOOK: type: QUERY
POSTHOOK: Input: default@emps_n1
#### A masked pattern was here ####
1	2	11
1	2	11
PREHOOK: query: select * from emps_n1 where (int(empno+deptno/2), int(deptno/3)) not in ((2,0),(3,2))
PREHOOK: type: QUERY
PREHOOK: Input: default@emps_n1
#### A masked pattern was here ####
POSTHOOK: query: select * from emps_n1 where (int(empno+deptno/2), int(deptno/3)) not in ((2,0),(3,2))
POSTHOOK: type: QUERY
POSTHOOK: Input: default@emps_n1
#### A masked pattern was here ####
3	4	33
1	3	11
2	5	22
2	5	22
PREHOOK: query: select * from emps_n1 where (empno,deptno) in ((1,2),(3,2))
PREHOOK: type: QUERY
PREHOOK: Input: default@emps_n1
#### A masked pattern was here ####
POSTHOOK: query: select * from emps_n1 where (empno,deptno) in ((1,2),(3,2))
POSTHOOK: type: QUERY
POSTHOOK: Input: default@emps_n1
#### A masked pattern was here ####
1	2	11
1	2	11
PREHOOK: query: select * from emps_n1 where (empno,deptno) not in ((1,2),(3,2))
PREHOOK: type: QUERY
PREHOOK: Input: default@emps_n1
#### A masked pattern was here ####
POSTHOOK: query: select * from emps_n1 where (empno,deptno) not in ((1,2),(3,2))
POSTHOOK: type: QUERY
POSTHOOK: Input: default@emps_n1
#### A masked pattern was here ####
3	4	33
1	3	11
2	5	22
2	5	22
PREHOOK: query: select * from emps_n1 where (empno,deptno) in ((1,2),(1,3))
PREHOOK: type: QUERY
PREHOOK: Input: default@emps_n1
#### A masked pattern was here ####
POSTHOOK: query: select * from emps_n1 where (empno,deptno) in ((1,2),(1,3))
POSTHOOK: type: QUERY
POSTHOOK: Input: default@emps_n1
#### A masked pattern was here ####
1	2	11
1	2	11
1	3	11
PREHOOK: query: select * from emps_n1 where (empno,deptno) not in ((1,2),(1,3))
PREHOOK: type: QUERY
PREHOOK: Input: default@emps_n1
#### A masked pattern was here ####
POSTHOOK: query: select * from emps_n1 where (empno,deptno) not in ((1,2),(1,3))
POSTHOOK: type: QUERY
POSTHOOK: Input: default@emps_n1
#### A masked pattern was here ####
3	4	33
2	5	22
2	5	22
PREHOOK: query: explain
select * from emps_n1 where (empno+1,deptno) in ((1,2),(3,2))
PREHOOK: type: QUERY
PREHOOK: Input: default@emps_n1
#### A masked pattern was here ####
POSTHOOK: query: explain
select * from emps_n1 where (empno+1,deptno) in ((1,2),(3,2))
POSTHOOK: type: QUERY
POSTHOOK: Input: default@emps_n1
#### 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: emps_n1
          filterExpr: ((deptno = 2) and ((empno + 1)) IN (1, 3)) (type: boolean)
          Filter Operator
            predicate: ((deptno = 2) and ((empno + 1)) IN (1, 3)) (type: boolean)
            Select Operator
              expressions: empno (type: int), 2 (type: int), empname (type: string)
              outputColumnNames: _col0, _col1, _col2
              ListSink

PREHOOK: query: explain 
select * from emps_n1 where (empno+1,deptno) not in ((1,2),(3,2))
PREHOOK: type: QUERY
PREHOOK: Input: default@emps_n1
#### A masked pattern was here ####
POSTHOOK: query: explain 
select * from emps_n1 where (empno+1,deptno) not in ((1,2),(3,2))
POSTHOOK: type: QUERY
POSTHOOK: Input: default@emps_n1
#### 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: emps_n1
          filterExpr: ((((empno + 1) <> 1) or (deptno <> 2)) and (((empno + 1) <> 3) or (deptno <> 2))) (type: boolean)
          Filter Operator
            predicate: ((((empno + 1) <> 1) or (deptno <> 2)) and (((empno + 1) <> 3) or (deptno <> 2))) (type: boolean)
            Select Operator
              expressions: empno (type: int), deptno (type: int), empname (type: string)
              outputColumnNames: _col0, _col1, _col2
              ListSink

PREHOOK: query: select * from emps_n1 where empno in (1,2)
PREHOOK: type: QUERY
PREHOOK: Input: default@emps_n1
#### A masked pattern was here ####
POSTHOOK: query: select * from emps_n1 where empno in (1,2)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@emps_n1
#### A masked pattern was here ####
1	2	11
1	2	11
1	3	11
2	5	22
2	5	22
PREHOOK: query: select * from emps_n1 where empno in (1,2) and deptno > 2
PREHOOK: type: QUERY
PREHOOK: Input: default@emps_n1
#### A masked pattern was here ####
POSTHOOK: query: select * from emps_n1 where empno in (1,2) and deptno > 2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@emps_n1
#### A masked pattern was here ####
1	3	11
2	5	22
2	5	22
PREHOOK: query: select * from emps_n1 where (empno) in (1,2) and deptno > 2
PREHOOK: type: QUERY
PREHOOK: Input: default@emps_n1
#### A masked pattern was here ####
POSTHOOK: query: select * from emps_n1 where (empno) in (1,2) and deptno > 2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@emps_n1
#### A masked pattern was here ####
1	3	11
2	5	22
2	5	22
PREHOOK: query: select * from emps_n1 where ((empno) in (1,2) and deptno > 2)
PREHOOK: type: QUERY
PREHOOK: Input: default@emps_n1
#### A masked pattern was here ####
POSTHOOK: query: select * from emps_n1 where ((empno) in (1,2) and deptno > 2)
POSTHOOK: type: QUERY
POSTHOOK: Input: default@emps_n1
#### A masked pattern was here ####
1	3	11
2	5	22
2	5	22
PREHOOK: query: explain select * from emps_n1 where ((empno*2)|1,deptno) in ((empno+1,2),(empno+2,2))
PREHOOK: type: QUERY
PREHOOK: Input: default@emps_n1
#### A masked pattern was here ####
POSTHOOK: query: explain select * from emps_n1 where ((empno*2)|1,deptno) in ((empno+1,2),(empno+2,2))
POSTHOOK: type: QUERY
POSTHOOK: Input: default@emps_n1
#### 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: emps_n1
          filterExpr: ((deptno = 2) and ((((empno * 2) | 1) = (empno + 1)) or (((empno * 2) | 1) = (empno + 2)))) (type: boolean)
          Filter Operator
            predicate: ((deptno = 2) and ((((empno * 2) | 1) = (empno + 1)) or (((empno * 2) | 1) = (empno + 2)))) (type: boolean)
            Select Operator
              expressions: empno (type: int), 2 (type: int), empname (type: string)
              outputColumnNames: _col0, _col1, _col2
              ListSink

PREHOOK: query: select * from emps_n1 where ((empno*2)|1,deptno) in ((empno+1,2),(empno+2,2))
PREHOOK: type: QUERY
PREHOOK: Input: default@emps_n1
#### A masked pattern was here ####
POSTHOOK: query: select * from emps_n1 where ((empno*2)|1,deptno) in ((empno+1,2),(empno+2,2))
POSTHOOK: type: QUERY
POSTHOOK: Input: default@emps_n1
#### A masked pattern was here ####
1	2	11
1	2	11
PREHOOK: query: select (empno*2)|1,substr(empname,1,1) from emps_n1
PREHOOK: type: QUERY
PREHOOK: Input: default@emps_n1
#### A masked pattern was here ####
POSTHOOK: query: select (empno*2)|1,substr(empname,1,1) from emps_n1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@emps_n1
#### A masked pattern was here ####
3	1
3	1
7	3
3	1
5	2
5	2
PREHOOK: query: select * from emps_n1 where ((empno*2)|1,substr(empname,1,1)) in ((empno+1,'2'),(empno+2,'2'))
PREHOOK: type: QUERY
PREHOOK: Input: default@emps_n1
#### A masked pattern was here ####
POSTHOOK: query: select * from emps_n1 where ((empno*2)|1,substr(empname,1,1)) in ((empno+1,'2'),(empno+2,'2'))
POSTHOOK: type: QUERY
POSTHOOK: Input: default@emps_n1
#### A masked pattern was here ####
PREHOOK: query: select * from emps_n1 where ((empno*2)|1,substr(empname,1,1)) not in ((empno+1,'2'),(empno+2,'2'))
PREHOOK: type: QUERY
PREHOOK: Input: default@emps_n1
#### A masked pattern was here ####
POSTHOOK: query: select * from emps_n1 where ((empno*2)|1,substr(empname,1,1)) not in ((empno+1,'2'),(empno+2,'2'))
POSTHOOK: type: QUERY
POSTHOOK: Input: default@emps_n1
#### A masked pattern was here ####
1	2	11
1	2	11
3	4	33
1	3	11
2	5	22
2	5	22
PREHOOK: query: select * from emps_n1 where ((empno*2)|1,substr(empname,1,1)) in ((empno+1,'2'),(empno+3,'2'))
PREHOOK: type: QUERY
PREHOOK: Input: default@emps_n1
#### A masked pattern was here ####
POSTHOOK: query: select * from emps_n1 where ((empno*2)|1,substr(empname,1,1)) in ((empno+1,'2'),(empno+3,'2'))
POSTHOOK: type: QUERY
POSTHOOK: Input: default@emps_n1
#### A masked pattern was here ####
2	5	22
2	5	22
PREHOOK: query: select * from emps_n1 where ((empno*2)|1,substr(empname,1,1)) not in ((empno+1,'2'),(empno+3,'2'))
PREHOOK: type: QUERY
PREHOOK: Input: default@emps_n1
#### A masked pattern was here ####
POSTHOOK: query: select * from emps_n1 where ((empno*2)|1,substr(empname,1,1)) not in ((empno+1,'2'),(empno+3,'2'))
POSTHOOK: type: QUERY
POSTHOOK: Input: default@emps_n1
#### A masked pattern was here ####
1	2	11
1	2	11
3	4	33
1	3	11
PREHOOK: query: select sum(empno), empname from emps_n1 where ((empno*2)|1,substr(empname,1,1)) in ((empno+1,'2'),(empno+3,'2'))
group by empname
PREHOOK: type: QUERY
PREHOOK: Input: default@emps_n1
#### A masked pattern was here ####
POSTHOOK: query: select sum(empno), empname from emps_n1 where ((empno*2)|1,substr(empname,1,1)) in ((empno+1,'2'),(empno+3,'2'))
group by empname
POSTHOOK: type: QUERY
POSTHOOK: Input: default@emps_n1
#### A masked pattern was here ####
4	22
PREHOOK: query: select * from emps_n1 where ((empno*2)|1,substr(empname,1,1)) in ((empno+1,'2'),(empno+3,'2'))
union
select * from emps_n1 where (empno,deptno) in ((1,2),(3,2))
PREHOOK: type: QUERY
PREHOOK: Input: default@emps_n1
#### A masked pattern was here ####
POSTHOOK: query: select * from emps_n1 where ((empno*2)|1,substr(empname,1,1)) in ((empno+1,'2'),(empno+3,'2'))
union
select * from emps_n1 where (empno,deptno) in ((1,2),(3,2))
POSTHOOK: type: QUERY
POSTHOOK: Input: default@emps_n1
#### A masked pattern was here ####
1	2	11
2	5	22
PREHOOK: query: drop view v_n2
PREHOOK: type: DROPVIEW
POSTHOOK: query: drop view v_n2
POSTHOOK: type: DROPVIEW
PREHOOK: query: create view v_n2 as 
select * from(
select * from emps_n1 where ((empno*2)|1,substr(empname,1,1)) in ((empno+1,'2'),(empno+3,'2'))
union
select * from emps_n1 where (empno,deptno) in ((1,2),(3,2)))subq order by empno desc
PREHOOK: type: CREATEVIEW
PREHOOK: Input: default@emps_n1
PREHOOK: Output: database:default
PREHOOK: Output: default@v_n2
POSTHOOK: query: create view v_n2 as 
select * from(
select * from emps_n1 where ((empno*2)|1,substr(empname,1,1)) in ((empno+1,'2'),(empno+3,'2'))
union
select * from emps_n1 where (empno,deptno) in ((1,2),(3,2)))subq order by empno desc
POSTHOOK: type: CREATEVIEW
POSTHOOK: Input: default@emps_n1
POSTHOOK: Output: database:default
POSTHOOK: Output: default@v_n2
POSTHOOK: Lineage: v_n2.deptno EXPRESSION [(emps_n1)emps_n1.FieldSchema(name:deptno, type:int, comment:null), ]
POSTHOOK: Lineage: v_n2.empname EXPRESSION [(emps_n1)emps_n1.FieldSchema(name:empname, type:string, comment:null), ]
POSTHOOK: Lineage: v_n2.empno EXPRESSION [(emps_n1)emps_n1.FieldSchema(name:empno, type:int, comment:null), ]
PREHOOK: query: select * from v_n2
PREHOOK: type: QUERY
PREHOOK: Input: default@emps_n1
PREHOOK: Input: default@v_n2
#### A masked pattern was here ####
POSTHOOK: query: select * from v_n2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@emps_n1
POSTHOOK: Input: default@v_n2
#### A masked pattern was here ####
1	2	11
2	5	22
PREHOOK: query: select subq.e1 from 
(select (empno*2)|1 as e1, substr(empname,1,1) as n1 from emps_n1)subq
join
(select empno as e2 from emps_n1 where ((empno*2)|1,substr(empname,1,1)) in ((empno+1,'2'),(empno+3,'2')))subq2
on e1=e2+1
PREHOOK: type: QUERY
PREHOOK: Input: default@emps_n1
#### A masked pattern was here ####
POSTHOOK: query: select subq.e1 from 
(select (empno*2)|1 as e1, substr(empname,1,1) as n1 from emps_n1)subq
join
(select empno as e2 from emps_n1 where ((empno*2)|1,substr(empname,1,1)) in ((empno+1,'2'),(empno+3,'2')))subq2
on e1=e2+1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@emps_n1
#### A masked pattern was here ####
3
3
3
3
3
3