HIVE-10932 : Unit test udf_nondeterministic failure due to HIVE-10728 (Aihua Xu via Ashutosh Chauhan)
Signed-off-by: Ashutosh Chauhan <hashut...@apache.org> Project: http://git-wip-us.apache.org/repos/asf/hive/repo Commit: http://git-wip-us.apache.org/repos/asf/hive/commit/8a107300 Tree: http://git-wip-us.apache.org/repos/asf/hive/tree/8a107300 Diff: http://git-wip-us.apache.org/repos/asf/hive/diff/8a107300 Branch: refs/heads/hbase-metastore Commit: 8a107300d43ea11a5951194482fcdfc3a362ca96 Parents: c9b7d25 Author: Aihua Xu <aihu...@gmail.com> Authored: Thu Jun 4 06:13:00 2015 -0700 Committer: Ashutosh Chauhan <hashut...@apache.org> Committed: Thu Jun 4 16:23:39 2015 -0700 ---------------------------------------------------------------------- .../clientpositive/udf_folder_constants.q | 11 ++ .../clientpositive/udf_nondeterministic.q | 11 -- .../clientpositive/udf_folder_constants.q.out | 120 +++++++++++++++++++ .../clientpositive/udf_nondeterministic.q.out | 120 ------------------- 4 files changed, 131 insertions(+), 131 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/hive/blob/8a107300/ql/src/test/queries/clientpositive/udf_folder_constants.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/udf_folder_constants.q b/ql/src/test/queries/clientpositive/udf_folder_constants.q new file mode 100644 index 0000000..fcb5162 --- /dev/null +++ b/ql/src/test/queries/clientpositive/udf_folder_constants.q @@ -0,0 +1,11 @@ +drop table if exists udf_tb1; +drop table if exists udf_tb2; + +create table udf_tb1 (year int, month int); +create table udf_tb2(month int); +insert into udf_tb1 values(2001, 11); +insert into udf_tb2 values(11); + +explain +select unix_timestamp(concat(a.year, '-01-01 00:00:00')) from (select * from udf_tb1 where year=2001) a join udf_tb2 b on (a.month=b.month); +select unix_timestamp(concat(a.year, '-01-01 00:00:00')) from (select * from udf_tb1 where year=2001) a join udf_tb2 b on (a.month=b.month); http://git-wip-us.apache.org/repos/asf/hive/blob/8a107300/ql/src/test/queries/clientpositive/udf_nondeterministic.q ---------------------------------------------------------------------- diff --git a/ql/src/test/queries/clientpositive/udf_nondeterministic.q b/ql/src/test/queries/clientpositive/udf_nondeterministic.q deleted file mode 100644 index fcb5162..0000000 --- a/ql/src/test/queries/clientpositive/udf_nondeterministic.q +++ /dev/null @@ -1,11 +0,0 @@ -drop table if exists udf_tb1; -drop table if exists udf_tb2; - -create table udf_tb1 (year int, month int); -create table udf_tb2(month int); -insert into udf_tb1 values(2001, 11); -insert into udf_tb2 values(11); - -explain -select unix_timestamp(concat(a.year, '-01-01 00:00:00')) from (select * from udf_tb1 where year=2001) a join udf_tb2 b on (a.month=b.month); -select unix_timestamp(concat(a.year, '-01-01 00:00:00')) from (select * from udf_tb1 where year=2001) a join udf_tb2 b on (a.month=b.month); http://git-wip-us.apache.org/repos/asf/hive/blob/8a107300/ql/src/test/results/clientpositive/udf_folder_constants.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/udf_folder_constants.q.out b/ql/src/test/results/clientpositive/udf_folder_constants.q.out new file mode 100644 index 0000000..65ee693 --- /dev/null +++ b/ql/src/test/results/clientpositive/udf_folder_constants.q.out @@ -0,0 +1,120 @@ +PREHOOK: query: drop table if exists udf_tb1 +PREHOOK: type: DROPTABLE +POSTHOOK: query: drop table if exists udf_tb1 +POSTHOOK: type: DROPTABLE +PREHOOK: query: drop table if exists udf_tb2 +PREHOOK: type: DROPTABLE +POSTHOOK: query: drop table if exists udf_tb2 +POSTHOOK: type: DROPTABLE +PREHOOK: query: create table udf_tb1 (year int, month int) +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@udf_tb1 +POSTHOOK: query: create table udf_tb1 (year int, month int) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@udf_tb1 +PREHOOK: query: create table udf_tb2(month int) +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@udf_tb2 +POSTHOOK: query: create table udf_tb2(month int) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@udf_tb2 +PREHOOK: query: insert into udf_tb1 values(2001, 11) +PREHOOK: type: QUERY +PREHOOK: Input: default@values__tmp__table__1 +PREHOOK: Output: default@udf_tb1 +POSTHOOK: query: insert into udf_tb1 values(2001, 11) +POSTHOOK: type: QUERY +POSTHOOK: Input: default@values__tmp__table__1 +POSTHOOK: Output: default@udf_tb1 +POSTHOOK: Lineage: udf_tb1.month EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ] +POSTHOOK: Lineage: udf_tb1.year EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] +PREHOOK: query: insert into udf_tb2 values(11) +PREHOOK: type: QUERY +PREHOOK: Input: default@values__tmp__table__2 +PREHOOK: Output: default@udf_tb2 +POSTHOOK: query: insert into udf_tb2 values(11) +POSTHOOK: type: QUERY +POSTHOOK: Input: default@values__tmp__table__2 +POSTHOOK: Output: default@udf_tb2 +POSTHOOK: Lineage: udf_tb2.month EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ] +PREHOOK: query: explain +select unix_timestamp(concat(a.year, '-01-01 00:00:00')) from (select * from udf_tb1 where year=2001) a join udf_tb2 b on (a.month=b.month) +PREHOOK: type: QUERY +POSTHOOK: query: explain +select unix_timestamp(concat(a.year, '-01-01 00:00:00')) from (select * from udf_tb1 where year=2001) a join udf_tb2 b on (a.month=b.month) +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: udf_tb1 + Statistics: Num rows: 1 Data size: 7 Basic stats: COMPLETE Column stats: NONE + Filter Operator + predicate: ((year = 2001) and month is not null) (type: boolean) + Statistics: Num rows: 1 Data size: 7 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: month (type: int) + outputColumnNames: _col1 + Statistics: Num rows: 1 Data size: 7 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + key expressions: _col1 (type: int) + sort order: + + Map-reduce partition columns: _col1 (type: int) + Statistics: Num rows: 1 Data size: 7 Basic stats: COMPLETE Column stats: NONE + TableScan + alias: b + Statistics: Num rows: 1 Data size: 2 Basic stats: COMPLETE Column stats: NONE + Filter Operator + predicate: month is not null (type: boolean) + Statistics: Num rows: 1 Data size: 2 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + key expressions: month (type: int) + sort order: + + Map-reduce partition columns: month (type: int) + Statistics: Num rows: 1 Data size: 2 Basic stats: COMPLETE Column stats: NONE + Reduce Operator Tree: + Join Operator + condition map: + Inner Join 0 to 1 + keys: + 0 _col1 (type: int) + 1 month (type: int) + Statistics: Num rows: 1 Data size: 7 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: 978336000 (type: bigint) + outputColumnNames: _col0 + Statistics: Num rows: 1 Data size: 7 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + Statistics: Num rows: 1 Data size: 7 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: -1 + Processor Tree: + ListSink + +PREHOOK: query: select unix_timestamp(concat(a.year, '-01-01 00:00:00')) from (select * from udf_tb1 where year=2001) a join udf_tb2 b on (a.month=b.month) +PREHOOK: type: QUERY +PREHOOK: Input: default@udf_tb1 +PREHOOK: Input: default@udf_tb2 +#### A masked pattern was here #### +POSTHOOK: query: select unix_timestamp(concat(a.year, '-01-01 00:00:00')) from (select * from udf_tb1 where year=2001) a join udf_tb2 b on (a.month=b.month) +POSTHOOK: type: QUERY +POSTHOOK: Input: default@udf_tb1 +POSTHOOK: Input: default@udf_tb2 +#### A masked pattern was here #### +978336000 http://git-wip-us.apache.org/repos/asf/hive/blob/8a107300/ql/src/test/results/clientpositive/udf_nondeterministic.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/udf_nondeterministic.q.out b/ql/src/test/results/clientpositive/udf_nondeterministic.q.out deleted file mode 100644 index eef5555..0000000 --- a/ql/src/test/results/clientpositive/udf_nondeterministic.q.out +++ /dev/null @@ -1,120 +0,0 @@ -PREHOOK: query: drop table if exists udf_tb1 -PREHOOK: type: DROPTABLE -POSTHOOK: query: drop table if exists udf_tb1 -POSTHOOK: type: DROPTABLE -PREHOOK: query: drop table if exists udf_tb2 -PREHOOK: type: DROPTABLE -POSTHOOK: query: drop table if exists udf_tb2 -POSTHOOK: type: DROPTABLE -PREHOOK: query: create table udf_tb1 (year int, month int) -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@udf_tb1 -POSTHOOK: query: create table udf_tb1 (year int, month int) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@udf_tb1 -PREHOOK: query: create table udf_tb2(month int) -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@udf_tb2 -POSTHOOK: query: create table udf_tb2(month int) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@udf_tb2 -PREHOOK: query: insert into udf_tb1 values(2001, 11) -PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__1 -PREHOOK: Output: default@udf_tb1 -POSTHOOK: query: insert into udf_tb1 values(2001, 11) -POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__1 -POSTHOOK: Output: default@udf_tb1 -POSTHOOK: Lineage: udf_tb1.month EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: udf_tb1.year EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -PREHOOK: query: insert into udf_tb2 values(11) -PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__2 -PREHOOK: Output: default@udf_tb2 -POSTHOOK: query: insert into udf_tb2 values(11) -POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__2 -POSTHOOK: Output: default@udf_tb2 -POSTHOOK: Lineage: udf_tb2.month EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -PREHOOK: query: explain -select unix_timestamp(concat(a.year, '-01-01 00:00:00')) from (select * from udf_tb1 where year=2001) a join udf_tb2 b on (a.month=b.month) -PREHOOK: type: QUERY -POSTHOOK: query: explain -select unix_timestamp(concat(a.year, '-01-01 00:00:00')) from (select * from udf_tb1 where year=2001) a join udf_tb2 b on (a.month=b.month) -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: udf_tb1 - Statistics: Num rows: 1 Data size: 7 Basic stats: COMPLETE Column stats: NONE - Filter Operator - predicate: ((year = 2001) and month is not null) (type: boolean) - Statistics: Num rows: 1 Data size: 7 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: month (type: int) - outputColumnNames: _col1 - Statistics: Num rows: 1 Data size: 7 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col1 (type: int) - sort order: + - Map-reduce partition columns: _col1 (type: int) - Statistics: Num rows: 1 Data size: 7 Basic stats: COMPLETE Column stats: NONE - TableScan - alias: b - Statistics: Num rows: 1 Data size: 2 Basic stats: COMPLETE Column stats: NONE - Filter Operator - predicate: month is not null (type: boolean) - Statistics: Num rows: 1 Data size: 2 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: month (type: int) - sort order: + - Map-reduce partition columns: month (type: int) - Statistics: Num rows: 1 Data size: 2 Basic stats: COMPLETE Column stats: NONE - Reduce Operator Tree: - Join Operator - condition map: - Inner Join 0 to 1 - keys: - 0 _col1 (type: int) - 1 month (type: int) - Statistics: Num rows: 1 Data size: 7 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: unix_timestamp('2001-01-01 00:00:00') (type: bigint) - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 7 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 1 Data size: 7 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: -1 - Processor Tree: - ListSink - -PREHOOK: query: select unix_timestamp(concat(a.year, '-01-01 00:00:00')) from (select * from udf_tb1 where year=2001) a join udf_tb2 b on (a.month=b.month) -PREHOOK: type: QUERY -PREHOOK: Input: default@udf_tb1 -PREHOOK: Input: default@udf_tb2 -#### A masked pattern was here #### -POSTHOOK: query: select unix_timestamp(concat(a.year, '-01-01 00:00:00')) from (select * from udf_tb1 where year=2001) a join udf_tb2 b on (a.month=b.month) -POSTHOOK: type: QUERY -POSTHOOK: Input: default@udf_tb1 -POSTHOOK: Input: default@udf_tb2 -#### A masked pattern was here #### -978336000