http://git-wip-us.apache.org/repos/asf/hive/blob/22541610/ql/src/test/results/clientpositive/char_udf1.q.java1.8.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/char_udf1.q.java1.8.out b/ql/src/test/results/clientpositive/char_udf1.q.java1.8.out deleted file mode 100644 index 5691a06..0000000 --- a/ql/src/test/results/clientpositive/char_udf1.q.java1.8.out +++ /dev/null @@ -1,457 +0,0 @@ -PREHOOK: query: drop table char_udf_1 -PREHOOK: type: DROPTABLE -POSTHOOK: query: drop table char_udf_1 -POSTHOOK: type: DROPTABLE -PREHOOK: query: create table char_udf_1 (c1 string, c2 string, c3 char(10), c4 char(20)) -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@char_udf_1 -POSTHOOK: query: create table char_udf_1 (c1 string, c2 string, c3 char(10), c4 char(20)) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@char_udf_1 -PREHOOK: query: insert overwrite table char_udf_1 - select key, value, key, value from src where key = '238' limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@src -PREHOOK: Output: default@char_udf_1 -POSTHOOK: query: insert overwrite table char_udf_1 - select key, value, key, value from src where key = '238' limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -POSTHOOK: Output: default@char_udf_1 -POSTHOOK: Lineage: char_udf_1.c1 SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: char_udf_1.c2 SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -POSTHOOK: Lineage: char_udf_1.c3 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: char_udf_1.c4 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: -- JAVA_VERSION_SPECIFIC_OUTPUT - --- UDFs with char support -select - concat(c1, c2), - concat(c3, c4), - concat(c1, c2) = concat(c3, c4) -from char_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: -- JAVA_VERSION_SPECIFIC_OUTPUT - --- UDFs with char support -select - concat(c1, c2), - concat(c3, c4), - concat(c1, c2) = concat(c3, c4) -from char_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -238val_238 238val_238 true -PREHOOK: query: select - upper(c2), - upper(c4), - upper(c2) = upper(c4) -from char_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - upper(c2), - upper(c4), - upper(c2) = upper(c4) -from char_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -VAL_238 VAL_238 true -PREHOOK: query: select - lower(c2), - lower(c4), - lower(c2) = lower(c4) -from char_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - lower(c2), - lower(c4), - lower(c2) = lower(c4) -from char_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -val_238 val_238 true -PREHOOK: query: -- Scalar UDFs -select - ascii(c2), - ascii(c4), - ascii(c2) = ascii(c4) -from char_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: -- Scalar UDFs -select - ascii(c2), - ascii(c4), - ascii(c2) = ascii(c4) -from char_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -118 118 true -PREHOOK: query: select - concat_ws('|', c1, c2), - concat_ws('|', c3, c4), - concat_ws('|', c1, c2) = concat_ws('|', c3, c4) -from char_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - concat_ws('|', c1, c2), - concat_ws('|', c3, c4), - concat_ws('|', c1, c2) = concat_ws('|', c3, c4) -from char_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -238|val_238 238|val_238 true -PREHOOK: query: select - decode(encode(c2, 'US-ASCII'), 'US-ASCII'), - decode(encode(c4, 'US-ASCII'), 'US-ASCII'), - decode(encode(c2, 'US-ASCII'), 'US-ASCII') = decode(encode(c4, 'US-ASCII'), 'US-ASCII') -from char_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - decode(encode(c2, 'US-ASCII'), 'US-ASCII'), - decode(encode(c4, 'US-ASCII'), 'US-ASCII'), - decode(encode(c2, 'US-ASCII'), 'US-ASCII') = decode(encode(c4, 'US-ASCII'), 'US-ASCII') -from char_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -val_238 val_238 true -PREHOOK: query: select - instr(c2, '_'), - instr(c4, '_'), - instr(c2, '_') = instr(c4, '_') -from char_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - instr(c2, '_'), - instr(c4, '_'), - instr(c2, '_') = instr(c4, '_') -from char_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -4 4 true -PREHOOK: query: select - length(c2), - length(c4), - length(c2) = length(c4) -from char_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - length(c2), - length(c4), - length(c2) = length(c4) -from char_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -7 7 true -PREHOOK: query: select - locate('a', 'abcdabcd', 3), - locate(cast('a' as char(1)), cast('abcdabcd' as char(10)), 3), - locate('a', 'abcdabcd', 3) = locate(cast('a' as char(1)), cast('abcdabcd' as char(10)), 3) -from char_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - locate('a', 'abcdabcd', 3), - locate(cast('a' as char(1)), cast('abcdabcd' as char(10)), 3), - locate('a', 'abcdabcd', 3) = locate(cast('a' as char(1)), cast('abcdabcd' as char(10)), 3) -from char_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -5 5 true -PREHOOK: query: select - lpad(c2, 15, ' '), - lpad(c4, 15, ' '), - lpad(c2, 15, ' ') = lpad(c4, 15, ' ') -from char_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - lpad(c2, 15, ' '), - lpad(c4, 15, ' '), - lpad(c2, 15, ' ') = lpad(c4, 15, ' ') -from char_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### - val_238 val_238 true -PREHOOK: query: select - ltrim(c2), - ltrim(c4), - ltrim(c2) = ltrim(c4) -from char_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - ltrim(c2), - ltrim(c4), - ltrim(c2) = ltrim(c4) -from char_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -val_238 val_238 true -PREHOOK: query: select - regexp(c2, 'val'), - regexp(c4, 'val'), - regexp(c2, 'val') = regexp(c4, 'val') -from char_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - regexp(c2, 'val'), - regexp(c4, 'val'), - regexp(c2, 'val') = regexp(c4, 'val') -from char_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -true true true -PREHOOK: query: select - regexp_extract(c2, 'val_([0-9]+)', 1), - regexp_extract(c4, 'val_([0-9]+)', 1), - regexp_extract(c2, 'val_([0-9]+)', 1) = regexp_extract(c4, 'val_([0-9]+)', 1) -from char_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - regexp_extract(c2, 'val_([0-9]+)', 1), - regexp_extract(c4, 'val_([0-9]+)', 1), - regexp_extract(c2, 'val_([0-9]+)', 1) = regexp_extract(c4, 'val_([0-9]+)', 1) -from char_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -238 238 true -PREHOOK: query: select - regexp_replace(c2, 'val', 'replaced'), - regexp_replace(c4, 'val', 'replaced'), - regexp_replace(c2, 'val', 'replaced') = regexp_replace(c4, 'val', 'replaced') -from char_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - regexp_replace(c2, 'val', 'replaced'), - regexp_replace(c4, 'val', 'replaced'), - regexp_replace(c2, 'val', 'replaced') = regexp_replace(c4, 'val', 'replaced') -from char_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -replaced_238 replaced_238 true -PREHOOK: query: select - reverse(c2), - reverse(c4), - reverse(c2) = reverse(c4) -from char_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - reverse(c2), - reverse(c4), - reverse(c2) = reverse(c4) -from char_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -832_lav 832_lav true -PREHOOK: query: select - rpad(c2, 15, ' '), - rpad(c4, 15, ' '), - rpad(c2, 15, ' ') = rpad(c4, 15, ' ') -from char_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - rpad(c2, 15, ' '), - rpad(c4, 15, ' '), - rpad(c2, 15, ' ') = rpad(c4, 15, ' ') -from char_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -val_238 val_238 true -PREHOOK: query: select - rtrim(c2), - rtrim(c4), - rtrim(c2) = rtrim(c4) -from char_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - rtrim(c2), - rtrim(c4), - rtrim(c2) = rtrim(c4) -from char_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -val_238 val_238 true -PREHOOK: query: select - sentences('See spot run. See jane run.'), - sentences(cast('See spot run. See jane run.' as char(50))) -from char_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - sentences('See spot run. See jane run.'), - sentences(cast('See spot run. See jane run.' as char(50))) -from char_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -[["See","spot","run"],["See","jane","run"]] [["See","spot","run"],["See","jane","run"]] -PREHOOK: query: select - split(c2, '_'), - split(c4, '_') -from char_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - split(c2, '_'), - split(c4, '_') -from char_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -["val","238"] ["val","238"] -PREHOOK: query: select - str_to_map('a:1,b:2,c:3',',',':'), - str_to_map(cast('a:1,b:2,c:3' as char(20)),',',':') -from char_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - str_to_map('a:1,b:2,c:3',',',':'), - str_to_map(cast('a:1,b:2,c:3' as char(20)),',',':') -from char_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -{"a":"1","b":"2","c":"3"} {"a":"1","b":"2","c":"3"} -PREHOOK: query: select - substr(c2, 1, 3), - substr(c4, 1, 3), - substr(c2, 1, 3) = substr(c4, 1, 3) -from char_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - substr(c2, 1, 3), - substr(c4, 1, 3), - substr(c2, 1, 3) = substr(c4, 1, 3) -from char_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -val val true -PREHOOK: query: select - trim(c2), - trim(c4), - trim(c2) = trim(c4) -from char_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - trim(c2), - trim(c4), - trim(c2) = trim(c4) -from char_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -val_238 val_238 true -PREHOOK: query: -- Aggregate Functions -select - compute_stats(c2, 16), - compute_stats(c4, 16) -from char_udf_1 -PREHOOK: type: QUERY -PREHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: -- Aggregate Functions -select - compute_stats(c2, 16), - compute_stats(c4, 16) -from char_udf_1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -{"columntype":"String","maxlength":7,"avglength":7.0,"countnulls":0,"numdistinctvalues":1} {"columntype":"String","maxlength":7,"avglength":7.0,"countnulls":0,"numdistinctvalues":1} -PREHOOK: query: select - min(c2), - min(c4) -from char_udf_1 -PREHOOK: type: QUERY -PREHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - min(c2), - min(c4) -from char_udf_1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -val_238 val_238 -PREHOOK: query: select - max(c2), - max(c4) -from char_udf_1 -PREHOOK: type: QUERY -PREHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - max(c2), - max(c4) -from char_udf_1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@char_udf_1 -#### A masked pattern was here #### -val_238 val_238 -PREHOOK: query: drop table char_udf_1 -PREHOOK: type: DROPTABLE -PREHOOK: Input: default@char_udf_1 -PREHOOK: Output: default@char_udf_1 -POSTHOOK: query: drop table char_udf_1 -POSTHOOK: type: DROPTABLE -POSTHOOK: Input: default@char_udf_1 -POSTHOOK: Output: default@char_udf_1
http://git-wip-us.apache.org/repos/asf/hive/blob/22541610/ql/src/test/results/clientpositive/char_udf1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/char_udf1.q.out b/ql/src/test/results/clientpositive/char_udf1.q.out new file mode 100644 index 0000000..d84237a --- /dev/null +++ b/ql/src/test/results/clientpositive/char_udf1.q.out @@ -0,0 +1,459 @@ +PREHOOK: query: drop table char_udf_1 +PREHOOK: type: DROPTABLE +POSTHOOK: query: drop table char_udf_1 +POSTHOOK: type: DROPTABLE +PREHOOK: query: create table char_udf_1 (c1 string, c2 string, c3 char(10), c4 char(20)) +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@char_udf_1 +POSTHOOK: query: create table char_udf_1 (c1 string, c2 string, c3 char(10), c4 char(20)) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@char_udf_1 +PREHOOK: query: insert overwrite table char_udf_1 + select key, value, key, value from src where key = '238' limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@char_udf_1 +POSTHOOK: query: insert overwrite table char_udf_1 + select key, value, key, value from src where key = '238' limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@char_udf_1 +POSTHOOK: Lineage: char_udf_1.c1 SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: char_udf_1.c2 SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: char_udf_1.c3 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: char_udf_1.c4 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ] +PREHOOK: query: -- UDFs with char support +select + concat(c1, c2), + concat(c3, c4), + concat(c1, c2) = concat(c3, c4) +from char_udf_1 limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +POSTHOOK: query: -- UDFs with char support +select + concat(c1, c2), + concat(c3, c4), + concat(c1, c2) = concat(c3, c4) +from char_udf_1 limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +238val_238 238val_238 true +PREHOOK: query: select + upper(c2), + upper(c4), + upper(c2) = upper(c4) +from char_udf_1 limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +POSTHOOK: query: select + upper(c2), + upper(c4), + upper(c2) = upper(c4) +from char_udf_1 limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +VAL_238 VAL_238 true +PREHOOK: query: select + lower(c2), + lower(c4), + lower(c2) = lower(c4) +from char_udf_1 limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +POSTHOOK: query: select + lower(c2), + lower(c4), + lower(c2) = lower(c4) +from char_udf_1 limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +val_238 val_238 true +PREHOOK: query: -- Scalar UDFs +select + ascii(c2), + ascii(c4), + ascii(c2) = ascii(c4) +from char_udf_1 limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +POSTHOOK: query: -- Scalar UDFs +select + ascii(c2), + ascii(c4), + ascii(c2) = ascii(c4) +from char_udf_1 limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +118 118 true +PREHOOK: query: select + concat_ws('|', c1, c2), + concat_ws('|', c3, c4), + concat_ws('|', c1, c2) = concat_ws('|', c3, c4) +from char_udf_1 limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +POSTHOOK: query: select + concat_ws('|', c1, c2), + concat_ws('|', c3, c4), + concat_ws('|', c1, c2) = concat_ws('|', c3, c4) +from char_udf_1 limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +238|val_238 238|val_238 true +PREHOOK: query: select + decode(encode(c2, 'US-ASCII'), 'US-ASCII'), + decode(encode(c4, 'US-ASCII'), 'US-ASCII'), + decode(encode(c2, 'US-ASCII'), 'US-ASCII') = decode(encode(c4, 'US-ASCII'), 'US-ASCII') +from char_udf_1 limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +POSTHOOK: query: select + decode(encode(c2, 'US-ASCII'), 'US-ASCII'), + decode(encode(c4, 'US-ASCII'), 'US-ASCII'), + decode(encode(c2, 'US-ASCII'), 'US-ASCII') = decode(encode(c4, 'US-ASCII'), 'US-ASCII') +from char_udf_1 limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +val_238 val_238 true +PREHOOK: query: select + instr(c2, '_'), + instr(c4, '_'), + instr(c2, '_') = instr(c4, '_') +from char_udf_1 limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +POSTHOOK: query: select + instr(c2, '_'), + instr(c4, '_'), + instr(c2, '_') = instr(c4, '_') +from char_udf_1 limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +4 4 true +PREHOOK: query: select + length(c2), + length(c4), + length(c2) = length(c4) +from char_udf_1 limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +POSTHOOK: query: select + length(c2), + length(c4), + length(c2) = length(c4) +from char_udf_1 limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +7 7 true +PREHOOK: query: select + locate('a', 'abcdabcd', 3), + locate(cast('a' as char(1)), cast('abcdabcd' as char(10)), 3), + locate('a', 'abcdabcd', 3) = locate(cast('a' as char(1)), cast('abcdabcd' as char(10)), 3) +from char_udf_1 limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +POSTHOOK: query: select + locate('a', 'abcdabcd', 3), + locate(cast('a' as char(1)), cast('abcdabcd' as char(10)), 3), + locate('a', 'abcdabcd', 3) = locate(cast('a' as char(1)), cast('abcdabcd' as char(10)), 3) +from char_udf_1 limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +5 5 true +PREHOOK: query: select + lpad(c2, 15, ' '), + lpad(c4, 15, ' '), + lpad(c2, 15, ' ') = lpad(c4, 15, ' ') +from char_udf_1 limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +POSTHOOK: query: select + lpad(c2, 15, ' '), + lpad(c4, 15, ' '), + lpad(c2, 15, ' ') = lpad(c4, 15, ' ') +from char_udf_1 limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### + val_238 val_238 true +PREHOOK: query: select + ltrim(c2), + ltrim(c4), + ltrim(c2) = ltrim(c4) +from char_udf_1 limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +POSTHOOK: query: select + ltrim(c2), + ltrim(c4), + ltrim(c2) = ltrim(c4) +from char_udf_1 limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +val_238 val_238 true +PREHOOK: query: -- In hive wiki page https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF +-- we only allow A regexp B, not regexp (A,B). + +select + c2 regexp 'val', + c4 regexp 'val', + (c2 regexp 'val') = (c4 regexp 'val') +from char_udf_1 limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +POSTHOOK: query: -- In hive wiki page https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF +-- we only allow A regexp B, not regexp (A,B). + +select + c2 regexp 'val', + c4 regexp 'val', + (c2 regexp 'val') = (c4 regexp 'val') +from char_udf_1 limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +true true true +PREHOOK: query: select + regexp_extract(c2, 'val_([0-9]+)', 1), + regexp_extract(c4, 'val_([0-9]+)', 1), + regexp_extract(c2, 'val_([0-9]+)', 1) = regexp_extract(c4, 'val_([0-9]+)', 1) +from char_udf_1 limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +POSTHOOK: query: select + regexp_extract(c2, 'val_([0-9]+)', 1), + regexp_extract(c4, 'val_([0-9]+)', 1), + regexp_extract(c2, 'val_([0-9]+)', 1) = regexp_extract(c4, 'val_([0-9]+)', 1) +from char_udf_1 limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +238 238 true +PREHOOK: query: select + regexp_replace(c2, 'val', 'replaced'), + regexp_replace(c4, 'val', 'replaced'), + regexp_replace(c2, 'val', 'replaced') = regexp_replace(c4, 'val', 'replaced') +from char_udf_1 limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +POSTHOOK: query: select + regexp_replace(c2, 'val', 'replaced'), + regexp_replace(c4, 'val', 'replaced'), + regexp_replace(c2, 'val', 'replaced') = regexp_replace(c4, 'val', 'replaced') +from char_udf_1 limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +replaced_238 replaced_238 true +PREHOOK: query: select + reverse(c2), + reverse(c4), + reverse(c2) = reverse(c4) +from char_udf_1 limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +POSTHOOK: query: select + reverse(c2), + reverse(c4), + reverse(c2) = reverse(c4) +from char_udf_1 limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +832_lav 832_lav true +PREHOOK: query: select + rpad(c2, 15, ' '), + rpad(c4, 15, ' '), + rpad(c2, 15, ' ') = rpad(c4, 15, ' ') +from char_udf_1 limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +POSTHOOK: query: select + rpad(c2, 15, ' '), + rpad(c4, 15, ' '), + rpad(c2, 15, ' ') = rpad(c4, 15, ' ') +from char_udf_1 limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +val_238 val_238 true +PREHOOK: query: select + rtrim(c2), + rtrim(c4), + rtrim(c2) = rtrim(c4) +from char_udf_1 limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +POSTHOOK: query: select + rtrim(c2), + rtrim(c4), + rtrim(c2) = rtrim(c4) +from char_udf_1 limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +val_238 val_238 true +PREHOOK: query: select + sentences('See spot run. See jane run.'), + sentences(cast('See spot run. See jane run.' as char(50))) +from char_udf_1 limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +POSTHOOK: query: select + sentences('See spot run. See jane run.'), + sentences(cast('See spot run. See jane run.' as char(50))) +from char_udf_1 limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +[["See","spot","run"],["See","jane","run"]] [["See","spot","run"],["See","jane","run"]] +PREHOOK: query: select + split(c2, '_'), + split(c4, '_') +from char_udf_1 limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +POSTHOOK: query: select + split(c2, '_'), + split(c4, '_') +from char_udf_1 limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +["val","238"] ["val","238"] +PREHOOK: query: select + str_to_map('a:1,b:2,c:3',',',':'), + str_to_map(cast('a:1,b:2,c:3' as char(20)),',',':') +from char_udf_1 limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +POSTHOOK: query: select + str_to_map('a:1,b:2,c:3',',',':'), + str_to_map(cast('a:1,b:2,c:3' as char(20)),',',':') +from char_udf_1 limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +{"a":"1","b":"2","c":"3"} {"a":"1","b":"2","c":"3"} +PREHOOK: query: select + substr(c2, 1, 3), + substr(c4, 1, 3), + substr(c2, 1, 3) = substr(c4, 1, 3) +from char_udf_1 limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +POSTHOOK: query: select + substr(c2, 1, 3), + substr(c4, 1, 3), + substr(c2, 1, 3) = substr(c4, 1, 3) +from char_udf_1 limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +val val true +PREHOOK: query: select + trim(c2), + trim(c4), + trim(c2) = trim(c4) +from char_udf_1 limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +POSTHOOK: query: select + trim(c2), + trim(c4), + trim(c2) = trim(c4) +from char_udf_1 limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +val_238 val_238 true +PREHOOK: query: -- Aggregate Functions +select + compute_stats(c2, 16), + compute_stats(c4, 16) +from char_udf_1 +PREHOOK: type: QUERY +PREHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +POSTHOOK: query: -- Aggregate Functions +select + compute_stats(c2, 16), + compute_stats(c4, 16) +from char_udf_1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +{"columntype":"String","maxlength":7,"avglength":7.0,"countnulls":0,"numdistinctvalues":1,"ndvbitvector":"{0}{3}{2}{3}{1}{0}{2}{0}{1}{0}{0}{1}{3}{2}{0}{3}"} {"columntype":"String","maxlength":7,"avglength":7.0,"countnulls":0,"numdistinctvalues":1,"ndvbitvector":"{0}{3}{2}{3}{1}{0}{2}{0}{1}{0}{0}{1}{3}{2}{0}{3}"} +PREHOOK: query: select + min(c2), + min(c4) +from char_udf_1 +PREHOOK: type: QUERY +PREHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +POSTHOOK: query: select + min(c2), + min(c4) +from char_udf_1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +val_238 val_238 +PREHOOK: query: select + max(c2), + max(c4) +from char_udf_1 +PREHOOK: type: QUERY +PREHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +POSTHOOK: query: select + max(c2), + max(c4) +from char_udf_1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@char_udf_1 +#### A masked pattern was here #### +val_238 val_238 +PREHOOK: query: drop table char_udf_1 +PREHOOK: type: DROPTABLE +PREHOOK: Input: default@char_udf_1 +PREHOOK: Output: default@char_udf_1 +POSTHOOK: query: drop table char_udf_1 +POSTHOOK: type: DROPTABLE +POSTHOOK: Input: default@char_udf_1 +POSTHOOK: Output: default@char_udf_1 http://git-wip-us.apache.org/repos/asf/hive/blob/22541610/ql/src/test/results/clientpositive/input4.q.java1.7.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/input4.q.java1.7.out b/ql/src/test/results/clientpositive/input4.q.java1.7.out deleted file mode 100644 index eaeedcb..0000000 --- a/ql/src/test/results/clientpositive/input4.q.java1.7.out +++ /dev/null @@ -1,559 +0,0 @@ -PREHOOK: query: -- JAVA_VERSION_SPECIFIC_OUTPUT - -CREATE TABLE INPUT4(KEY STRING, VALUE STRING) STORED AS TEXTFILE -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@INPUT4 -POSTHOOK: query: -- JAVA_VERSION_SPECIFIC_OUTPUT - -CREATE TABLE INPUT4(KEY STRING, VALUE STRING) STORED AS TEXTFILE -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@INPUT4 -PREHOOK: query: EXPLAIN -LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE INPUT4 -PREHOOK: type: LOAD -POSTHOOK: query: EXPLAIN -LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE INPUT4 -POSTHOOK: type: LOAD -STAGE DEPENDENCIES: - Stage-0 is a root stage - Stage-1 depends on stages: Stage-0 - -STAGE PLANS: - Stage: Stage-0 - Move Operator - tables: - replace: false - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.input4 - - Stage: Stage-1 - Stats-Aggr Operator - -PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE INPUT4 -PREHOOK: type: LOAD -#### A masked pattern was here #### -PREHOOK: Output: default@input4 -POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE INPUT4 -POSTHOOK: type: LOAD -#### A masked pattern was here #### -POSTHOOK: Output: default@input4 -PREHOOK: query: EXPLAIN FORMATTED -SELECT Input4Alias.VALUE, Input4Alias.KEY FROM INPUT4 AS Input4Alias -PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN FORMATTED -SELECT Input4Alias.VALUE, Input4Alias.KEY FROM INPUT4 AS Input4Alias -POSTHOOK: type: QUERY -{"STAGE DEPENDENCIES":{"Stage-0":{"ROOT STAGE":"TRUE"}},"STAGE PLANS":{"Stage-0":{"Fetch Operator":{"limit:":"-1","Processor Tree:":{"TableScan":{"alias:":"input4alias","Statistics:":"Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE","children":{"Select Operator":{"expressions:":"value (type: string), key (type: string)","outputColumnNames:":["_col0","_col1"],"Statistics:":"Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE","children":{"ListSink":{}}}}}}}}}} -PREHOOK: query: SELECT Input4Alias.VALUE, Input4Alias.KEY FROM INPUT4 AS Input4Alias -PREHOOK: type: QUERY -PREHOOK: Input: default@input4 -#### A masked pattern was here #### -POSTHOOK: query: SELECT Input4Alias.VALUE, Input4Alias.KEY FROM INPUT4 AS Input4Alias -POSTHOOK: type: QUERY -POSTHOOK: Input: default@input4 -#### A masked pattern was here #### -val_238 238 -val_86 86 -val_311 311 -val_27 27 -val_165 165 -val_409 409 -val_255 255 -val_278 278 -val_98 98 -val_484 484 -val_265 265 -val_193 193 -val_401 401 -val_150 150 -val_273 273 -val_224 224 -val_369 369 -val_66 66 -val_128 128 -val_213 213 -val_146 146 -val_406 406 -val_429 429 -val_374 374 -val_152 152 -val_469 469 -val_145 145 -val_495 495 -val_37 37 -val_327 327 -val_281 281 -val_277 277 -val_209 209 -val_15 15 -val_82 82 -val_403 403 -val_166 166 -val_417 417 -val_430 430 -val_252 252 -val_292 292 -val_219 219 -val_287 287 -val_153 153 -val_193 193 -val_338 338 -val_446 446 -val_459 459 -val_394 394 -val_237 237 -val_482 482 -val_174 174 -val_413 413 -val_494 494 -val_207 207 -val_199 199 -val_466 466 -val_208 208 -val_174 174 -val_399 399 -val_396 396 -val_247 247 -val_417 417 -val_489 489 -val_162 162 -val_377 377 -val_397 397 -val_309 309 -val_365 365 -val_266 266 -val_439 439 -val_342 342 -val_367 367 -val_325 325 -val_167 167 -val_195 195 -val_475 475 -val_17 17 -val_113 113 -val_155 155 -val_203 203 -val_339 339 -val_0 0 -val_455 455 -val_128 128 -val_311 311 -val_316 316 -val_57 57 -val_302 302 -val_205 205 -val_149 149 -val_438 438 -val_345 345 -val_129 129 -val_170 170 -val_20 20 -val_489 489 -val_157 157 -val_378 378 -val_221 221 -val_92 92 -val_111 111 -val_47 47 -val_72 72 -val_4 4 -val_280 280 -val_35 35 -val_427 427 -val_277 277 -val_208 208 -val_356 356 -val_399 399 -val_169 169 -val_382 382 -val_498 498 -val_125 125 -val_386 386 -val_437 437 -val_469 469 -val_192 192 -val_286 286 -val_187 187 -val_176 176 -val_54 54 -val_459 459 -val_51 51 -val_138 138 -val_103 103 -val_239 239 -val_213 213 -val_216 216 -val_430 430 -val_278 278 -val_176 176 -val_289 289 -val_221 221 -val_65 65 -val_318 318 -val_332 332 -val_311 311 -val_275 275 -val_137 137 -val_241 241 -val_83 83 -val_333 333 -val_180 180 -val_284 284 -val_12 12 -val_230 230 -val_181 181 -val_67 67 -val_260 260 -val_404 404 -val_384 384 -val_489 489 -val_353 353 -val_373 373 -val_272 272 -val_138 138 -val_217 217 -val_84 84 -val_348 348 -val_466 466 -val_58 58 -val_8 8 -val_411 411 -val_230 230 -val_208 208 -val_348 348 -val_24 24 -val_463 463 -val_431 431 -val_179 179 -val_172 172 -val_42 42 -val_129 129 -val_158 158 -val_119 119 -val_496 496 -val_0 0 -val_322 322 -val_197 197 -val_468 468 -val_393 393 -val_454 454 -val_100 100 -val_298 298 -val_199 199 -val_191 191 -val_418 418 -val_96 96 -val_26 26 -val_165 165 -val_327 327 -val_230 230 -val_205 205 -val_120 120 -val_131 131 -val_51 51 -val_404 404 -val_43 43 -val_436 436 -val_156 156 -val_469 469 -val_468 468 -val_308 308 -val_95 95 -val_196 196 -val_288 288 -val_481 481 -val_457 457 -val_98 98 -val_282 282 -val_197 197 -val_187 187 -val_318 318 -val_318 318 -val_409 409 -val_470 470 -val_137 137 -val_369 369 -val_316 316 -val_169 169 -val_413 413 -val_85 85 -val_77 77 -val_0 0 -val_490 490 -val_87 87 -val_364 364 -val_179 179 -val_118 118 -val_134 134 -val_395 395 -val_282 282 -val_138 138 -val_238 238 -val_419 419 -val_15 15 -val_118 118 -val_72 72 -val_90 90 -val_307 307 -val_19 19 -val_435 435 -val_10 10 -val_277 277 -val_273 273 -val_306 306 -val_224 224 -val_309 309 -val_389 389 -val_327 327 -val_242 242 -val_369 369 -val_392 392 -val_272 272 -val_331 331 -val_401 401 -val_242 242 -val_452 452 -val_177 177 -val_226 226 -val_5 5 -val_497 497 -val_402 402 -val_396 396 -val_317 317 -val_395 395 -val_58 58 -val_35 35 -val_336 336 -val_95 95 -val_11 11 -val_168 168 -val_34 34 -val_229 229 -val_233 233 -val_143 143 -val_472 472 -val_322 322 -val_498 498 -val_160 160 -val_195 195 -val_42 42 -val_321 321 -val_430 430 -val_119 119 -val_489 489 -val_458 458 -val_78 78 -val_76 76 -val_41 41 -val_223 223 -val_492 492 -val_149 149 -val_449 449 -val_218 218 -val_228 228 -val_138 138 -val_453 453 -val_30 30 -val_209 209 -val_64 64 -val_468 468 -val_76 76 -val_74 74 -val_342 342 -val_69 69 -val_230 230 -val_33 33 -val_368 368 -val_103 103 -val_296 296 -val_113 113 -val_216 216 -val_367 367 -val_344 344 -val_167 167 -val_274 274 -val_219 219 -val_239 239 -val_485 485 -val_116 116 -val_223 223 -val_256 256 -val_263 263 -val_70 70 -val_487 487 -val_480 480 -val_401 401 -val_288 288 -val_191 191 -val_5 5 -val_244 244 -val_438 438 -val_128 128 -val_467 467 -val_432 432 -val_202 202 -val_316 316 -val_229 229 -val_469 469 -val_463 463 -val_280 280 -val_2 2 -val_35 35 -val_283 283 -val_331 331 -val_235 235 -val_80 80 -val_44 44 -val_193 193 -val_321 321 -val_335 335 -val_104 104 -val_466 466 -val_366 366 -val_175 175 -val_403 403 -val_483 483 -val_53 53 -val_105 105 -val_257 257 -val_406 406 -val_409 409 -val_190 190 -val_406 406 -val_401 401 -val_114 114 -val_258 258 -val_90 90 -val_203 203 -val_262 262 -val_348 348 -val_424 424 -val_12 12 -val_396 396 -val_201 201 -val_217 217 -val_164 164 -val_431 431 -val_454 454 -val_478 478 -val_298 298 -val_125 125 -val_431 431 -val_164 164 -val_424 424 -val_187 187 -val_382 382 -val_5 5 -val_70 70 -val_397 397 -val_480 480 -val_291 291 -val_24 24 -val_351 351 -val_255 255 -val_104 104 -val_70 70 -val_163 163 -val_438 438 -val_119 119 -val_414 414 -val_200 200 -val_491 491 -val_237 237 -val_439 439 -val_360 360 -val_248 248 -val_479 479 -val_305 305 -val_417 417 -val_199 199 -val_444 444 -val_120 120 -val_429 429 -val_169 169 -val_443 443 -val_323 323 -val_325 325 -val_277 277 -val_230 230 -val_478 478 -val_178 178 -val_468 468 -val_310 310 -val_317 317 -val_333 333 -val_493 493 -val_460 460 -val_207 207 -val_249 249 -val_265 265 -val_480 480 -val_83 83 -val_136 136 -val_353 353 -val_172 172 -val_214 214 -val_462 462 -val_233 233 -val_406 406 -val_133 133 -val_175 175 -val_189 189 -val_454 454 -val_375 375 -val_401 401 -val_421 421 -val_407 407 -val_384 384 -val_256 256 -val_26 26 -val_134 134 -val_67 67 -val_384 384 -val_379 379 -val_18 18 -val_462 462 -val_492 492 -val_100 100 -val_298 298 -val_9 9 -val_341 341 -val_498 498 -val_146 146 -val_458 458 -val_362 362 -val_186 186 -val_285 285 -val_348 348 -val_167 167 -val_18 18 -val_273 273 -val_183 183 -val_281 281 -val_344 344 -val_97 97 -val_469 469 -val_315 315 -val_84 84 -val_28 28 -val_37 37 -val_448 448 -val_152 152 -val_348 348 -val_307 307 -val_194 194 -val_414 414 -val_477 477 -val_222 222 -val_126 126 -val_90 90 -val_169 169 -val_403 403 -val_400 400 -val_200 200 -val_97 97 http://git-wip-us.apache.org/repos/asf/hive/blob/22541610/ql/src/test/results/clientpositive/input4.q.java1.8.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/input4.q.java1.8.out b/ql/src/test/results/clientpositive/input4.q.java1.8.out deleted file mode 100644 index eaeedcb..0000000 --- a/ql/src/test/results/clientpositive/input4.q.java1.8.out +++ /dev/null @@ -1,559 +0,0 @@ -PREHOOK: query: -- JAVA_VERSION_SPECIFIC_OUTPUT - -CREATE TABLE INPUT4(KEY STRING, VALUE STRING) STORED AS TEXTFILE -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@INPUT4 -POSTHOOK: query: -- JAVA_VERSION_SPECIFIC_OUTPUT - -CREATE TABLE INPUT4(KEY STRING, VALUE STRING) STORED AS TEXTFILE -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@INPUT4 -PREHOOK: query: EXPLAIN -LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE INPUT4 -PREHOOK: type: LOAD -POSTHOOK: query: EXPLAIN -LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE INPUT4 -POSTHOOK: type: LOAD -STAGE DEPENDENCIES: - Stage-0 is a root stage - Stage-1 depends on stages: Stage-0 - -STAGE PLANS: - Stage: Stage-0 - Move Operator - tables: - replace: false - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.input4 - - Stage: Stage-1 - Stats-Aggr Operator - -PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE INPUT4 -PREHOOK: type: LOAD -#### A masked pattern was here #### -PREHOOK: Output: default@input4 -POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE INPUT4 -POSTHOOK: type: LOAD -#### A masked pattern was here #### -POSTHOOK: Output: default@input4 -PREHOOK: query: EXPLAIN FORMATTED -SELECT Input4Alias.VALUE, Input4Alias.KEY FROM INPUT4 AS Input4Alias -PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN FORMATTED -SELECT Input4Alias.VALUE, Input4Alias.KEY FROM INPUT4 AS Input4Alias -POSTHOOK: type: QUERY -{"STAGE DEPENDENCIES":{"Stage-0":{"ROOT STAGE":"TRUE"}},"STAGE PLANS":{"Stage-0":{"Fetch Operator":{"limit:":"-1","Processor Tree:":{"TableScan":{"alias:":"input4alias","Statistics:":"Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE","children":{"Select Operator":{"expressions:":"value (type: string), key (type: string)","outputColumnNames:":["_col0","_col1"],"Statistics:":"Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE","children":{"ListSink":{}}}}}}}}}} -PREHOOK: query: SELECT Input4Alias.VALUE, Input4Alias.KEY FROM INPUT4 AS Input4Alias -PREHOOK: type: QUERY -PREHOOK: Input: default@input4 -#### A masked pattern was here #### -POSTHOOK: query: SELECT Input4Alias.VALUE, Input4Alias.KEY FROM INPUT4 AS Input4Alias -POSTHOOK: type: QUERY -POSTHOOK: Input: default@input4 -#### A masked pattern was here #### -val_238 238 -val_86 86 -val_311 311 -val_27 27 -val_165 165 -val_409 409 -val_255 255 -val_278 278 -val_98 98 -val_484 484 -val_265 265 -val_193 193 -val_401 401 -val_150 150 -val_273 273 -val_224 224 -val_369 369 -val_66 66 -val_128 128 -val_213 213 -val_146 146 -val_406 406 -val_429 429 -val_374 374 -val_152 152 -val_469 469 -val_145 145 -val_495 495 -val_37 37 -val_327 327 -val_281 281 -val_277 277 -val_209 209 -val_15 15 -val_82 82 -val_403 403 -val_166 166 -val_417 417 -val_430 430 -val_252 252 -val_292 292 -val_219 219 -val_287 287 -val_153 153 -val_193 193 -val_338 338 -val_446 446 -val_459 459 -val_394 394 -val_237 237 -val_482 482 -val_174 174 -val_413 413 -val_494 494 -val_207 207 -val_199 199 -val_466 466 -val_208 208 -val_174 174 -val_399 399 -val_396 396 -val_247 247 -val_417 417 -val_489 489 -val_162 162 -val_377 377 -val_397 397 -val_309 309 -val_365 365 -val_266 266 -val_439 439 -val_342 342 -val_367 367 -val_325 325 -val_167 167 -val_195 195 -val_475 475 -val_17 17 -val_113 113 -val_155 155 -val_203 203 -val_339 339 -val_0 0 -val_455 455 -val_128 128 -val_311 311 -val_316 316 -val_57 57 -val_302 302 -val_205 205 -val_149 149 -val_438 438 -val_345 345 -val_129 129 -val_170 170 -val_20 20 -val_489 489 -val_157 157 -val_378 378 -val_221 221 -val_92 92 -val_111 111 -val_47 47 -val_72 72 -val_4 4 -val_280 280 -val_35 35 -val_427 427 -val_277 277 -val_208 208 -val_356 356 -val_399 399 -val_169 169 -val_382 382 -val_498 498 -val_125 125 -val_386 386 -val_437 437 -val_469 469 -val_192 192 -val_286 286 -val_187 187 -val_176 176 -val_54 54 -val_459 459 -val_51 51 -val_138 138 -val_103 103 -val_239 239 -val_213 213 -val_216 216 -val_430 430 -val_278 278 -val_176 176 -val_289 289 -val_221 221 -val_65 65 -val_318 318 -val_332 332 -val_311 311 -val_275 275 -val_137 137 -val_241 241 -val_83 83 -val_333 333 -val_180 180 -val_284 284 -val_12 12 -val_230 230 -val_181 181 -val_67 67 -val_260 260 -val_404 404 -val_384 384 -val_489 489 -val_353 353 -val_373 373 -val_272 272 -val_138 138 -val_217 217 -val_84 84 -val_348 348 -val_466 466 -val_58 58 -val_8 8 -val_411 411 -val_230 230 -val_208 208 -val_348 348 -val_24 24 -val_463 463 -val_431 431 -val_179 179 -val_172 172 -val_42 42 -val_129 129 -val_158 158 -val_119 119 -val_496 496 -val_0 0 -val_322 322 -val_197 197 -val_468 468 -val_393 393 -val_454 454 -val_100 100 -val_298 298 -val_199 199 -val_191 191 -val_418 418 -val_96 96 -val_26 26 -val_165 165 -val_327 327 -val_230 230 -val_205 205 -val_120 120 -val_131 131 -val_51 51 -val_404 404 -val_43 43 -val_436 436 -val_156 156 -val_469 469 -val_468 468 -val_308 308 -val_95 95 -val_196 196 -val_288 288 -val_481 481 -val_457 457 -val_98 98 -val_282 282 -val_197 197 -val_187 187 -val_318 318 -val_318 318 -val_409 409 -val_470 470 -val_137 137 -val_369 369 -val_316 316 -val_169 169 -val_413 413 -val_85 85 -val_77 77 -val_0 0 -val_490 490 -val_87 87 -val_364 364 -val_179 179 -val_118 118 -val_134 134 -val_395 395 -val_282 282 -val_138 138 -val_238 238 -val_419 419 -val_15 15 -val_118 118 -val_72 72 -val_90 90 -val_307 307 -val_19 19 -val_435 435 -val_10 10 -val_277 277 -val_273 273 -val_306 306 -val_224 224 -val_309 309 -val_389 389 -val_327 327 -val_242 242 -val_369 369 -val_392 392 -val_272 272 -val_331 331 -val_401 401 -val_242 242 -val_452 452 -val_177 177 -val_226 226 -val_5 5 -val_497 497 -val_402 402 -val_396 396 -val_317 317 -val_395 395 -val_58 58 -val_35 35 -val_336 336 -val_95 95 -val_11 11 -val_168 168 -val_34 34 -val_229 229 -val_233 233 -val_143 143 -val_472 472 -val_322 322 -val_498 498 -val_160 160 -val_195 195 -val_42 42 -val_321 321 -val_430 430 -val_119 119 -val_489 489 -val_458 458 -val_78 78 -val_76 76 -val_41 41 -val_223 223 -val_492 492 -val_149 149 -val_449 449 -val_218 218 -val_228 228 -val_138 138 -val_453 453 -val_30 30 -val_209 209 -val_64 64 -val_468 468 -val_76 76 -val_74 74 -val_342 342 -val_69 69 -val_230 230 -val_33 33 -val_368 368 -val_103 103 -val_296 296 -val_113 113 -val_216 216 -val_367 367 -val_344 344 -val_167 167 -val_274 274 -val_219 219 -val_239 239 -val_485 485 -val_116 116 -val_223 223 -val_256 256 -val_263 263 -val_70 70 -val_487 487 -val_480 480 -val_401 401 -val_288 288 -val_191 191 -val_5 5 -val_244 244 -val_438 438 -val_128 128 -val_467 467 -val_432 432 -val_202 202 -val_316 316 -val_229 229 -val_469 469 -val_463 463 -val_280 280 -val_2 2 -val_35 35 -val_283 283 -val_331 331 -val_235 235 -val_80 80 -val_44 44 -val_193 193 -val_321 321 -val_335 335 -val_104 104 -val_466 466 -val_366 366 -val_175 175 -val_403 403 -val_483 483 -val_53 53 -val_105 105 -val_257 257 -val_406 406 -val_409 409 -val_190 190 -val_406 406 -val_401 401 -val_114 114 -val_258 258 -val_90 90 -val_203 203 -val_262 262 -val_348 348 -val_424 424 -val_12 12 -val_396 396 -val_201 201 -val_217 217 -val_164 164 -val_431 431 -val_454 454 -val_478 478 -val_298 298 -val_125 125 -val_431 431 -val_164 164 -val_424 424 -val_187 187 -val_382 382 -val_5 5 -val_70 70 -val_397 397 -val_480 480 -val_291 291 -val_24 24 -val_351 351 -val_255 255 -val_104 104 -val_70 70 -val_163 163 -val_438 438 -val_119 119 -val_414 414 -val_200 200 -val_491 491 -val_237 237 -val_439 439 -val_360 360 -val_248 248 -val_479 479 -val_305 305 -val_417 417 -val_199 199 -val_444 444 -val_120 120 -val_429 429 -val_169 169 -val_443 443 -val_323 323 -val_325 325 -val_277 277 -val_230 230 -val_478 478 -val_178 178 -val_468 468 -val_310 310 -val_317 317 -val_333 333 -val_493 493 -val_460 460 -val_207 207 -val_249 249 -val_265 265 -val_480 480 -val_83 83 -val_136 136 -val_353 353 -val_172 172 -val_214 214 -val_462 462 -val_233 233 -val_406 406 -val_133 133 -val_175 175 -val_189 189 -val_454 454 -val_375 375 -val_401 401 -val_421 421 -val_407 407 -val_384 384 -val_256 256 -val_26 26 -val_134 134 -val_67 67 -val_384 384 -val_379 379 -val_18 18 -val_462 462 -val_492 492 -val_100 100 -val_298 298 -val_9 9 -val_341 341 -val_498 498 -val_146 146 -val_458 458 -val_362 362 -val_186 186 -val_285 285 -val_348 348 -val_167 167 -val_18 18 -val_273 273 -val_183 183 -val_281 281 -val_344 344 -val_97 97 -val_469 469 -val_315 315 -val_84 84 -val_28 28 -val_37 37 -val_448 448 -val_152 152 -val_348 348 -val_307 307 -val_194 194 -val_414 414 -val_477 477 -val_222 222 -val_126 126 -val_90 90 -val_169 169 -val_403 403 -val_400 400 -val_200 200 -val_97 97 http://git-wip-us.apache.org/repos/asf/hive/blob/22541610/ql/src/test/results/clientpositive/input4.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/input4.q.out b/ql/src/test/results/clientpositive/input4.q.out new file mode 100644 index 0000000..83912f6 --- /dev/null +++ b/ql/src/test/results/clientpositive/input4.q.out @@ -0,0 +1,555 @@ +PREHOOK: query: CREATE TABLE INPUT4(KEY STRING, VALUE STRING) STORED AS TEXTFILE +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@INPUT4 +POSTHOOK: query: CREATE TABLE INPUT4(KEY STRING, VALUE STRING) STORED AS TEXTFILE +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@INPUT4 +PREHOOK: query: EXPLAIN +LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE INPUT4 +PREHOOK: type: LOAD +POSTHOOK: query: EXPLAIN +LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE INPUT4 +POSTHOOK: type: LOAD +STAGE DEPENDENCIES: + Stage-0 is a root stage + Stage-1 depends on stages: Stage-0 + +STAGE PLANS: + Stage: Stage-0 + Move Operator + tables: + replace: false + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + name: default.input4 + + Stage: Stage-1 + Stats-Aggr Operator + +PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE INPUT4 +PREHOOK: type: LOAD +#### A masked pattern was here #### +PREHOOK: Output: default@input4 +POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/kv1.txt' INTO TABLE INPUT4 +POSTHOOK: type: LOAD +#### A masked pattern was here #### +POSTHOOK: Output: default@input4 +PREHOOK: query: EXPLAIN FORMATTED +SELECT Input4Alias.VALUE, Input4Alias.KEY FROM INPUT4 AS Input4Alias +PREHOOK: type: QUERY +POSTHOOK: query: EXPLAIN FORMATTED +SELECT Input4Alias.VALUE, Input4Alias.KEY FROM INPUT4 AS Input4Alias +POSTHOOK: type: QUERY +{"STAGE DEPENDENCIES":{"Stage-0":{"ROOT STAGE":"TRUE"}},"STAGE PLANS":{"Stage-0":{"Fetch Operator":{"limit:":"-1","Processor Tree:":{"TableScan":{"alias:":"input4alias","Statistics:":"Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE","children":{"Select Operator":{"expressions:":"value (type: string), key (type: string)","outputColumnNames:":["_col0","_col1"],"Statistics:":"Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE","children":{"ListSink":{}}}}}}}}}} +PREHOOK: query: SELECT Input4Alias.VALUE, Input4Alias.KEY FROM INPUT4 AS Input4Alias +PREHOOK: type: QUERY +PREHOOK: Input: default@input4 +#### A masked pattern was here #### +POSTHOOK: query: SELECT Input4Alias.VALUE, Input4Alias.KEY FROM INPUT4 AS Input4Alias +POSTHOOK: type: QUERY +POSTHOOK: Input: default@input4 +#### A masked pattern was here #### +val_238 238 +val_86 86 +val_311 311 +val_27 27 +val_165 165 +val_409 409 +val_255 255 +val_278 278 +val_98 98 +val_484 484 +val_265 265 +val_193 193 +val_401 401 +val_150 150 +val_273 273 +val_224 224 +val_369 369 +val_66 66 +val_128 128 +val_213 213 +val_146 146 +val_406 406 +val_429 429 +val_374 374 +val_152 152 +val_469 469 +val_145 145 +val_495 495 +val_37 37 +val_327 327 +val_281 281 +val_277 277 +val_209 209 +val_15 15 +val_82 82 +val_403 403 +val_166 166 +val_417 417 +val_430 430 +val_252 252 +val_292 292 +val_219 219 +val_287 287 +val_153 153 +val_193 193 +val_338 338 +val_446 446 +val_459 459 +val_394 394 +val_237 237 +val_482 482 +val_174 174 +val_413 413 +val_494 494 +val_207 207 +val_199 199 +val_466 466 +val_208 208 +val_174 174 +val_399 399 +val_396 396 +val_247 247 +val_417 417 +val_489 489 +val_162 162 +val_377 377 +val_397 397 +val_309 309 +val_365 365 +val_266 266 +val_439 439 +val_342 342 +val_367 367 +val_325 325 +val_167 167 +val_195 195 +val_475 475 +val_17 17 +val_113 113 +val_155 155 +val_203 203 +val_339 339 +val_0 0 +val_455 455 +val_128 128 +val_311 311 +val_316 316 +val_57 57 +val_302 302 +val_205 205 +val_149 149 +val_438 438 +val_345 345 +val_129 129 +val_170 170 +val_20 20 +val_489 489 +val_157 157 +val_378 378 +val_221 221 +val_92 92 +val_111 111 +val_47 47 +val_72 72 +val_4 4 +val_280 280 +val_35 35 +val_427 427 +val_277 277 +val_208 208 +val_356 356 +val_399 399 +val_169 169 +val_382 382 +val_498 498 +val_125 125 +val_386 386 +val_437 437 +val_469 469 +val_192 192 +val_286 286 +val_187 187 +val_176 176 +val_54 54 +val_459 459 +val_51 51 +val_138 138 +val_103 103 +val_239 239 +val_213 213 +val_216 216 +val_430 430 +val_278 278 +val_176 176 +val_289 289 +val_221 221 +val_65 65 +val_318 318 +val_332 332 +val_311 311 +val_275 275 +val_137 137 +val_241 241 +val_83 83 +val_333 333 +val_180 180 +val_284 284 +val_12 12 +val_230 230 +val_181 181 +val_67 67 +val_260 260 +val_404 404 +val_384 384 +val_489 489 +val_353 353 +val_373 373 +val_272 272 +val_138 138 +val_217 217 +val_84 84 +val_348 348 +val_466 466 +val_58 58 +val_8 8 +val_411 411 +val_230 230 +val_208 208 +val_348 348 +val_24 24 +val_463 463 +val_431 431 +val_179 179 +val_172 172 +val_42 42 +val_129 129 +val_158 158 +val_119 119 +val_496 496 +val_0 0 +val_322 322 +val_197 197 +val_468 468 +val_393 393 +val_454 454 +val_100 100 +val_298 298 +val_199 199 +val_191 191 +val_418 418 +val_96 96 +val_26 26 +val_165 165 +val_327 327 +val_230 230 +val_205 205 +val_120 120 +val_131 131 +val_51 51 +val_404 404 +val_43 43 +val_436 436 +val_156 156 +val_469 469 +val_468 468 +val_308 308 +val_95 95 +val_196 196 +val_288 288 +val_481 481 +val_457 457 +val_98 98 +val_282 282 +val_197 197 +val_187 187 +val_318 318 +val_318 318 +val_409 409 +val_470 470 +val_137 137 +val_369 369 +val_316 316 +val_169 169 +val_413 413 +val_85 85 +val_77 77 +val_0 0 +val_490 490 +val_87 87 +val_364 364 +val_179 179 +val_118 118 +val_134 134 +val_395 395 +val_282 282 +val_138 138 +val_238 238 +val_419 419 +val_15 15 +val_118 118 +val_72 72 +val_90 90 +val_307 307 +val_19 19 +val_435 435 +val_10 10 +val_277 277 +val_273 273 +val_306 306 +val_224 224 +val_309 309 +val_389 389 +val_327 327 +val_242 242 +val_369 369 +val_392 392 +val_272 272 +val_331 331 +val_401 401 +val_242 242 +val_452 452 +val_177 177 +val_226 226 +val_5 5 +val_497 497 +val_402 402 +val_396 396 +val_317 317 +val_395 395 +val_58 58 +val_35 35 +val_336 336 +val_95 95 +val_11 11 +val_168 168 +val_34 34 +val_229 229 +val_233 233 +val_143 143 +val_472 472 +val_322 322 +val_498 498 +val_160 160 +val_195 195 +val_42 42 +val_321 321 +val_430 430 +val_119 119 +val_489 489 +val_458 458 +val_78 78 +val_76 76 +val_41 41 +val_223 223 +val_492 492 +val_149 149 +val_449 449 +val_218 218 +val_228 228 +val_138 138 +val_453 453 +val_30 30 +val_209 209 +val_64 64 +val_468 468 +val_76 76 +val_74 74 +val_342 342 +val_69 69 +val_230 230 +val_33 33 +val_368 368 +val_103 103 +val_296 296 +val_113 113 +val_216 216 +val_367 367 +val_344 344 +val_167 167 +val_274 274 +val_219 219 +val_239 239 +val_485 485 +val_116 116 +val_223 223 +val_256 256 +val_263 263 +val_70 70 +val_487 487 +val_480 480 +val_401 401 +val_288 288 +val_191 191 +val_5 5 +val_244 244 +val_438 438 +val_128 128 +val_467 467 +val_432 432 +val_202 202 +val_316 316 +val_229 229 +val_469 469 +val_463 463 +val_280 280 +val_2 2 +val_35 35 +val_283 283 +val_331 331 +val_235 235 +val_80 80 +val_44 44 +val_193 193 +val_321 321 +val_335 335 +val_104 104 +val_466 466 +val_366 366 +val_175 175 +val_403 403 +val_483 483 +val_53 53 +val_105 105 +val_257 257 +val_406 406 +val_409 409 +val_190 190 +val_406 406 +val_401 401 +val_114 114 +val_258 258 +val_90 90 +val_203 203 +val_262 262 +val_348 348 +val_424 424 +val_12 12 +val_396 396 +val_201 201 +val_217 217 +val_164 164 +val_431 431 +val_454 454 +val_478 478 +val_298 298 +val_125 125 +val_431 431 +val_164 164 +val_424 424 +val_187 187 +val_382 382 +val_5 5 +val_70 70 +val_397 397 +val_480 480 +val_291 291 +val_24 24 +val_351 351 +val_255 255 +val_104 104 +val_70 70 +val_163 163 +val_438 438 +val_119 119 +val_414 414 +val_200 200 +val_491 491 +val_237 237 +val_439 439 +val_360 360 +val_248 248 +val_479 479 +val_305 305 +val_417 417 +val_199 199 +val_444 444 +val_120 120 +val_429 429 +val_169 169 +val_443 443 +val_323 323 +val_325 325 +val_277 277 +val_230 230 +val_478 478 +val_178 178 +val_468 468 +val_310 310 +val_317 317 +val_333 333 +val_493 493 +val_460 460 +val_207 207 +val_249 249 +val_265 265 +val_480 480 +val_83 83 +val_136 136 +val_353 353 +val_172 172 +val_214 214 +val_462 462 +val_233 233 +val_406 406 +val_133 133 +val_175 175 +val_189 189 +val_454 454 +val_375 375 +val_401 401 +val_421 421 +val_407 407 +val_384 384 +val_256 256 +val_26 26 +val_134 134 +val_67 67 +val_384 384 +val_379 379 +val_18 18 +val_462 462 +val_492 492 +val_100 100 +val_298 298 +val_9 9 +val_341 341 +val_498 498 +val_146 146 +val_458 458 +val_362 362 +val_186 186 +val_285 285 +val_348 348 +val_167 167 +val_18 18 +val_273 273 +val_183 183 +val_281 281 +val_344 344 +val_97 97 +val_469 469 +val_315 315 +val_84 84 +val_28 28 +val_37 37 +val_448 448 +val_152 152 +val_348 348 +val_307 307 +val_194 194 +val_414 414 +val_477 477 +val_222 222 +val_126 126 +val_90 90 +val_169 169 +val_403 403 +val_400 400 +val_200 200 +val_97 97 http://git-wip-us.apache.org/repos/asf/hive/blob/22541610/ql/src/test/results/clientpositive/join0.q.java1.7.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join0.q.java1.7.out b/ql/src/test/results/clientpositive/join0.q.java1.7.out deleted file mode 100644 index 343f8a4..0000000 --- a/ql/src/test/results/clientpositive/join0.q.java1.7.out +++ /dev/null @@ -1,240 +0,0 @@ -Warning: Shuffle Join JOIN[8][tables = [src1, src2]] in Stage 'Stage-1:MAPRED' is a cross product -PREHOOK: query: -- JAVA_VERSION_SPECIFIC_OUTPUT --- SORT_QUERY_RESULTS - -EXPLAIN -SELECT src1.key as k1, src1.value as v1, - src2.key as k2, src2.value as v2 FROM - (SELECT * FROM src WHERE src.key < 10) src1 - JOIN - (SELECT * FROM src WHERE src.key < 10) src2 - SORT BY k1, v1, k2, v2 -PREHOOK: type: QUERY -POSTHOOK: query: -- JAVA_VERSION_SPECIFIC_OUTPUT --- SORT_QUERY_RESULTS - -EXPLAIN -SELECT src1.key as k1, src1.value as v1, - src2.key as k2, src2.value as v2 FROM - (SELECT * FROM src WHERE src.key < 10) src1 - JOIN - (SELECT * FROM src WHERE src.key < 10) src2 - SORT BY k1, v1, k2, v2 -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-2 depends on stages: Stage-1 - Stage-0 depends on stages: Stage-2 - -STAGE PLANS: - Stage: Stage-1 - Map Reduce - Map Operator Tree: - TableScan - alias: src - Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE - Filter Operator - predicate: (key < 10) (type: boolean) - Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: key (type: string), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - sort order: - Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: string), _col1 (type: string) - TableScan - alias: src - Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE - Filter Operator - predicate: (key < 10) (type: boolean) - Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: key (type: string), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - sort order: - Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: string), _col1 (type: string) - Reduce Operator Tree: - Join Operator - condition map: - Inner Join 0 to 1 - keys: - 0 - 1 - outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 182 Data size: 1939 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe - - Stage: Stage-2 - Map Reduce - Map Operator Tree: - TableScan - Reduce Output Operator - key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string) - sort order: ++++ - Statistics: Num rows: 182 Data size: 1939 Basic stats: COMPLETE Column stats: NONE - Reduce Operator Tree: - Select Operator - expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: string), KEY.reducesinkkey2 (type: string), KEY.reducesinkkey3 (type: string) - outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 182 Data size: 1939 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 182 Data size: 1939 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-0 - Fetch Operator - limit: -1 - Processor Tree: - ListSink - -Warning: Shuffle Join JOIN[8][tables = [src1, src2]] in Stage 'Stage-1:MAPRED' is a cross product -PREHOOK: query: EXPLAIN FORMATTED -SELECT src1.key as k1, src1.value as v1, - src2.key as k2, src2.value as v2 FROM - (SELECT * FROM src WHERE src.key < 10) src1 - JOIN - (SELECT * FROM src WHERE src.key < 10) src2 - SORT BY k1, v1, k2, v2 -PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN FORMATTED -SELECT src1.key as k1, src1.value as v1, - src2.key as k2, src2.value as v2 FROM - (SELECT * FROM src WHERE src.key < 10) src1 - JOIN - (SELECT * FROM src WHERE src.key < 10) src2 - SORT BY k1, v1, k2, v2 -POSTHOOK: type: QUERY -{"STAGE DEPENDENCIES":{"Stage-1":{"ROOT STAGE":"TRUE"},"Stage-2":{"DEPENDENT STAGES":"Stage-1"},"Stage-0":{"DEPENDENT STAGES":"Stage-2"}},"STAGE PLANS":{"Stage-1":{"Map Reduce":{"Map Operator Tree:":[{"TableScan":{"alias:":"src","Statistics:":"Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE","children":{"Filter Operator":{"predicate:":"(key < 10) (type: boolean)","Statistics:":"Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE","children":{"Select Operator":{"expressions:":"key (type: string), value (type: string)","outputColumnNames:":["_col0","_col1"],"Statistics:":"Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE","children":{"Reduce Output Operator":{"sort order:":"","Statistics:":"Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE","value expressions:":"_col0 (type: string), _col1 (type: string)"}}}}}}}},{"TableScan":{"alias:":"src","Statistics:":"Num rows: 500 Data size: 5312 Basic stats: COM PLETE Column stats: NONE","children":{"Filter Operator":{"predicate:":"(key < 10) (type: boolean)","Statistics:":"Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE","children":{"Select Operator":{"expressions:":"key (type: string), value (type: string)","outputColumnNames:":["_col0","_col1"],"Statistics:":"Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE","children":{"Reduce Output Operator":{"sort order:":"","Statistics:":"Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE","value expressions:":"_col0 (type: string), _col1 (type: string)"}}}}}}}}],"Reduce Operator Tree:":{"Join Operator":{"condition map:":[{"":"Inner Join 0 to 1"}],"keys:":{},"outputColumnNames:":["_col0","_col1","_col2","_col3"],"Statistics:":"Num rows: 182 Data size: 1939 Basic stats: COMPLETE Column stats: NONE","children":{"File Output Operator":{"compressed:":"false","table:":{"input format:":"org.apache.hadoop.mapred.SequenceFileInputFormat","outp ut format:":"org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat","serde:":"org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe"}}}}}}},"Stage-2":{"Map Reduce":{"Map Operator Tree:":[{"TableScan":{"children":{"Reduce Output Operator":{"key expressions:":"_col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string)","sort order:":"++++","Statistics:":"Num rows: 182 Data size: 1939 Basic stats: COMPLETE Column stats: NONE"}}}}],"Reduce Operator Tree:":{"Select Operator":{"expressions:":"KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: string), KEY.reducesinkkey2 (type: string), KEY.reducesinkkey3 (type: string)","outputColumnNames:":["_col0","_col1","_col2","_col3"],"Statistics:":"Num rows: 182 Data size: 1939 Basic stats: COMPLETE Column stats: NONE","children":{"File Output Operator":{"compressed:":"false","Statistics:":"Num rows: 182 Data size: 1939 Basic stats: COMPLETE Column stats: NONE","table:":{"input format:":"org.apache.hadoo p.mapred.SequenceFileInputFormat","output format:":"org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat","serde:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe"}}}}}}},"Stage-0":{"Fetch Operator":{"limit:":"-1","Processor Tree:":{"ListSink":{}}}}}} -Warning: Shuffle Join JOIN[8][tables = [src1, src2]] in Stage 'Stage-1:MAPRED' is a cross product -PREHOOK: query: SELECT src1.key as k1, src1.value as v1, - src2.key as k2, src2.value as v2 FROM - (SELECT * FROM src WHERE src.key < 10) src1 - JOIN - (SELECT * FROM src WHERE src.key < 10) src2 - SORT BY k1, v1, k2, v2 -PREHOOK: type: QUERY -PREHOOK: Input: default@src -#### A masked pattern was here #### -POSTHOOK: query: SELECT src1.key as k1, src1.value as v1, - src2.key as k2, src2.value as v2 FROM - (SELECT * FROM src WHERE src.key < 10) src1 - JOIN - (SELECT * FROM src WHERE src.key < 10) src2 - SORT BY k1, v1, k2, v2 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -#### A masked pattern was here #### -0 val_0 0 val_0 -0 val_0 0 val_0 -0 val_0 0 val_0 -0 val_0 0 val_0 -0 val_0 0 val_0 -0 val_0 0 val_0 -0 val_0 0 val_0 -0 val_0 0 val_0 -0 val_0 0 val_0 -0 val_0 2 val_2 -0 val_0 2 val_2 -0 val_0 2 val_2 -0 val_0 4 val_4 -0 val_0 4 val_4 -0 val_0 4 val_4 -0 val_0 5 val_5 -0 val_0 5 val_5 -0 val_0 5 val_5 -0 val_0 5 val_5 -0 val_0 5 val_5 -0 val_0 5 val_5 -0 val_0 5 val_5 -0 val_0 5 val_5 -0 val_0 5 val_5 -0 val_0 8 val_8 -0 val_0 8 val_8 -0 val_0 8 val_8 -0 val_0 9 val_9 -0 val_0 9 val_9 -0 val_0 9 val_9 -2 val_2 0 val_0 -2 val_2 0 val_0 -2 val_2 0 val_0 -2 val_2 2 val_2 -2 val_2 4 val_4 -2 val_2 5 val_5 -2 val_2 5 val_5 -2 val_2 5 val_5 -2 val_2 8 val_8 -2 val_2 9 val_9 -4 val_4 0 val_0 -4 val_4 0 val_0 -4 val_4 0 val_0 -4 val_4 2 val_2 -4 val_4 4 val_4 -4 val_4 5 val_5 -4 val_4 5 val_5 -4 val_4 5 val_5 -4 val_4 8 val_8 -4 val_4 9 val_9 -5 val_5 0 val_0 -5 val_5 0 val_0 -5 val_5 0 val_0 -5 val_5 0 val_0 -5 val_5 0 val_0 -5 val_5 0 val_0 -5 val_5 0 val_0 -5 val_5 0 val_0 -5 val_5 0 val_0 -5 val_5 2 val_2 -5 val_5 2 val_2 -5 val_5 2 val_2 -5 val_5 4 val_4 -5 val_5 4 val_4 -5 val_5 4 val_4 -5 val_5 5 val_5 -5 val_5 5 val_5 -5 val_5 5 val_5 -5 val_5 5 val_5 -5 val_5 5 val_5 -5 val_5 5 val_5 -5 val_5 5 val_5 -5 val_5 5 val_5 -5 val_5 5 val_5 -5 val_5 8 val_8 -5 val_5 8 val_8 -5 val_5 8 val_8 -5 val_5 9 val_9 -5 val_5 9 val_9 -5 val_5 9 val_9 -8 val_8 0 val_0 -8 val_8 0 val_0 -8 val_8 0 val_0 -8 val_8 2 val_2 -8 val_8 4 val_4 -8 val_8 5 val_5 -8 val_8 5 val_5 -8 val_8 5 val_5 -8 val_8 8 val_8 -8 val_8 9 val_9 -9 val_9 0 val_0 -9 val_9 0 val_0 -9 val_9 0 val_0 -9 val_9 2 val_2 -9 val_9 4 val_4 -9 val_9 5 val_5 -9 val_9 5 val_5 -9 val_9 5 val_5 -9 val_9 8 val_8 -9 val_9 9 val_9 http://git-wip-us.apache.org/repos/asf/hive/blob/22541610/ql/src/test/results/clientpositive/join0.q.java1.8.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/join0.q.java1.8.out b/ql/src/test/results/clientpositive/join0.q.java1.8.out deleted file mode 100644 index 343f8a4..0000000 --- a/ql/src/test/results/clientpositive/join0.q.java1.8.out +++ /dev/null @@ -1,240 +0,0 @@ -Warning: Shuffle Join JOIN[8][tables = [src1, src2]] in Stage 'Stage-1:MAPRED' is a cross product -PREHOOK: query: -- JAVA_VERSION_SPECIFIC_OUTPUT --- SORT_QUERY_RESULTS - -EXPLAIN -SELECT src1.key as k1, src1.value as v1, - src2.key as k2, src2.value as v2 FROM - (SELECT * FROM src WHERE src.key < 10) src1 - JOIN - (SELECT * FROM src WHERE src.key < 10) src2 - SORT BY k1, v1, k2, v2 -PREHOOK: type: QUERY -POSTHOOK: query: -- JAVA_VERSION_SPECIFIC_OUTPUT --- SORT_QUERY_RESULTS - -EXPLAIN -SELECT src1.key as k1, src1.value as v1, - src2.key as k2, src2.value as v2 FROM - (SELECT * FROM src WHERE src.key < 10) src1 - JOIN - (SELECT * FROM src WHERE src.key < 10) src2 - SORT BY k1, v1, k2, v2 -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-2 depends on stages: Stage-1 - Stage-0 depends on stages: Stage-2 - -STAGE PLANS: - Stage: Stage-1 - Map Reduce - Map Operator Tree: - TableScan - alias: src - Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE - Filter Operator - predicate: (key < 10) (type: boolean) - Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: key (type: string), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - sort order: - Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: string), _col1 (type: string) - TableScan - alias: src - Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE - Filter Operator - predicate: (key < 10) (type: boolean) - Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: key (type: string), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - sort order: - Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: string), _col1 (type: string) - Reduce Operator Tree: - Join Operator - condition map: - Inner Join 0 to 1 - keys: - 0 - 1 - outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 182 Data size: 1939 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe - - Stage: Stage-2 - Map Reduce - Map Operator Tree: - TableScan - Reduce Output Operator - key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string) - sort order: ++++ - Statistics: Num rows: 182 Data size: 1939 Basic stats: COMPLETE Column stats: NONE - Reduce Operator Tree: - Select Operator - expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: string), KEY.reducesinkkey2 (type: string), KEY.reducesinkkey3 (type: string) - outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 182 Data size: 1939 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 182 Data size: 1939 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-0 - Fetch Operator - limit: -1 - Processor Tree: - ListSink - -Warning: Shuffle Join JOIN[8][tables = [src1, src2]] in Stage 'Stage-1:MAPRED' is a cross product -PREHOOK: query: EXPLAIN FORMATTED -SELECT src1.key as k1, src1.value as v1, - src2.key as k2, src2.value as v2 FROM - (SELECT * FROM src WHERE src.key < 10) src1 - JOIN - (SELECT * FROM src WHERE src.key < 10) src2 - SORT BY k1, v1, k2, v2 -PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN FORMATTED -SELECT src1.key as k1, src1.value as v1, - src2.key as k2, src2.value as v2 FROM - (SELECT * FROM src WHERE src.key < 10) src1 - JOIN - (SELECT * FROM src WHERE src.key < 10) src2 - SORT BY k1, v1, k2, v2 -POSTHOOK: type: QUERY -{"STAGE DEPENDENCIES":{"Stage-1":{"ROOT STAGE":"TRUE"},"Stage-2":{"DEPENDENT STAGES":"Stage-1"},"Stage-0":{"DEPENDENT STAGES":"Stage-2"}},"STAGE PLANS":{"Stage-1":{"Map Reduce":{"Map Operator Tree:":[{"TableScan":{"alias:":"src","Statistics:":"Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE","children":{"Filter Operator":{"predicate:":"(key < 10) (type: boolean)","Statistics:":"Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE","children":{"Select Operator":{"expressions:":"key (type: string), value (type: string)","outputColumnNames:":["_col0","_col1"],"Statistics:":"Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE","children":{"Reduce Output Operator":{"sort order:":"","Statistics:":"Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE","value expressions:":"_col0 (type: string), _col1 (type: string)"}}}}}}}},{"TableScan":{"alias:":"src","Statistics:":"Num rows: 500 Data size: 5312 Basic stats: COM PLETE Column stats: NONE","children":{"Filter Operator":{"predicate:":"(key < 10) (type: boolean)","Statistics:":"Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE","children":{"Select Operator":{"expressions:":"key (type: string), value (type: string)","outputColumnNames:":["_col0","_col1"],"Statistics:":"Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE","children":{"Reduce Output Operator":{"sort order:":"","Statistics:":"Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE","value expressions:":"_col0 (type: string), _col1 (type: string)"}}}}}}}}],"Reduce Operator Tree:":{"Join Operator":{"condition map:":[{"":"Inner Join 0 to 1"}],"keys:":{},"outputColumnNames:":["_col0","_col1","_col2","_col3"],"Statistics:":"Num rows: 182 Data size: 1939 Basic stats: COMPLETE Column stats: NONE","children":{"File Output Operator":{"compressed:":"false","table:":{"input format:":"org.apache.hadoop.mapred.SequenceFileInputFormat","outp ut format:":"org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat","serde:":"org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe"}}}}}}},"Stage-2":{"Map Reduce":{"Map Operator Tree:":[{"TableScan":{"children":{"Reduce Output Operator":{"key expressions:":"_col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string)","sort order:":"++++","Statistics:":"Num rows: 182 Data size: 1939 Basic stats: COMPLETE Column stats: NONE"}}}}],"Reduce Operator Tree:":{"Select Operator":{"expressions:":"KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: string), KEY.reducesinkkey2 (type: string), KEY.reducesinkkey3 (type: string)","outputColumnNames:":["_col0","_col1","_col2","_col3"],"Statistics:":"Num rows: 182 Data size: 1939 Basic stats: COMPLETE Column stats: NONE","children":{"File Output Operator":{"compressed:":"false","Statistics:":"Num rows: 182 Data size: 1939 Basic stats: COMPLETE Column stats: NONE","table:":{"input format:":"org.apache.hadoo p.mapred.SequenceFileInputFormat","output format:":"org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat","serde:":"org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe"}}}}}}},"Stage-0":{"Fetch Operator":{"limit:":"-1","Processor Tree:":{"ListSink":{}}}}}} -Warning: Shuffle Join JOIN[8][tables = [src1, src2]] in Stage 'Stage-1:MAPRED' is a cross product -PREHOOK: query: SELECT src1.key as k1, src1.value as v1, - src2.key as k2, src2.value as v2 FROM - (SELECT * FROM src WHERE src.key < 10) src1 - JOIN - (SELECT * FROM src WHERE src.key < 10) src2 - SORT BY k1, v1, k2, v2 -PREHOOK: type: QUERY -PREHOOK: Input: default@src -#### A masked pattern was here #### -POSTHOOK: query: SELECT src1.key as k1, src1.value as v1, - src2.key as k2, src2.value as v2 FROM - (SELECT * FROM src WHERE src.key < 10) src1 - JOIN - (SELECT * FROM src WHERE src.key < 10) src2 - SORT BY k1, v1, k2, v2 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -#### A masked pattern was here #### -0 val_0 0 val_0 -0 val_0 0 val_0 -0 val_0 0 val_0 -0 val_0 0 val_0 -0 val_0 0 val_0 -0 val_0 0 val_0 -0 val_0 0 val_0 -0 val_0 0 val_0 -0 val_0 0 val_0 -0 val_0 2 val_2 -0 val_0 2 val_2 -0 val_0 2 val_2 -0 val_0 4 val_4 -0 val_0 4 val_4 -0 val_0 4 val_4 -0 val_0 5 val_5 -0 val_0 5 val_5 -0 val_0 5 val_5 -0 val_0 5 val_5 -0 val_0 5 val_5 -0 val_0 5 val_5 -0 val_0 5 val_5 -0 val_0 5 val_5 -0 val_0 5 val_5 -0 val_0 8 val_8 -0 val_0 8 val_8 -0 val_0 8 val_8 -0 val_0 9 val_9 -0 val_0 9 val_9 -0 val_0 9 val_9 -2 val_2 0 val_0 -2 val_2 0 val_0 -2 val_2 0 val_0 -2 val_2 2 val_2 -2 val_2 4 val_4 -2 val_2 5 val_5 -2 val_2 5 val_5 -2 val_2 5 val_5 -2 val_2 8 val_8 -2 val_2 9 val_9 -4 val_4 0 val_0 -4 val_4 0 val_0 -4 val_4 0 val_0 -4 val_4 2 val_2 -4 val_4 4 val_4 -4 val_4 5 val_5 -4 val_4 5 val_5 -4 val_4 5 val_5 -4 val_4 8 val_8 -4 val_4 9 val_9 -5 val_5 0 val_0 -5 val_5 0 val_0 -5 val_5 0 val_0 -5 val_5 0 val_0 -5 val_5 0 val_0 -5 val_5 0 val_0 -5 val_5 0 val_0 -5 val_5 0 val_0 -5 val_5 0 val_0 -5 val_5 2 val_2 -5 val_5 2 val_2 -5 val_5 2 val_2 -5 val_5 4 val_4 -5 val_5 4 val_4 -5 val_5 4 val_4 -5 val_5 5 val_5 -5 val_5 5 val_5 -5 val_5 5 val_5 -5 val_5 5 val_5 -5 val_5 5 val_5 -5 val_5 5 val_5 -5 val_5 5 val_5 -5 val_5 5 val_5 -5 val_5 5 val_5 -5 val_5 8 val_8 -5 val_5 8 val_8 -5 val_5 8 val_8 -5 val_5 9 val_9 -5 val_5 9 val_9 -5 val_5 9 val_9 -8 val_8 0 val_0 -8 val_8 0 val_0 -8 val_8 0 val_0 -8 val_8 2 val_2 -8 val_8 4 val_4 -8 val_8 5 val_5 -8 val_8 5 val_5 -8 val_8 5 val_5 -8 val_8 8 val_8 -8 val_8 9 val_9 -9 val_9 0 val_0 -9 val_9 0 val_0 -9 val_9 0 val_0 -9 val_9 2 val_2 -9 val_9 4 val_4 -9 val_9 5 val_5 -9 val_9 5 val_5 -9 val_9 5 val_5 -9 val_9 8 val_8 -9 val_9 9 val_9
