Repository: hive Updated Branches: refs/heads/branch-2.1 aaced2319 -> 0d21998e6
http://git-wip-us.apache.org/repos/asf/hive/blob/0d21998e/ql/src/test/results/clientpositive/varchar_udf1.q.java1.7.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/varchar_udf1.q.java1.7.out b/ql/src/test/results/clientpositive/varchar_udf1.q.java1.7.out deleted file mode 100644 index 459d93b..0000000 --- a/ql/src/test/results/clientpositive/varchar_udf1.q.java1.7.out +++ /dev/null @@ -1,457 +0,0 @@ -PREHOOK: query: drop table varchar_udf_1 -PREHOOK: type: DROPTABLE -POSTHOOK: query: drop table varchar_udf_1 -POSTHOOK: type: DROPTABLE -PREHOOK: query: create table varchar_udf_1 (c1 string, c2 string, c3 varchar(10), c4 varchar(20)) -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@varchar_udf_1 -POSTHOOK: query: create table varchar_udf_1 (c1 string, c2 string, c3 varchar(10), c4 varchar(20)) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@varchar_udf_1 -PREHOOK: query: insert overwrite table varchar_udf_1 - select key, value, key, value from src where key = '238' limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@src -PREHOOK: Output: default@varchar_udf_1 -POSTHOOK: query: insert overwrite table varchar_udf_1 - select key, value, key, value from src where key = '238' limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -POSTHOOK: Output: default@varchar_udf_1 -POSTHOOK: Lineage: varchar_udf_1.c1 SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: varchar_udf_1.c2 SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -POSTHOOK: Lineage: varchar_udf_1.c3 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: varchar_udf_1.c4 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: -- JAVA_VERSION_SPECIFIC_OUTPUT - --- UDFs with varchar support -select - concat(c1, c2), - concat(c3, c4), - concat(c1, c2) = concat(c3, c4) -from varchar_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: -- JAVA_VERSION_SPECIFIC_OUTPUT - --- UDFs with varchar support -select - concat(c1, c2), - concat(c3, c4), - concat(c1, c2) = concat(c3, c4) -from varchar_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -238val_238 238val_238 true -PREHOOK: query: select - upper(c2), - upper(c4), - upper(c2) = upper(c4) -from varchar_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - upper(c2), - upper(c4), - upper(c2) = upper(c4) -from varchar_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -VAL_238 VAL_238 true -PREHOOK: query: select - lower(c2), - lower(c4), - lower(c2) = lower(c4) -from varchar_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - lower(c2), - lower(c4), - lower(c2) = lower(c4) -from varchar_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_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 varchar_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: -- Scalar UDFs -select - ascii(c2), - ascii(c4), - ascii(c2) = ascii(c4) -from varchar_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_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 varchar_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_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 varchar_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_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 varchar_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_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 varchar_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -val_238 val_238 true -PREHOOK: query: select - instr(c2, '_'), - instr(c4, '_'), - instr(c2, '_') = instr(c4, '_') -from varchar_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - instr(c2, '_'), - instr(c4, '_'), - instr(c2, '_') = instr(c4, '_') -from varchar_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -4 4 true -PREHOOK: query: select - length(c2), - length(c4), - length(c2) = length(c4) -from varchar_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - length(c2), - length(c4), - length(c2) = length(c4) -from varchar_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -7 7 true -PREHOOK: query: select - locate('a', 'abcdabcd', 3), - locate(cast('a' as varchar(1)), cast('abcdabcd' as varchar(10)), 3), - locate('a', 'abcdabcd', 3) = locate(cast('a' as varchar(1)), cast('abcdabcd' as varchar(10)), 3) -from varchar_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - locate('a', 'abcdabcd', 3), - locate(cast('a' as varchar(1)), cast('abcdabcd' as varchar(10)), 3), - locate('a', 'abcdabcd', 3) = locate(cast('a' as varchar(1)), cast('abcdabcd' as varchar(10)), 3) -from varchar_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_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 varchar_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - lpad(c2, 15, ' '), - lpad(c4, 15, ' '), - lpad(c2, 15, ' ') = lpad(c4, 15, ' ') -from varchar_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### - val_238 val_238 true -PREHOOK: query: select - ltrim(c2), - ltrim(c4), - ltrim(c2) = ltrim(c4) -from varchar_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - ltrim(c2), - ltrim(c4), - ltrim(c2) = ltrim(c4) -from varchar_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -val_238 val_238 true -PREHOOK: query: select - c2 regexp 'val', - c4 regexp 'val', - (c2 regexp 'val') = (c4 regexp 'val') -from varchar_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - c2 regexp 'val', - c4 regexp 'val', - (c2 regexp 'val') = (c4 regexp 'val') -from varchar_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_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 varchar_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_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 varchar_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_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 varchar_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_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 varchar_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -replaced_238 replaced_238 true -PREHOOK: query: select - reverse(c2), - reverse(c4), - reverse(c2) = reverse(c4) -from varchar_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - reverse(c2), - reverse(c4), - reverse(c2) = reverse(c4) -from varchar_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_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 varchar_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - rpad(c2, 15, ' '), - rpad(c4, 15, ' '), - rpad(c2, 15, ' ') = rpad(c4, 15, ' ') -from varchar_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -val_238 val_238 true -PREHOOK: query: select - rtrim(c2), - rtrim(c4), - rtrim(c2) = rtrim(c4) -from varchar_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - rtrim(c2), - rtrim(c4), - rtrim(c2) = rtrim(c4) -from varchar_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_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 varchar(50))) -from varchar_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_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 varchar(50))) -from varchar_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_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 varchar_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - split(c2, '_'), - split(c4, '_') -from varchar_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_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 varchar(20)),',',':') -from varchar_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_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 varchar(20)),',',':') -from varchar_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -{"b":"2","a":"1","c":"3"} {"b":"2","a":"1","c":"3"} -PREHOOK: query: select - substr(c2, 1, 3), - substr(c4, 1, 3), - substr(c2, 1, 3) = substr(c4, 1, 3) -from varchar_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_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 varchar_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -val val true -PREHOOK: query: select - trim(c2), - trim(c4), - trim(c2) = trim(c4) -from varchar_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - trim(c2), - trim(c4), - trim(c2) = trim(c4) -from varchar_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_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 varchar_udf_1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: -- Aggregate Functions -select - compute_stats(c2, 16), - compute_stats(c4, 16) -from varchar_udf_1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_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 varchar_udf_1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - min(c2), - min(c4) -from varchar_udf_1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -val_238 val_238 -PREHOOK: query: select - max(c2), - max(c4) -from varchar_udf_1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - max(c2), - max(c4) -from varchar_udf_1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -val_238 val_238 -PREHOOK: query: drop table varchar_udf_1 -PREHOOK: type: DROPTABLE -PREHOOK: Input: default@varchar_udf_1 -PREHOOK: Output: default@varchar_udf_1 -POSTHOOK: query: drop table varchar_udf_1 -POSTHOOK: type: DROPTABLE -POSTHOOK: Input: default@varchar_udf_1 -POSTHOOK: Output: default@varchar_udf_1 http://git-wip-us.apache.org/repos/asf/hive/blob/0d21998e/ql/src/test/results/clientpositive/varchar_udf1.q.java1.8.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/varchar_udf1.q.java1.8.out b/ql/src/test/results/clientpositive/varchar_udf1.q.java1.8.out deleted file mode 100644 index ace8568..0000000 --- a/ql/src/test/results/clientpositive/varchar_udf1.q.java1.8.out +++ /dev/null @@ -1,457 +0,0 @@ -PREHOOK: query: drop table varchar_udf_1 -PREHOOK: type: DROPTABLE -POSTHOOK: query: drop table varchar_udf_1 -POSTHOOK: type: DROPTABLE -PREHOOK: query: create table varchar_udf_1 (c1 string, c2 string, c3 varchar(10), c4 varchar(20)) -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@varchar_udf_1 -POSTHOOK: query: create table varchar_udf_1 (c1 string, c2 string, c3 varchar(10), c4 varchar(20)) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@varchar_udf_1 -PREHOOK: query: insert overwrite table varchar_udf_1 - select key, value, key, value from src where key = '238' limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@src -PREHOOK: Output: default@varchar_udf_1 -POSTHOOK: query: insert overwrite table varchar_udf_1 - select key, value, key, value from src where key = '238' limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -POSTHOOK: Output: default@varchar_udf_1 -POSTHOOK: Lineage: varchar_udf_1.c1 SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: varchar_udf_1.c2 SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -POSTHOOK: Lineage: varchar_udf_1.c3 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: varchar_udf_1.c4 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: -- JAVA_VERSION_SPECIFIC_OUTPUT - --- UDFs with varchar support -select - concat(c1, c2), - concat(c3, c4), - concat(c1, c2) = concat(c3, c4) -from varchar_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: -- JAVA_VERSION_SPECIFIC_OUTPUT - --- UDFs with varchar support -select - concat(c1, c2), - concat(c3, c4), - concat(c1, c2) = concat(c3, c4) -from varchar_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -238val_238 238val_238 true -PREHOOK: query: select - upper(c2), - upper(c4), - upper(c2) = upper(c4) -from varchar_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - upper(c2), - upper(c4), - upper(c2) = upper(c4) -from varchar_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -VAL_238 VAL_238 true -PREHOOK: query: select - lower(c2), - lower(c4), - lower(c2) = lower(c4) -from varchar_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - lower(c2), - lower(c4), - lower(c2) = lower(c4) -from varchar_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_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 varchar_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: -- Scalar UDFs -select - ascii(c2), - ascii(c4), - ascii(c2) = ascii(c4) -from varchar_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_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 varchar_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_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 varchar_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_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 varchar_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_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 varchar_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -val_238 val_238 true -PREHOOK: query: select - instr(c2, '_'), - instr(c4, '_'), - instr(c2, '_') = instr(c4, '_') -from varchar_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - instr(c2, '_'), - instr(c4, '_'), - instr(c2, '_') = instr(c4, '_') -from varchar_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -4 4 true -PREHOOK: query: select - length(c2), - length(c4), - length(c2) = length(c4) -from varchar_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - length(c2), - length(c4), - length(c2) = length(c4) -from varchar_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -7 7 true -PREHOOK: query: select - locate('a', 'abcdabcd', 3), - locate(cast('a' as varchar(1)), cast('abcdabcd' as varchar(10)), 3), - locate('a', 'abcdabcd', 3) = locate(cast('a' as varchar(1)), cast('abcdabcd' as varchar(10)), 3) -from varchar_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - locate('a', 'abcdabcd', 3), - locate(cast('a' as varchar(1)), cast('abcdabcd' as varchar(10)), 3), - locate('a', 'abcdabcd', 3) = locate(cast('a' as varchar(1)), cast('abcdabcd' as varchar(10)), 3) -from varchar_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_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 varchar_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - lpad(c2, 15, ' '), - lpad(c4, 15, ' '), - lpad(c2, 15, ' ') = lpad(c4, 15, ' ') -from varchar_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### - val_238 val_238 true -PREHOOK: query: select - ltrim(c2), - ltrim(c4), - ltrim(c2) = ltrim(c4) -from varchar_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - ltrim(c2), - ltrim(c4), - ltrim(c2) = ltrim(c4) -from varchar_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_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 varchar_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - regexp(c2, 'val'), - regexp(c4, 'val'), - regexp(c2, 'val') = regexp(c4, 'val') -from varchar_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_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 varchar_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_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 varchar_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_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 varchar_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_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 varchar_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -replaced_238 replaced_238 true -PREHOOK: query: select - reverse(c2), - reverse(c4), - reverse(c2) = reverse(c4) -from varchar_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - reverse(c2), - reverse(c4), - reverse(c2) = reverse(c4) -from varchar_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_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 varchar_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - rpad(c2, 15, ' '), - rpad(c4, 15, ' '), - rpad(c2, 15, ' ') = rpad(c4, 15, ' ') -from varchar_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -val_238 val_238 true -PREHOOK: query: select - rtrim(c2), - rtrim(c4), - rtrim(c2) = rtrim(c4) -from varchar_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - rtrim(c2), - rtrim(c4), - rtrim(c2) = rtrim(c4) -from varchar_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_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 varchar(50))) -from varchar_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_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 varchar(50))) -from varchar_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_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 varchar_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - split(c2, '_'), - split(c4, '_') -from varchar_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_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 varchar(20)),',',':') -from varchar_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_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 varchar(20)),',',':') -from varchar_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_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 varchar_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_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 varchar_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -val val true -PREHOOK: query: select - trim(c2), - trim(c4), - trim(c2) = trim(c4) -from varchar_udf_1 limit 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - trim(c2), - trim(c4), - trim(c2) = trim(c4) -from varchar_udf_1 limit 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_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 varchar_udf_1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: -- Aggregate Functions -select - compute_stats(c2, 16), - compute_stats(c4, 16) -from varchar_udf_1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_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 varchar_udf_1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - min(c2), - min(c4) -from varchar_udf_1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -val_238 val_238 -PREHOOK: query: select - max(c2), - max(c4) -from varchar_udf_1 -PREHOOK: type: QUERY -PREHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -POSTHOOK: query: select - max(c2), - max(c4) -from varchar_udf_1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@varchar_udf_1 -#### A masked pattern was here #### -val_238 val_238 -PREHOOK: query: drop table varchar_udf_1 -PREHOOK: type: DROPTABLE -PREHOOK: Input: default@varchar_udf_1 -PREHOOK: Output: default@varchar_udf_1 -POSTHOOK: query: drop table varchar_udf_1 -POSTHOOK: type: DROPTABLE -POSTHOOK: Input: default@varchar_udf_1 -POSTHOOK: Output: default@varchar_udf_1 http://git-wip-us.apache.org/repos/asf/hive/blob/0d21998e/ql/src/test/results/clientpositive/varchar_udf1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/varchar_udf1.q.out b/ql/src/test/results/clientpositive/varchar_udf1.q.out new file mode 100644 index 0000000..e5cfce5 --- /dev/null +++ b/ql/src/test/results/clientpositive/varchar_udf1.q.out @@ -0,0 +1,453 @@ +PREHOOK: query: drop table varchar_udf_1 +PREHOOK: type: DROPTABLE +POSTHOOK: query: drop table varchar_udf_1 +POSTHOOK: type: DROPTABLE +PREHOOK: query: create table varchar_udf_1 (c1 string, c2 string, c3 varchar(10), c4 varchar(20)) +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@varchar_udf_1 +POSTHOOK: query: create table varchar_udf_1 (c1 string, c2 string, c3 varchar(10), c4 varchar(20)) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@varchar_udf_1 +PREHOOK: query: insert overwrite table varchar_udf_1 + select key, value, key, value from src where key = '238' limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@src +PREHOOK: Output: default@varchar_udf_1 +POSTHOOK: query: insert overwrite table varchar_udf_1 + select key, value, key, value from src where key = '238' limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@src +POSTHOOK: Output: default@varchar_udf_1 +POSTHOOK: Lineage: varchar_udf_1.c1 SIMPLE [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: varchar_udf_1.c2 SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] +POSTHOOK: Lineage: varchar_udf_1.c3 EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] +POSTHOOK: Lineage: varchar_udf_1.c4 EXPRESSION [(src)src.FieldSchema(name:value, type:string, comment:default), ] +PREHOOK: query: -- UDFs with varchar support +select + concat(c1, c2), + concat(c3, c4), + concat(c1, c2) = concat(c3, c4) +from varchar_udf_1 limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1 +#### A masked pattern was here #### +POSTHOOK: query: -- UDFs with varchar support +select + concat(c1, c2), + concat(c3, c4), + concat(c1, c2) = concat(c3, c4) +from varchar_udf_1 limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_udf_1 +#### A masked pattern was here #### +238val_238 238val_238 true +PREHOOK: query: select + upper(c2), + upper(c4), + upper(c2) = upper(c4) +from varchar_udf_1 limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1 +#### A masked pattern was here #### +POSTHOOK: query: select + upper(c2), + upper(c4), + upper(c2) = upper(c4) +from varchar_udf_1 limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_udf_1 +#### A masked pattern was here #### +VAL_238 VAL_238 true +PREHOOK: query: select + lower(c2), + lower(c4), + lower(c2) = lower(c4) +from varchar_udf_1 limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1 +#### A masked pattern was here #### +POSTHOOK: query: select + lower(c2), + lower(c4), + lower(c2) = lower(c4) +from varchar_udf_1 limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_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 varchar_udf_1 limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1 +#### A masked pattern was here #### +POSTHOOK: query: -- Scalar UDFs +select + ascii(c2), + ascii(c4), + ascii(c2) = ascii(c4) +from varchar_udf_1 limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_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 varchar_udf_1 limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_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 varchar_udf_1 limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_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 varchar_udf_1 limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_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 varchar_udf_1 limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_udf_1 +#### A masked pattern was here #### +val_238 val_238 true +PREHOOK: query: select + instr(c2, '_'), + instr(c4, '_'), + instr(c2, '_') = instr(c4, '_') +from varchar_udf_1 limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1 +#### A masked pattern was here #### +POSTHOOK: query: select + instr(c2, '_'), + instr(c4, '_'), + instr(c2, '_') = instr(c4, '_') +from varchar_udf_1 limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_udf_1 +#### A masked pattern was here #### +4 4 true +PREHOOK: query: select + length(c2), + length(c4), + length(c2) = length(c4) +from varchar_udf_1 limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1 +#### A masked pattern was here #### +POSTHOOK: query: select + length(c2), + length(c4), + length(c2) = length(c4) +from varchar_udf_1 limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_udf_1 +#### A masked pattern was here #### +7 7 true +PREHOOK: query: select + locate('a', 'abcdabcd', 3), + locate(cast('a' as varchar(1)), cast('abcdabcd' as varchar(10)), 3), + locate('a', 'abcdabcd', 3) = locate(cast('a' as varchar(1)), cast('abcdabcd' as varchar(10)), 3) +from varchar_udf_1 limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1 +#### A masked pattern was here #### +POSTHOOK: query: select + locate('a', 'abcdabcd', 3), + locate(cast('a' as varchar(1)), cast('abcdabcd' as varchar(10)), 3), + locate('a', 'abcdabcd', 3) = locate(cast('a' as varchar(1)), cast('abcdabcd' as varchar(10)), 3) +from varchar_udf_1 limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_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 varchar_udf_1 limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1 +#### A masked pattern was here #### +POSTHOOK: query: select + lpad(c2, 15, ' '), + lpad(c4, 15, ' '), + lpad(c2, 15, ' ') = lpad(c4, 15, ' ') +from varchar_udf_1 limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_udf_1 +#### A masked pattern was here #### + val_238 val_238 true +PREHOOK: query: select + ltrim(c2), + ltrim(c4), + ltrim(c2) = ltrim(c4) +from varchar_udf_1 limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1 +#### A masked pattern was here #### +POSTHOOK: query: select + ltrim(c2), + ltrim(c4), + ltrim(c2) = ltrim(c4) +from varchar_udf_1 limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_udf_1 +#### A masked pattern was here #### +val_238 val_238 true +PREHOOK: query: select + c2 regexp 'val', + c4 regexp 'val', + (c2 regexp 'val') = (c4 regexp 'val') +from varchar_udf_1 limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1 +#### A masked pattern was here #### +POSTHOOK: query: select + c2 regexp 'val', + c4 regexp 'val', + (c2 regexp 'val') = (c4 regexp 'val') +from varchar_udf_1 limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_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 varchar_udf_1 limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_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 varchar_udf_1 limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_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 varchar_udf_1 limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_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 varchar_udf_1 limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_udf_1 +#### A masked pattern was here #### +replaced_238 replaced_238 true +PREHOOK: query: select + reverse(c2), + reverse(c4), + reverse(c2) = reverse(c4) +from varchar_udf_1 limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1 +#### A masked pattern was here #### +POSTHOOK: query: select + reverse(c2), + reverse(c4), + reverse(c2) = reverse(c4) +from varchar_udf_1 limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_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 varchar_udf_1 limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1 +#### A masked pattern was here #### +POSTHOOK: query: select + rpad(c2, 15, ' '), + rpad(c4, 15, ' '), + rpad(c2, 15, ' ') = rpad(c4, 15, ' ') +from varchar_udf_1 limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_udf_1 +#### A masked pattern was here #### +val_238 val_238 true +PREHOOK: query: select + rtrim(c2), + rtrim(c4), + rtrim(c2) = rtrim(c4) +from varchar_udf_1 limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1 +#### A masked pattern was here #### +POSTHOOK: query: select + rtrim(c2), + rtrim(c4), + rtrim(c2) = rtrim(c4) +from varchar_udf_1 limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_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 varchar(50))) +from varchar_udf_1 limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_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 varchar(50))) +from varchar_udf_1 limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_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 varchar_udf_1 limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1 +#### A masked pattern was here #### +POSTHOOK: query: select + split(c2, '_'), + split(c4, '_') +from varchar_udf_1 limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_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 varchar(20)),',',':') +from varchar_udf_1 limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_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 varchar(20)),',',':') +from varchar_udf_1 limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_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 varchar_udf_1 limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_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 varchar_udf_1 limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_udf_1 +#### A masked pattern was here #### +val val true +PREHOOK: query: select + trim(c2), + trim(c4), + trim(c2) = trim(c4) +from varchar_udf_1 limit 1 +PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1 +#### A masked pattern was here #### +POSTHOOK: query: select + trim(c2), + trim(c4), + trim(c2) = trim(c4) +from varchar_udf_1 limit 1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_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 varchar_udf_1 +PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1 +#### A masked pattern was here #### +POSTHOOK: query: -- Aggregate Functions +select + compute_stats(c2, 16), + compute_stats(c4, 16) +from varchar_udf_1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_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 varchar_udf_1 +PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1 +#### A masked pattern was here #### +POSTHOOK: query: select + min(c2), + min(c4) +from varchar_udf_1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_udf_1 +#### A masked pattern was here #### +val_238 val_238 +PREHOOK: query: select + max(c2), + max(c4) +from varchar_udf_1 +PREHOOK: type: QUERY +PREHOOK: Input: default@varchar_udf_1 +#### A masked pattern was here #### +POSTHOOK: query: select + max(c2), + max(c4) +from varchar_udf_1 +POSTHOOK: type: QUERY +POSTHOOK: Input: default@varchar_udf_1 +#### A masked pattern was here #### +val_238 val_238 +PREHOOK: query: drop table varchar_udf_1 +PREHOOK: type: DROPTABLE +PREHOOK: Input: default@varchar_udf_1 +PREHOOK: Output: default@varchar_udf_1 +POSTHOOK: query: drop table varchar_udf_1 +POSTHOOK: type: DROPTABLE +POSTHOOK: Input: default@varchar_udf_1 +POSTHOOK: Output: default@varchar_udf_1 http://git-wip-us.apache.org/repos/asf/hive/blob/0d21998e/ql/src/test/results/clientpositive/vector_cast_constant.q.java1.7.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_cast_constant.q.java1.7.out b/ql/src/test/results/clientpositive/vector_cast_constant.q.java1.7.out deleted file mode 100644 index 867dd4c..0000000 --- a/ql/src/test/results/clientpositive/vector_cast_constant.q.java1.7.out +++ /dev/null @@ -1,220 +0,0 @@ -PREHOOK: query: -- JAVA_VERSION_SPECIFIC_OUTPUT - -DROP TABLE over1k -PREHOOK: type: DROPTABLE -POSTHOOK: query: -- JAVA_VERSION_SPECIFIC_OUTPUT - -DROP TABLE over1k -POSTHOOK: type: DROPTABLE -PREHOOK: query: DROP TABLE over1korc -PREHOOK: type: DROPTABLE -POSTHOOK: query: DROP TABLE over1korc -POSTHOOK: type: DROPTABLE -PREHOOK: query: -- data setup -CREATE TABLE over1k(t tinyint, - si smallint, - i int, - b bigint, - f float, - d double, - bo boolean, - s string, - ts timestamp, - dec decimal(4,2), - bin binary) -ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' -STORED AS TEXTFILE -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@over1k -POSTHOOK: query: -- data setup -CREATE TABLE over1k(t tinyint, - si smallint, - i int, - b bigint, - f float, - d double, - bo boolean, - s string, - ts timestamp, - dec decimal(4,2), - bin binary) -ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' -STORED AS TEXTFILE -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@over1k -PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/over1k' OVERWRITE INTO TABLE over1k -PREHOOK: type: LOAD -#### A masked pattern was here #### -PREHOOK: Output: default@over1k -POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/over1k' OVERWRITE INTO TABLE over1k -POSTHOOK: type: LOAD -#### A masked pattern was here #### -POSTHOOK: Output: default@over1k -PREHOOK: query: CREATE TABLE over1korc(t tinyint, - si smallint, - i int, - b bigint, - f float, - d double, - bo boolean, - s string, - ts timestamp, - dec decimal(4,2), - bin binary) -STORED AS ORC -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@over1korc -POSTHOOK: query: CREATE TABLE over1korc(t tinyint, - si smallint, - i int, - b bigint, - f float, - d double, - bo boolean, - s string, - ts timestamp, - dec decimal(4,2), - bin binary) -STORED AS ORC -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@over1korc -PREHOOK: query: INSERT INTO TABLE over1korc SELECT * FROM over1k -PREHOOK: type: QUERY -PREHOOK: Input: default@over1k -PREHOOK: Output: default@over1korc -POSTHOOK: query: INSERT INTO TABLE over1korc SELECT * FROM over1k -POSTHOOK: type: QUERY -POSTHOOK: Input: default@over1k -POSTHOOK: Output: default@over1korc -POSTHOOK: Lineage: over1korc.b SIMPLE [(over1k)over1k.FieldSchema(name:b, type:bigint, comment:null), ] -POSTHOOK: Lineage: over1korc.bin SIMPLE [(over1k)over1k.FieldSchema(name:bin, type:binary, comment:null), ] -POSTHOOK: Lineage: over1korc.bo SIMPLE [(over1k)over1k.FieldSchema(name:bo, type:boolean, comment:null), ] -POSTHOOK: Lineage: over1korc.d SIMPLE [(over1k)over1k.FieldSchema(name:d, type:double, comment:null), ] -POSTHOOK: Lineage: over1korc.dec SIMPLE [(over1k)over1k.FieldSchema(name:dec, type:decimal(4,2), comment:null), ] -POSTHOOK: Lineage: over1korc.f SIMPLE [(over1k)over1k.FieldSchema(name:f, type:float, comment:null), ] -POSTHOOK: Lineage: over1korc.i SIMPLE [(over1k)over1k.FieldSchema(name:i, type:int, comment:null), ] -POSTHOOK: Lineage: over1korc.s SIMPLE [(over1k)over1k.FieldSchema(name:s, type:string, comment:null), ] -POSTHOOK: Lineage: over1korc.si SIMPLE [(over1k)over1k.FieldSchema(name:si, type:smallint, comment:null), ] -POSTHOOK: Lineage: over1korc.t SIMPLE [(over1k)over1k.FieldSchema(name:t, type:tinyint, comment:null), ] -POSTHOOK: Lineage: over1korc.ts SIMPLE [(over1k)over1k.FieldSchema(name:ts, type:timestamp, comment:null), ] -PREHOOK: query: EXPLAIN SELECT - i, - AVG(CAST(50 AS INT)) AS `avg_int_ok`, - AVG(CAST(50 AS DOUBLE)) AS `avg_double_ok`, - AVG(CAST(50 AS DECIMAL)) AS `avg_decimal_ok` - FROM over1korc GROUP BY i ORDER BY i LIMIT 10 -PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN SELECT - i, - AVG(CAST(50 AS INT)) AS `avg_int_ok`, - AVG(CAST(50 AS DOUBLE)) AS `avg_double_ok`, - AVG(CAST(50 AS DECIMAL)) AS `avg_decimal_ok` - FROM over1korc GROUP BY i ORDER BY i LIMIT 10 -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: over1korc - Statistics: Num rows: 1049 Data size: 311170 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: i (type: int) - outputColumnNames: _col0 - Statistics: Num rows: 1049 Data size: 311170 Basic stats: COMPLETE Column stats: NONE - Group By Operator - aggregations: avg(50), avg(50.0), avg(50) - keys: _col0 (type: int) - mode: hash - outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 1049 Data size: 311170 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col0 (type: int) - sort order: + - Map-reduce partition columns: _col0 (type: int) - Statistics: Num rows: 1049 Data size: 311170 Basic stats: COMPLETE Column stats: NONE - value expressions: _col1 (type: struct<count:bigint,sum:double,input:int>), _col2 (type: struct<count:bigint,sum:double,input:double>), _col3 (type: struct<count:bigint,sum:decimal(12,0),input:decimal(10,0)>) - Execution mode: vectorized - Reduce Operator Tree: - Group By Operator - aggregations: avg(VALUE._col0), avg(VALUE._col1), avg(VALUE._col2) - keys: KEY._col0 (type: int) - mode: mergepartial - outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 524 Data size: 155436 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: int) - sort order: + - Statistics: Num rows: 524 Data size: 155436 Basic stats: COMPLETE Column stats: NONE - TopN Hash Memory Usage: 0.1 - value expressions: _col1 (type: double), _col2 (type: double), _col3 (type: decimal(14,4)) - Reduce Operator Tree: - Select Operator - expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: double), VALUE._col1 (type: double), VALUE._col2 (type: decimal(14,4)) - outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 524 Data size: 155436 Basic stats: COMPLETE Column stats: NONE - Limit - Number of rows: 10 - Statistics: Num rows: 10 Data size: 2960 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 10 Data size: 2960 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: 10 - Processor Tree: - ListSink - -PREHOOK: query: SELECT - i, - AVG(CAST(50 AS INT)) AS `avg_int_ok`, - AVG(CAST(50 AS DOUBLE)) AS `avg_double_ok`, - AVG(CAST(50 AS DECIMAL)) AS `avg_decimal_ok` - FROM over1korc GROUP BY i ORDER BY i LIMIT 10 -PREHOOK: type: QUERY -PREHOOK: Input: default@over1korc -#### A masked pattern was here #### -POSTHOOK: query: SELECT - i, - AVG(CAST(50 AS INT)) AS `avg_int_ok`, - AVG(CAST(50 AS DOUBLE)) AS `avg_double_ok`, - AVG(CAST(50 AS DECIMAL)) AS `avg_decimal_ok` - FROM over1korc GROUP BY i ORDER BY i LIMIT 10 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@over1korc -#### A masked pattern was here #### -65536 50.0 50.0 50.0000 -65537 50.0 50.0 50.0000 -65538 50.0 50.0 50.0000 -65539 50.0 50.0 50.0000 -65540 50.0 50.0 50.0000 -65541 50.0 50.0 50.0000 -65542 50.0 50.0 50.0000 -65543 50.0 50.0 50.0000 -65544 50.0 50.0 50.0000 -65545 50.0 50.0 50.0000 http://git-wip-us.apache.org/repos/asf/hive/blob/0d21998e/ql/src/test/results/clientpositive/vector_cast_constant.q.java1.8.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_cast_constant.q.java1.8.out b/ql/src/test/results/clientpositive/vector_cast_constant.q.java1.8.out deleted file mode 100644 index 789e6c2..0000000 --- a/ql/src/test/results/clientpositive/vector_cast_constant.q.java1.8.out +++ /dev/null @@ -1,197 +0,0 @@ -PREHOOK: query: -- JAVA_VERSION_SPECIFIC_OUTPUT - -DROP TABLE over1k -PREHOOK: type: DROPTABLE -POSTHOOK: query: -- JAVA_VERSION_SPECIFIC_OUTPUT - -DROP TABLE over1k -POSTHOOK: type: DROPTABLE -PREHOOK: query: DROP TABLE over1korc -PREHOOK: type: DROPTABLE -POSTHOOK: query: DROP TABLE over1korc -POSTHOOK: type: DROPTABLE -PREHOOK: query: -- data setup -CREATE TABLE over1k(t tinyint, - si smallint, - i int, - b bigint, - f float, - d double, - bo boolean, - s string, - ts timestamp, - dec decimal(4,2), - bin binary) -ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' -STORED AS TEXTFILE -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@over1k -POSTHOOK: query: -- data setup -CREATE TABLE over1k(t tinyint, - si smallint, - i int, - b bigint, - f float, - d double, - bo boolean, - s string, - ts timestamp, - dec decimal(4,2), - bin binary) -ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' -STORED AS TEXTFILE -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@over1k -PREHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/over1k' OVERWRITE INTO TABLE over1k -PREHOOK: type: LOAD -#### A masked pattern was here #### -PREHOOK: Output: default@over1k -POSTHOOK: query: LOAD DATA LOCAL INPATH '../../data/files/over1k' OVERWRITE INTO TABLE over1k -POSTHOOK: type: LOAD -#### A masked pattern was here #### -POSTHOOK: Output: default@over1k -PREHOOK: query: CREATE TABLE over1korc(t tinyint, - si smallint, - i int, - b bigint, - f float, - d double, - bo boolean, - s string, - ts timestamp, - dec decimal(4,2), - bin binary) -STORED AS ORC -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@over1korc -POSTHOOK: query: CREATE TABLE over1korc(t tinyint, - si smallint, - i int, - b bigint, - f float, - d double, - bo boolean, - s string, - ts timestamp, - dec decimal(4,2), - bin binary) -STORED AS ORC -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@over1korc -PREHOOK: query: INSERT INTO TABLE over1korc SELECT * FROM over1k -PREHOOK: type: QUERY -PREHOOK: Input: default@over1k -PREHOOK: Output: default@over1korc -POSTHOOK: query: INSERT INTO TABLE over1korc SELECT * FROM over1k -POSTHOOK: type: QUERY -POSTHOOK: Input: default@over1k -POSTHOOK: Output: default@over1korc -POSTHOOK: Lineage: over1korc.b SIMPLE [(over1k)over1k.FieldSchema(name:b, type:bigint, comment:null), ] -POSTHOOK: Lineage: over1korc.bin SIMPLE [(over1k)over1k.FieldSchema(name:bin, type:binary, comment:null), ] -POSTHOOK: Lineage: over1korc.bo SIMPLE [(over1k)over1k.FieldSchema(name:bo, type:boolean, comment:null), ] -POSTHOOK: Lineage: over1korc.d SIMPLE [(over1k)over1k.FieldSchema(name:d, type:double, comment:null), ] -POSTHOOK: Lineage: over1korc.dec SIMPLE [(over1k)over1k.FieldSchema(name:dec, type:decimal(4,2), comment:null), ] -POSTHOOK: Lineage: over1korc.f SIMPLE [(over1k)over1k.FieldSchema(name:f, type:float, comment:null), ] -POSTHOOK: Lineage: over1korc.i SIMPLE [(over1k)over1k.FieldSchema(name:i, type:int, comment:null), ] -POSTHOOK: Lineage: over1korc.s SIMPLE [(over1k)over1k.FieldSchema(name:s, type:string, comment:null), ] -POSTHOOK: Lineage: over1korc.si SIMPLE [(over1k)over1k.FieldSchema(name:si, type:smallint, comment:null), ] -POSTHOOK: Lineage: over1korc.t SIMPLE [(over1k)over1k.FieldSchema(name:t, type:tinyint, comment:null), ] -POSTHOOK: Lineage: over1korc.ts SIMPLE [(over1k)over1k.FieldSchema(name:ts, type:timestamp, comment:null), ] -PREHOOK: query: EXPLAIN SELECT - i, - AVG(CAST(50 AS INT)) AS `avg_int_ok`, - AVG(CAST(50 AS DOUBLE)) AS `avg_double_ok`, - AVG(CAST(50 AS DECIMAL)) AS `avg_decimal_ok` - FROM over1korc GROUP BY i LIMIT 10 -PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN SELECT - i, - AVG(CAST(50 AS INT)) AS `avg_int_ok`, - AVG(CAST(50 AS DOUBLE)) AS `avg_double_ok`, - AVG(CAST(50 AS DECIMAL)) AS `avg_decimal_ok` - FROM over1korc GROUP BY i LIMIT 10 -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-0 depends on stages: Stage-1 - -STAGE PLANS: - Stage: Stage-1 - Map Reduce - Map Operator Tree: - TableScan - alias: over1korc - Statistics: Num rows: 1049 Data size: 311170 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: i (type: int) - outputColumnNames: _col0 - Statistics: Num rows: 1049 Data size: 311170 Basic stats: COMPLETE Column stats: NONE - Group By Operator - aggregations: avg(50), avg(50.0), avg(50) - keys: _col0 (type: int) - mode: hash - outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 1049 Data size: 311170 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col0 (type: int) - sort order: + - Map-reduce partition columns: _col0 (type: int) - Statistics: Num rows: 1049 Data size: 311170 Basic stats: COMPLETE Column stats: NONE - value expressions: _col1 (type: struct<count:bigint,sum:double,input:int>), _col2 (type: struct<count:bigint,sum:double,input:double>), _col3 (type: struct<count:bigint,sum:decimal(12,0),input:decimal(10,0)>) - Execution mode: vectorized - Reduce Operator Tree: - Group By Operator - aggregations: avg(VALUE._col0), avg(VALUE._col1), avg(VALUE._col2) - keys: KEY._col0 (type: int) - mode: mergepartial - outputColumnNames: _col0, _col1, _col2, _col3 - Statistics: Num rows: 524 Data size: 155436 Basic stats: COMPLETE Column stats: NONE - Limit - Number of rows: 10 - Statistics: Num rows: 10 Data size: 2960 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 10 Data size: 2960 Basic stats: COMPLETE Column stats: NONE - 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 - - Stage: Stage-0 - Fetch Operator - limit: 10 - Processor Tree: - ListSink - -PREHOOK: query: SELECT - i, - AVG(CAST(50 AS INT)) AS `avg_int_ok`, - AVG(CAST(50 AS DOUBLE)) AS `avg_double_ok`, - AVG(CAST(50 AS DECIMAL)) AS `avg_decimal_ok` - FROM over1korc GROUP BY i LIMIT 10 -PREHOOK: type: QUERY -PREHOOK: Input: default@over1korc -#### A masked pattern was here #### -POSTHOOK: query: SELECT - i, - AVG(CAST(50 AS INT)) AS `avg_int_ok`, - AVG(CAST(50 AS DOUBLE)) AS `avg_double_ok`, - AVG(CAST(50 AS DECIMAL)) AS `avg_decimal_ok` - FROM over1korc GROUP BY i LIMIT 10 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@over1korc -#### A masked pattern was here #### -65536 50.0 50.0 50 -65537 50.0 50.0 50 -65538 50.0 50.0 50 -65539 50.0 50.0 50 -65540 50.0 50.0 50 -65541 50.0 50.0 50 -65542 50.0 50.0 50 -65543 50.0 50.0 50 -65544 50.0 50.0 50 -65545 50.0 50.0 50 http://git-wip-us.apache.org/repos/asf/hive/blob/0d21998e/ql/src/test/results/clientpositive/vector_cast_constant.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/vector_cast_constant.q.out b/ql/src/test/results/clientpositive/vector_cast_constant.q.out index 9fa36a4..5cd8085 100644 --- a/ql/src/test/results/clientpositive/vector_cast_constant.q.out +++ b/ql/src/test/results/clientpositive/vector_cast_constant.q.out @@ -102,18 +102,19 @@ PREHOOK: query: EXPLAIN SELECT AVG(CAST(50 AS INT)) AS `avg_int_ok`, AVG(CAST(50 AS DOUBLE)) AS `avg_double_ok`, AVG(CAST(50 AS DECIMAL)) AS `avg_decimal_ok` - FROM over1korc GROUP BY i LIMIT 10 + FROM over1korc GROUP BY i ORDER BY i LIMIT 10 PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN SELECT i, AVG(CAST(50 AS INT)) AS `avg_int_ok`, AVG(CAST(50 AS DOUBLE)) AS `avg_double_ok`, AVG(CAST(50 AS DECIMAL)) AS `avg_decimal_ok` - FROM over1korc GROUP BY i LIMIT 10 + FROM over1korc GROUP BY i ORDER BY i LIMIT 10 POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage - Stage-0 depends on stages: Stage-1 + Stage-2 depends on stages: Stage-1 + Stage-0 depends on stages: Stage-2 STAGE PLANS: Stage: Stage-1 @@ -147,6 +148,28 @@ STAGE PLANS: mode: mergepartial outputColumnNames: _col0, _col1, _col2, _col3 Statistics: Num rows: 524 Data size: 155436 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: int) + sort order: + + Statistics: Num rows: 524 Data size: 155436 Basic stats: COMPLETE Column stats: NONE + TopN Hash Memory Usage: 0.1 + value expressions: _col1 (type: double), _col2 (type: double), _col3 (type: decimal(14,4)) + Reduce Operator Tree: + Select Operator + expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: double), VALUE._col1 (type: double), VALUE._col2 (type: decimal(14,4)) + outputColumnNames: _col0, _col1, _col2, _col3 + Statistics: Num rows: 524 Data size: 155436 Basic stats: COMPLETE Column stats: NONE Limit Number of rows: 10 Statistics: Num rows: 10 Data size: 2960 Basic stats: COMPLETE Column stats: NONE @@ -169,7 +192,7 @@ PREHOOK: query: SELECT AVG(CAST(50 AS INT)) AS `avg_int_ok`, AVG(CAST(50 AS DOUBLE)) AS `avg_double_ok`, AVG(CAST(50 AS DECIMAL)) AS `avg_decimal_ok` - FROM over1korc GROUP BY i LIMIT 10 + FROM over1korc GROUP BY i ORDER BY i LIMIT 10 PREHOOK: type: QUERY PREHOOK: Input: default@over1korc #### A masked pattern was here #### @@ -178,17 +201,17 @@ POSTHOOK: query: SELECT AVG(CAST(50 AS INT)) AS `avg_int_ok`, AVG(CAST(50 AS DOUBLE)) AS `avg_double_ok`, AVG(CAST(50 AS DECIMAL)) AS `avg_decimal_ok` - FROM over1korc GROUP BY i LIMIT 10 + FROM over1korc GROUP BY i ORDER BY i LIMIT 10 POSTHOOK: type: QUERY POSTHOOK: Input: default@over1korc #### A masked pattern was here #### -65536 50.0 50.0 50 -65537 50.0 50.0 50 -65538 50.0 50.0 50 -65539 50.0 50.0 50 -65540 50.0 50.0 50 -65541 50.0 50.0 50 -65542 50.0 50.0 50 -65543 50.0 50.0 50 -65544 50.0 50.0 50 -65545 50.0 50.0 50 +65536 50.0 50.0 50.0000 +65537 50.0 50.0 50.0000 +65538 50.0 50.0 50.0000 +65539 50.0 50.0 50.0000 +65540 50.0 50.0 50.0000 +65541 50.0 50.0 50.0000 +65542 50.0 50.0 50.0000 +65543 50.0 50.0 50.0000 +65544 50.0 50.0 50.0000 +65545 50.0 50.0 50.0000