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

PREHOOK: query: create table tinyA(a bigint, b bigint) stored as textfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@tinyA
POSTHOOK: query: create table tinyA(a bigint, b bigint) stored as textfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@tinyA
PREHOOK: query: create table tinyB(a bigint, bList array<int>) stored as textfile
PREHOOK: type: CREATETABLE
PREHOOK: Output: database:default
PREHOOK: Output: default@tinyB
POSTHOOK: query: create table tinyB(a bigint, bList array<int>) stored as textfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: database:default
POSTHOOK: Output: default@tinyB
PREHOOK: query: load data local inpath '../../data/files/tiny_a.txt' into table tinyA
PREHOOK: type: LOAD
#### A masked pattern was here ####
PREHOOK: Output: default@tinya
POSTHOOK: query: load data local inpath '../../data/files/tiny_a.txt' into table tinyA
POSTHOOK: type: LOAD
#### A masked pattern was here ####
POSTHOOK: Output: default@tinya
PREHOOK: query: load data local inpath '../../data/files/tiny_b.txt' into table tinyB
PREHOOK: type: LOAD
#### A masked pattern was here ####
PREHOOK: Output: default@tinyb
POSTHOOK: query: load data local inpath '../../data/files/tiny_b.txt' into table tinyB
POSTHOOK: type: LOAD
#### A masked pattern was here ####
POSTHOOK: Output: default@tinyb
PREHOOK: query: select * from tinyA
PREHOOK: type: QUERY
PREHOOK: Input: default@tinya
#### A masked pattern was here ####
POSTHOOK: query: select * from tinyA
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tinya
#### A masked pattern was here ####
10320092026892491	3312
PREHOOK: query: select * from tinyB
PREHOOK: type: QUERY
PREHOOK: Input: default@tinyb
#### A masked pattern was here ####
POSTHOOK: query: select * from tinyB
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tinyb
#### A masked pattern was here ####
10320092002467760	[0,23,37,48,53,55,55,56,60,66,72,76,77,78,80,81,87,88,90,90,91,90,92,97,100,103,104,107,108,108,109,110,113,113,113,113,113,113,114,116,116,116,117,116,117,117,117,115,115,117,117,117,121,120,131,131,131,125,125,124,124,128,128,131,131,132,133,134,134,134,134,26,26,null,null,null,null,116]
10320092026892491	[0,2,59,106,131,142,159,244,320,398,417,433,553,616,710,826,917,971,1046,1051,1093,1112,1142,1215,1220,1226,1232,1267,1364,1549,1646,1948,2170,2272,2325,2433,2534,2852,2925,2992,3119,3207,3279,3323,3412,3637,3645,3634,3450,3473,3638,3688,3736,3758,3812,3862,3873,3868,3883,4118,4134,4127,4170,4216,null,null,null,null,3139]
PREHOOK: query: select tinyB.a, tinyB.bList from tinyB full outer join tinyA on tinyB.a = tinyA.a
PREHOOK: type: QUERY
PREHOOK: Input: default@tinya
PREHOOK: Input: default@tinyb
#### A masked pattern was here ####
POSTHOOK: query: select tinyB.a, tinyB.bList from tinyB full outer join tinyA on tinyB.a = tinyA.a
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tinya
POSTHOOK: Input: default@tinyb
#### A masked pattern was here ####
10320092002467760	[0,23,37,48,53,55,55,56,60,66,72,76,77,78,80,81,87,88,90,90,91,90,92,97,100,103,104,107,108,108,109,110,113,113,113,113,113,113,114,116,116,116,117,116,117,117,117,115,115,117,117,117,121,120,131,131,131,125,125,124,124,128,128,131,131,132,133,134,134,134,134,26,26,null,null,null,null,116]
10320092026892491	[0,2,59,106,131,142,159,244,320,398,417,433,553,616,710,826,917,971,1046,1051,1093,1112,1142,1215,1220,1226,1232,1267,1364,1549,1646,1948,2170,2272,2325,2433,2534,2852,2925,2992,3119,3207,3279,3323,3412,3637,3645,3634,3450,3473,3638,3688,3736,3758,3812,3862,3873,3868,3883,4118,4134,4127,4170,4216,null,null,null,null,3139]