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

PREHOOK: query: drop table char_2_n1
PREHOOK: type: DROPTABLE
POSTHOOK: query: drop table char_2_n1
POSTHOOK: type: DROPTABLE
PREHOOK: query: create table char_2_n1 (
  key char(10),
  value char(20)
)
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@char_2_n1
POSTHOOK: query: create table char_2_n1 (
  key char(10),
  value char(20)
)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@char_2_n1
PREHOOK: query: insert overwrite table char_2_n1 select * from src
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@char_2_n1
POSTHOOK: query: insert overwrite table char_2_n1 select * from src
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@char_2_n1
POSTHOOK: Lineage: char_2_n1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ]
POSTHOOK: Lineage: char_2_n1.value EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ]
PREHOOK: query: select value, sum(cast(key as int)), count(*) numrows
from src
group by value
order by value asc
limit 5
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: select value, sum(cast(key as int)), count(*) numrows
from src
group by value
order by value asc
limit 5
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
val_0	0	3
val_10	10	1
val_100	200	2
val_103	206	2
val_104	208	2
PREHOOK: query: select value, sum(cast(key as int)), count(*) numrows
from char_2_n1
group by value
order by value asc
limit 5
PREHOOK: type: QUERY
PREHOOK: Input: default@char_2_n1
#### A masked pattern was here ####
POSTHOOK: query: select value, sum(cast(key as int)), count(*) numrows
from char_2_n1
group by value
order by value asc
limit 5
POSTHOOK: type: QUERY
POSTHOOK: Input: default@char_2_n1
#### A masked pattern was here ####
val_0               	0	3
val_10              	10	1
val_100             	200	2
val_103             	206	2
val_104             	208	2
PREHOOK: query: select value, sum(cast(key as int)), count(*) numrows
from src
group by value
order by value desc
limit 5
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
POSTHOOK: query: select value, sum(cast(key as int)), count(*) numrows
from src
group by value
order by value desc
limit 5
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
val_98	196	2
val_97	194	2
val_96	96	1
val_95	190	2
val_92	92	1
PREHOOK: query: select value, sum(cast(key as int)), count(*) numrows
from char_2_n1
group by value
order by value desc
limit 5
PREHOOK: type: QUERY
PREHOOK: Input: default@char_2_n1
#### A masked pattern was here ####
POSTHOOK: query: select value, sum(cast(key as int)), count(*) numrows
from char_2_n1
group by value
order by value desc
limit 5
POSTHOOK: type: QUERY
POSTHOOK: Input: default@char_2_n1
#### A masked pattern was here ####
val_98              	196	2
val_97              	194	2
val_96              	96	1
val_95              	190	2
val_92              	92	1
PREHOOK: query: drop table char_2_n1
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@char_2_n1
PREHOOK: Output: default@char_2_n1
POSTHOOK: query: drop table char_2_n1
POSTHOOK: type: DROPTABLE
POSTHOOK: Input: default@char_2_n1
POSTHOOK: Output: default@char_2_n1