ql/src/test/results/clientpositive/order_by_expr_2.q.out

PREHOOK: query: create table t_n14(a int, b int)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@t_n14
POSTHOOK: query: create table t_n14(a int, b int)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@t_n14
PREHOOK: query: insert into t_n14 values (1,2),(1,2),(1,3),(2,4),(20,-100),(-1000,100),(4,5),(3,7),(8,9)
PREHOOK: type: QUERY
PREHOOK: Input: _dummy_database@_dummy_table
PREHOOK: Output: default@t_n14
POSTHOOK: query: insert into t_n14 values (1,2),(1,2),(1,3),(2,4),(20,-100),(-1000,100),(4,5),(3,7),(8,9)
POSTHOOK: type: QUERY
POSTHOOK: Input: _dummy_database@_dummy_table
POSTHOOK: Output: default@t_n14
POSTHOOK: Lineage: t_n14.a SCRIPT []
POSTHOOK: Lineage: t_n14.b SCRIPT []
PREHOOK: query: select a as b, b as a from t_n14 order by a
PREHOOK: type: QUERY
PREHOOK: Input: default@t_n14
#### A masked pattern was here ####
POSTHOOK: query: select a as b, b as a from t_n14 order by a
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t_n14
#### A masked pattern was here ####
20	-100
1	2
1	2
1	3
2	4
4	5
3	7
8	9
-1000	100
PREHOOK: query: select a as b, b as a from t_n14 order by t_n14.a
PREHOOK: type: QUERY
PREHOOK: Input: default@t_n14
#### A masked pattern was here ####
POSTHOOK: query: select a as b, b as a from t_n14 order by t_n14.a
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t_n14
#### A masked pattern was here ####
-1000	100
1	3
1	2
1	2
2	4
3	7
4	5
8	9
20	-100
PREHOOK: query: select a as b from t_n14 order by b
PREHOOK: type: QUERY
PREHOOK: Input: default@t_n14
#### A masked pattern was here ####
POSTHOOK: query: select a as b from t_n14 order by b
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t_n14
#### A masked pattern was here ####
-1000
1
1
1
2
3
4
8
20
PREHOOK: query: select a as b from t_n14 order by 0-a
PREHOOK: type: QUERY
PREHOOK: Input: default@t_n14
#### A masked pattern was here ####
POSTHOOK: query: select a as b from t_n14 order by 0-a
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t_n14
#### A masked pattern was here ####
20
8
4
3
2
1
1
1
-1000
PREHOOK: query: select a,b,count(*),a+b from t_n14 group by a, b order by a+b
PREHOOK: type: QUERY
PREHOOK: Input: default@t_n14
#### A masked pattern was here ####
POSTHOOK: query: select a,b,count(*),a+b from t_n14 group by a, b order by a+b
POSTHOOK: type: QUERY
POSTHOOK: Input: default@t_n14
#### A masked pattern was here ####
-1000	100	1	-900
20	-100	1	-80
1	2	2	3
1	3	1	4
2	4	1	6
4	5	1	9
3	7	1	10
8	9	1	17