Google Git
Sign in
apache / hive / 6b095edc31a9baa0ae805e2b5aea88101284d84b / . / ql / src / test / results / clientpositive / llap / parquet_ppd_char.q.out
blob: 0288daaa9810fe36fc68927af2e6ac10f002f8ee [file] [log] [blame]
PREHOOK: query: create table newtypestbl_n3(c char(10), v varchar(10), d decimal(5,3), da date) stored as parquet
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@newtypestbl_n3
POSTHOOK: query: create table newtypestbl_n3(c char(10), v varchar(10), d decimal(5,3), da date) stored as parquet
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@newtypestbl_n3
PREHOOK: query: insert overwrite table newtypestbl_n3 select * from (select cast("apple" as char(10)), cast("bee" as varchar(10)), 0.22, cast("1970-02-20" as date) from src src1 union all select cast("hello" as char(10)), cast("world" as varchar(10)), 11.22, cast("1970-02-27" as date) from src src2 limit 10) uniontbl
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@newtypestbl_n3
POSTHOOK: query: insert overwrite table newtypestbl_n3 select * from (select cast("apple" as char(10)), cast("bee" as varchar(10)), 0.22, cast("1970-02-20" as date) from src src1 union all select cast("hello" as char(10)), cast("world" as varchar(10)), 11.22, cast("1970-02-27" as date) from src src2 limit 10) uniontbl
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@newtypestbl_n3
POSTHOOK: Lineage: newtypestbl_n3.c EXPRESSION []
POSTHOOK: Lineage: newtypestbl_n3.d EXPRESSION []
POSTHOOK: Lineage: newtypestbl_n3.da EXPRESSION []
POSTHOOK: Lineage: newtypestbl_n3.v EXPRESSION []
PREHOOK: query: select * from newtypestbl_n3 where c="apple"
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl_n3
#### A masked pattern was here ####
POSTHOOK: query: select * from newtypestbl_n3 where c="apple"
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl_n3
#### A masked pattern was here ####
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl_n3 where c="apple"
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl_n3
#### A masked pattern was here ####
POSTHOOK: query: select * from newtypestbl_n3 where c="apple"
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl_n3
#### A masked pattern was here ####
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl_n3 where c!="apple"
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl_n3
#### A masked pattern was here ####
POSTHOOK: query: select * from newtypestbl_n3 where c!="apple"
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl_n3
#### A masked pattern was here ####
PREHOOK: query: select * from newtypestbl_n3 where c!="apple"
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl_n3
#### A masked pattern was here ####
POSTHOOK: query: select * from newtypestbl_n3 where c!="apple"
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl_n3
#### A masked pattern was here ####
PREHOOK: query: select * from newtypestbl_n3 where c<"hello"
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl_n3
#### A masked pattern was here ####
POSTHOOK: query: select * from newtypestbl_n3 where c<"hello"
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl_n3
#### A masked pattern was here ####
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl_n3 where c<"hello"
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl_n3
#### A masked pattern was here ####
POSTHOOK: query: select * from newtypestbl_n3 where c<"hello"
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl_n3
#### A masked pattern was here ####
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl_n3 where c<="hello" sort by c
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl_n3
#### A masked pattern was here ####
POSTHOOK: query: select * from newtypestbl_n3 where c<="hello" sort by c
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl_n3
#### A masked pattern was here ####
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl_n3 where c<="hello" sort by c
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl_n3
#### A masked pattern was here ####
POSTHOOK: query: select * from newtypestbl_n3 where c<="hello" sort by c
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl_n3
#### A masked pattern was here ####
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl_n3 where c="apple "
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl_n3
#### A masked pattern was here ####
POSTHOOK: query: select * from newtypestbl_n3 where c="apple "
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl_n3
#### A masked pattern was here ####
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl_n3 where c="apple "
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl_n3
#### A masked pattern was here ####
POSTHOOK: query: select * from newtypestbl_n3 where c="apple "
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl_n3
#### A masked pattern was here ####
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl_n3 where c in ("apple", "carrot")
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl_n3
#### A masked pattern was here ####
POSTHOOK: query: select * from newtypestbl_n3 where c in ("apple", "carrot")
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl_n3
#### A masked pattern was here ####
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl_n3 where c in ("apple", "carrot")
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl_n3
#### A masked pattern was here ####
POSTHOOK: query: select * from newtypestbl_n3 where c in ("apple", "carrot")
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl_n3
#### A masked pattern was here ####
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl_n3 where c in ("apple", "hello") sort by c
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl_n3
#### A masked pattern was here ####
POSTHOOK: query: select * from newtypestbl_n3 where c in ("apple", "hello") sort by c
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl_n3
#### A masked pattern was here ####
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl_n3 where c in ("apple", "hello") sort by c
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl_n3
#### A masked pattern was here ####
POSTHOOK: query: select * from newtypestbl_n3 where c in ("apple", "hello") sort by c
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl_n3
#### A masked pattern was here ####
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl_n3 where c in ("carrot")
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl_n3
#### A masked pattern was here ####
POSTHOOK: query: select * from newtypestbl_n3 where c in ("carrot")
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl_n3
#### A masked pattern was here ####
PREHOOK: query: select * from newtypestbl_n3 where c in ("carrot")
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl_n3
#### A masked pattern was here ####
POSTHOOK: query: select * from newtypestbl_n3 where c in ("carrot")
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl_n3
#### A masked pattern was here ####
PREHOOK: query: select * from newtypestbl_n3 where c between "apple" and "carrot"
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl_n3
#### A masked pattern was here ####
POSTHOOK: query: select * from newtypestbl_n3 where c between "apple" and "carrot"
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl_n3
#### A masked pattern was here ####
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl_n3 where c between "apple" and "carrot"
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl_n3
#### A masked pattern was here ####
POSTHOOK: query: select * from newtypestbl_n3 where c between "apple" and "carrot"
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl_n3
#### A masked pattern was here ####
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl_n3 where c between "apple" and "zombie" sort by c
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl_n3
#### A masked pattern was here ####
POSTHOOK: query: select * from newtypestbl_n3 where c between "apple" and "zombie" sort by c
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl_n3
#### A masked pattern was here ####
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl_n3 where c between "apple" and "zombie" sort by c
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl_n3
#### A masked pattern was here ####
POSTHOOK: query: select * from newtypestbl_n3 where c between "apple" and "zombie" sort by c
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl_n3
#### A masked pattern was here ####
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
apple bee 0.220 1970-02-20
PREHOOK: query: select * from newtypestbl_n3 where c between "carrot" and "carrot1"
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl_n3
#### A masked pattern was here ####
POSTHOOK: query: select * from newtypestbl_n3 where c between "carrot" and "carrot1"
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl_n3
#### A masked pattern was here ####
PREHOOK: query: select * from newtypestbl_n3 where c between "carrot" and "carrot1"
PREHOOK: type: QUERY
PREHOOK: Input: default@newtypestbl_n3
#### A masked pattern was here ####
POSTHOOK: query: select * from newtypestbl_n3 where c between "carrot" and "carrot1"
POSTHOOK: type: QUERY
POSTHOOK: Input: default@newtypestbl_n3
#### A masked pattern was here ####