http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/custom_input_output_format.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/custom_input_output_format.q.out b/ql/src/test/results/clientpositive/tez/custom_input_output_format.q.out deleted file mode 100644 index 662ed1a..0000000 --- a/ql/src/test/results/clientpositive/tez/custom_input_output_format.q.out +++ /dev/null @@ -1,102 +0,0 @@ -PREHOOK: query: -- SORT_QUERY_RESULTS - -CREATE TABLE src1_rot13_iof(key STRING, value STRING) - STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.udf.Rot13InputFormat' - OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.udf.Rot13OutputFormat' -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@src1_rot13_iof -POSTHOOK: query: -- SORT_QUERY_RESULTS - -CREATE TABLE src1_rot13_iof(key STRING, value STRING) - STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.udf.Rot13InputFormat' - OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.udf.Rot13OutputFormat' -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@src1_rot13_iof -PREHOOK: query: DESCRIBE EXTENDED src1_rot13_iof -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@src1_rot13_iof -POSTHOOK: query: DESCRIBE EXTENDED src1_rot13_iof -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@src1_rot13_iof -key string -value string - -#### A masked pattern was here #### -PREHOOK: query: SELECT * FROM src1 -PREHOOK: type: QUERY -PREHOOK: Input: default@src1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM src1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src1 -#### A masked pattern was here #### - - - - - val_165 - val_193 - val_265 - val_27 - val_409 - val_484 -128 -146 val_146 -150 val_150 -213 val_213 -224 -238 val_238 -255 val_255 -273 val_273 -278 val_278 -311 val_311 -369 -401 val_401 -406 val_406 -66 val_66 -98 val_98 -PREHOOK: query: INSERT OVERWRITE TABLE src1_rot13_iof SELECT * FROM src1 -PREHOOK: type: QUERY -PREHOOK: Input: default@src1 -PREHOOK: Output: default@src1_rot13_iof -POSTHOOK: query: INSERT OVERWRITE TABLE src1_rot13_iof SELECT * FROM src1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src1 -POSTHOOK: Output: default@src1_rot13_iof -POSTHOOK: Lineage: src1_rot13_iof.key SIMPLE [(src1)src1.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: src1_rot13_iof.value SIMPLE [(src1)src1.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: SELECT * FROM src1_rot13_iof -PREHOOK: type: QUERY -PREHOOK: Input: default@src1_rot13_iof -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM src1_rot13_iof -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src1_rot13_iof -#### A masked pattern was here #### - - - - - val_165 - val_193 - val_265 - val_27 - val_409 - val_484 -128 -146 val_146 -150 val_150 -213 val_213 -224 -238 val_238 -255 val_255 -273 val_273 -278 val_278 -311 val_311 -369 -401 val_401 -406 val_406 -66 val_66 -98 val_98
http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/deleteAnalyze.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/deleteAnalyze.q.out b/ql/src/test/results/clientpositive/tez/deleteAnalyze.q.out deleted file mode 100644 index 00b2f5f..0000000 --- a/ql/src/test/results/clientpositive/tez/deleteAnalyze.q.out +++ /dev/null @@ -1,140 +0,0 @@ -PREHOOK: query: create table testdeci2( -id int, -amount decimal(10,3), -sales_tax decimal(10,3), -item string) -#### A masked pattern was here #### -PREHOOK: type: CREATETABLE -#### A masked pattern was here #### -PREHOOK: Output: database:default -PREHOOK: Output: default@testdeci2 -POSTHOOK: query: create table testdeci2( -id int, -amount decimal(10,3), -sales_tax decimal(10,3), -item string) -#### A masked pattern was here #### -POSTHOOK: type: CREATETABLE -#### A masked pattern was here #### -POSTHOOK: Output: database:default -POSTHOOK: Output: default@testdeci2 -PREHOOK: query: insert into table testdeci2 values(1,12.123,12345.123,'desk1'),(2,123.123,1234.123,'desk2') -PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__1 -PREHOOK: Output: default@testdeci2 -POSTHOOK: query: insert into table testdeci2 values(1,12.123,12345.123,'desk1'),(2,123.123,1234.123,'desk2') -POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__1 -POSTHOOK: Output: default@testdeci2 -POSTHOOK: Lineage: testdeci2.amount EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -POSTHOOK: Lineage: testdeci2.id EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: testdeci2.item SIMPLE [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col4, type:string, comment:), ] -POSTHOOK: Lineage: testdeci2.sales_tax EXPRESSION [(values__tmp__table__1)values__tmp__table__1.FieldSchema(name:tmp_values_col3, type:string, comment:), ] -PREHOOK: query: describe formatted testdeci2 -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@testdeci2 -POSTHOOK: query: describe formatted testdeci2 -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@testdeci2 -# col_name data_type comment - -id int -amount decimal(10,3) -sales_tax decimal(10,3) -item string - -# Detailed Table Information -Database: default -#### A masked pattern was here #### -Retention: 0 -#### A masked pattern was here #### -Table Type: MANAGED_TABLE -Table Parameters: - numFiles 1 - totalSize 578 -#### A masked pattern was here #### - -# Storage Information -SerDe Library: org.apache.hadoop.hive.ql.io.orc.OrcSerde -InputFormat: org.apache.hadoop.hive.ql.io.orc.OrcInputFormat -OutputFormat: org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat -Compressed: No -Num Buckets: -1 -Bucket Columns: [] -Sort Columns: [] -Storage Desc Params: - serialization.format 1 -#### A masked pattern was here #### -PREHOOK: query: describe formatted testdeci2 amount -PREHOOK: type: DESCTABLE -PREHOOK: Input: default@testdeci2 -POSTHOOK: query: describe formatted testdeci2 amount -POSTHOOK: type: DESCTABLE -POSTHOOK: Input: default@testdeci2 -# col_name data_type min max num_nulls distinct_count avg_col_len max_col_len num_trues num_falses comment - -amount decimal(10,3) from deserializer -PREHOOK: query: analyze table testdeci2 compute statistics for columns -PREHOOK: type: QUERY -PREHOOK: Input: default@testdeci2 -#### A masked pattern was here #### -POSTHOOK: query: analyze table testdeci2 compute statistics for columns -POSTHOOK: type: QUERY -POSTHOOK: Input: default@testdeci2 -#### A masked pattern was here #### -PREHOOK: query: analyze table testdeci2 compute statistics for columns -PREHOOK: type: QUERY -PREHOOK: Input: default@testdeci2 -#### A masked pattern was here #### -POSTHOOK: query: analyze table testdeci2 compute statistics for columns -POSTHOOK: type: QUERY -POSTHOOK: Input: default@testdeci2 -#### A masked pattern was here #### -PREHOOK: query: explain -select s.id, -coalesce(d.amount,0) as sales, -coalesce(d.sales_tax,0) as tax -from testdeci2 s join testdeci2 d -on s.item=d.item and d.id=2 -PREHOOK: type: QUERY -POSTHOOK: query: explain -select s.id, -coalesce(d.amount,0) as sales, -coalesce(d.sales_tax,0) as tax -from testdeci2 s join testdeci2 d -on s.item=d.item and d.id=2 -POSTHOOK: type: QUERY -Plan optimized by CBO. - -Vertex dependency in root stage -Reducer 2 <- Map 1 (SIMPLE_EDGE), Map 3 (SIMPLE_EDGE) - -Stage-0 - Fetch Operator - limit:-1 - Stage-1 - Reducer 2 - File Output Operator [FS_10] - Select Operator [SEL_9] (rows=5 width=228) - Output:["_col0","_col1","_col2"] - Merge Join Operator [MERGEJOIN_15] (rows=5 width=228) - Conds:RS_6._col1=RS_7._col3(Inner),Output:["_col0","_col3","_col4"] - <-Map 1 [SIMPLE_EDGE] - SHUFFLE [RS_6] - PartitionCols:_col1 - Select Operator [SEL_2] (rows=5 width=88) - Output:["_col0","_col1"] - Filter Operator [FIL_13] (rows=5 width=88) - predicate:item is not null - TableScan [TS_0] (rows=5 width=88) - default@testdeci2,s,Tbl:COMPLETE,Col:COMPLETE,Output:["id","item"] - <-Map 3 [SIMPLE_EDGE] - SHUFFLE [RS_7] - PartitionCols:_col3 - Select Operator [SEL_5] (rows=1 width=312) - Output:["_col1","_col2","_col3"] - Filter Operator [FIL_14] (rows=1 width=312) - predicate:((id = 2) and item is not null) - TableScan [TS_3] (rows=1 width=312) - default@testdeci2,d,Tbl:COMPLETE,Col:COMPLETE,Output:["id","amount","sales_tax","item"] - http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/delete_all_non_partitioned.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/delete_all_non_partitioned.q.out b/ql/src/test/results/clientpositive/tez/delete_all_non_partitioned.q.out deleted file mode 100644 index 38ce075..0000000 --- a/ql/src/test/results/clientpositive/tez/delete_all_non_partitioned.q.out +++ /dev/null @@ -1,52 +0,0 @@ -PREHOOK: query: create table acid_danp(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true') -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@acid_danp -POSTHOOK: query: create table acid_danp(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true') -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@acid_danp -PREHOOK: query: insert into table acid_danp select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint < 0 order by cint limit 10 -PREHOOK: type: QUERY -PREHOOK: Input: default@alltypesorc -PREHOOK: Output: default@acid_danp -POSTHOOK: query: insert into table acid_danp select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint < 0 order by cint limit 10 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@alltypesorc -POSTHOOK: Output: default@acid_danp -POSTHOOK: Lineage: acid_danp.a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ] -POSTHOOK: Lineage: acid_danp.b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ] -PREHOOK: query: select a,b from acid_danp order by a -PREHOOK: type: QUERY -PREHOOK: Input: default@acid_danp -#### A masked pattern was here #### -POSTHOOK: query: select a,b from acid_danp order by a -POSTHOOK: type: QUERY -POSTHOOK: Input: default@acid_danp -#### A masked pattern was here #### --1073279343 oj1YrV5Wa --1073051226 A34p7oRr2WvUJNf --1072910839 0iqrc5 --1072081801 dPkN74F7 --1072076362 2uLyD28144vklju213J1mr --1071480828 aw724t8c5558x2xneC624 --1071363017 Anj0oF --1070883071 0ruyd6Y50JpdGRf6HqD --1070551679 iUR3Q --1069736047 k17Am8uPHWk02cEf1jet -PREHOOK: query: delete from acid_danp -PREHOOK: type: QUERY -PREHOOK: Input: default@acid_danp -PREHOOK: Output: default@acid_danp -POSTHOOK: query: delete from acid_danp -POSTHOOK: type: QUERY -POSTHOOK: Input: default@acid_danp -POSTHOOK: Output: default@acid_danp -PREHOOK: query: select a,b from acid_danp -PREHOOK: type: QUERY -PREHOOK: Input: default@acid_danp -#### A masked pattern was here #### -POSTHOOK: query: select a,b from acid_danp -POSTHOOK: type: QUERY -POSTHOOK: Input: default@acid_danp -#### A masked pattern was here #### http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/delete_all_partitioned.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/delete_all_partitioned.q.out b/ql/src/test/results/clientpositive/tez/delete_all_partitioned.q.out deleted file mode 100644 index 90f8753..0000000 --- a/ql/src/test/results/clientpositive/tez/delete_all_partitioned.q.out +++ /dev/null @@ -1,86 +0,0 @@ -PREHOOK: query: create table acid_dap(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true') -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@acid_dap -POSTHOOK: query: create table acid_dap(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true') -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@acid_dap -PREHOOK: query: insert into table acid_dap partition (ds='today') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint < 0 order by cint limit 10 -PREHOOK: type: QUERY -PREHOOK: Input: default@alltypesorc -PREHOOK: Output: default@acid_dap@ds=today -POSTHOOK: query: insert into table acid_dap partition (ds='today') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint < 0 order by cint limit 10 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@alltypesorc -POSTHOOK: Output: default@acid_dap@ds=today -POSTHOOK: Lineage: acid_dap PARTITION(ds=today).a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ] -POSTHOOK: Lineage: acid_dap PARTITION(ds=today).b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ] -PREHOOK: query: insert into table acid_dap partition (ds='tomorrow') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint > 1000 order by cint limit 10 -PREHOOK: type: QUERY -PREHOOK: Input: default@alltypesorc -PREHOOK: Output: default@acid_dap@ds=tomorrow -POSTHOOK: query: insert into table acid_dap partition (ds='tomorrow') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint > 1000 order by cint limit 10 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@alltypesorc -POSTHOOK: Output: default@acid_dap@ds=tomorrow -POSTHOOK: Lineage: acid_dap PARTITION(ds=tomorrow).a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ] -POSTHOOK: Lineage: acid_dap PARTITION(ds=tomorrow).b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ] -PREHOOK: query: select a,b,ds from acid_dap order by a,b -PREHOOK: type: QUERY -PREHOOK: Input: default@acid_dap -PREHOOK: Input: default@acid_dap@ds=today -PREHOOK: Input: default@acid_dap@ds=tomorrow -#### A masked pattern was here #### -POSTHOOK: query: select a,b,ds from acid_dap order by a,b -POSTHOOK: type: QUERY -POSTHOOK: Input: default@acid_dap -POSTHOOK: Input: default@acid_dap@ds=today -POSTHOOK: Input: default@acid_dap@ds=tomorrow -#### A masked pattern was here #### --1073279343 oj1YrV5Wa today --1073051226 A34p7oRr2WvUJNf today --1072910839 0iqrc5 today --1072081801 dPkN74F7 today --1072076362 2uLyD28144vklju213J1mr today --1071480828 aw724t8c5558x2xneC624 today --1071363017 Anj0oF today --1070883071 0ruyd6Y50JpdGRf6HqD today --1070551679 iUR3Q today --1069736047 k17Am8uPHWk02cEf1jet today -6981 NULL tomorrow -6981 1FNNhmiFLGw425NA13g tomorrow -6981 4KhrrQ0nJ7bMNTvhSCA tomorrow -6981 K630vaVf tomorrow -6981 Y5x3JuI3M8jngv5N tomorrow -6981 YdG61y00526u5 tomorrow -6981 a3EhVU6Wuy7ycJ7wY7h2gv tomorrow -6981 o4lvY20511w0EOX3P3I82p63 tomorrow -6981 o5mb0QP5Y48Qd4vdB0 tomorrow -6981 sF2CRfgt2K tomorrow -PREHOOK: query: delete from acid_dap -PREHOOK: type: QUERY -PREHOOK: Input: default@acid_dap -PREHOOK: Input: default@acid_dap@ds=today -PREHOOK: Input: default@acid_dap@ds=tomorrow -PREHOOK: Output: default@acid_dap@ds=today -PREHOOK: Output: default@acid_dap@ds=tomorrow -POSTHOOK: query: delete from acid_dap -POSTHOOK: type: QUERY -POSTHOOK: Input: default@acid_dap -POSTHOOK: Input: default@acid_dap@ds=today -POSTHOOK: Input: default@acid_dap@ds=tomorrow -POSTHOOK: Output: default@acid_dap@ds=today -POSTHOOK: Output: default@acid_dap@ds=tomorrow -PREHOOK: query: select * from acid_dap -PREHOOK: type: QUERY -PREHOOK: Input: default@acid_dap -PREHOOK: Input: default@acid_dap@ds=today -PREHOOK: Input: default@acid_dap@ds=tomorrow -#### A masked pattern was here #### -POSTHOOK: query: select * from acid_dap -POSTHOOK: type: QUERY -POSTHOOK: Input: default@acid_dap -POSTHOOK: Input: default@acid_dap@ds=today -POSTHOOK: Input: default@acid_dap@ds=tomorrow -#### A masked pattern was here #### http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/delete_tmp_table.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/delete_tmp_table.q.out b/ql/src/test/results/clientpositive/tez/delete_tmp_table.q.out deleted file mode 100644 index 4dc7344..0000000 --- a/ql/src/test/results/clientpositive/tez/delete_tmp_table.q.out +++ /dev/null @@ -1,60 +0,0 @@ -PREHOOK: query: create temporary table acid_dtt(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true') -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@acid_dtt -POSTHOOK: query: create temporary table acid_dtt(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true') -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@acid_dtt -PREHOOK: query: insert into table acid_dtt select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null order by cint limit 10 -PREHOOK: type: QUERY -PREHOOK: Input: default@alltypesorc -PREHOOK: Output: default@acid_dtt -POSTHOOK: query: insert into table acid_dtt select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null order by cint limit 10 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@alltypesorc -POSTHOOK: Output: default@acid_dtt -POSTHOOK: Lineage: acid_dtt.a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ] -POSTHOOK: Lineage: acid_dtt.b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ] -PREHOOK: query: select * from acid_dtt order by a -PREHOOK: type: QUERY -PREHOOK: Input: default@acid_dtt -#### A masked pattern was here #### -POSTHOOK: query: select * from acid_dtt order by a -POSTHOOK: type: QUERY -POSTHOOK: Input: default@acid_dtt -#### A masked pattern was here #### --1073279343 oj1YrV5Wa --1073051226 A34p7oRr2WvUJNf --1072910839 0iqrc5 --1072081801 dPkN74F7 --1072076362 2uLyD28144vklju213J1mr --1071480828 aw724t8c5558x2xneC624 --1071363017 Anj0oF --1070883071 0ruyd6Y50JpdGRf6HqD --1070551679 iUR3Q --1069736047 k17Am8uPHWk02cEf1jet -PREHOOK: query: delete from acid_dtt where b = '0ruyd6Y50JpdGRf6HqD' or b = '2uLyD28144vklju213J1mr' -PREHOOK: type: QUERY -PREHOOK: Input: default@acid_dtt -PREHOOK: Output: default@acid_dtt -POSTHOOK: query: delete from acid_dtt where b = '0ruyd6Y50JpdGRf6HqD' or b = '2uLyD28144vklju213J1mr' -POSTHOOK: type: QUERY -POSTHOOK: Input: default@acid_dtt -POSTHOOK: Output: default@acid_dtt -PREHOOK: query: select a,b from acid_dtt order by b -PREHOOK: type: QUERY -PREHOOK: Input: default@acid_dtt -#### A masked pattern was here #### -POSTHOOK: query: select a,b from acid_dtt order by b -POSTHOOK: type: QUERY -POSTHOOK: Input: default@acid_dtt -#### A masked pattern was here #### --1072910839 0iqrc5 --1073051226 A34p7oRr2WvUJNf --1071363017 Anj0oF --1071480828 aw724t8c5558x2xneC624 --1072081801 dPkN74F7 --1070551679 iUR3Q --1069736047 k17Am8uPHWk02cEf1jet --1073279343 oj1YrV5Wa http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/delete_where_no_match.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/delete_where_no_match.q.out b/ql/src/test/results/clientpositive/tez/delete_where_no_match.q.out deleted file mode 100644 index cb2adc6..0000000 --- a/ql/src/test/results/clientpositive/tez/delete_where_no_match.q.out +++ /dev/null @@ -1,62 +0,0 @@ -PREHOOK: query: create table acid_dwnm(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true') -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@acid_dwnm -POSTHOOK: query: create table acid_dwnm(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true') -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@acid_dwnm -PREHOOK: query: insert into table acid_dwnm select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null order by cint limit 10 -PREHOOK: type: QUERY -PREHOOK: Input: default@alltypesorc -PREHOOK: Output: default@acid_dwnm -POSTHOOK: query: insert into table acid_dwnm select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null order by cint limit 10 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@alltypesorc -POSTHOOK: Output: default@acid_dwnm -POSTHOOK: Lineage: acid_dwnm.a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ] -POSTHOOK: Lineage: acid_dwnm.b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ] -PREHOOK: query: select * from acid_dwnm order by a -PREHOOK: type: QUERY -PREHOOK: Input: default@acid_dwnm -#### A masked pattern was here #### -POSTHOOK: query: select * from acid_dwnm order by a -POSTHOOK: type: QUERY -POSTHOOK: Input: default@acid_dwnm -#### A masked pattern was here #### --1073279343 oj1YrV5Wa --1073051226 A34p7oRr2WvUJNf --1072910839 0iqrc5 --1072081801 dPkN74F7 --1072076362 2uLyD28144vklju213J1mr --1071480828 aw724t8c5558x2xneC624 --1071363017 Anj0oF --1070883071 0ruyd6Y50JpdGRf6HqD --1070551679 iUR3Q --1069736047 k17Am8uPHWk02cEf1jet -PREHOOK: query: delete from acid_dwnm where b = 'nosuchvalue' -PREHOOK: type: QUERY -PREHOOK: Input: default@acid_dwnm -PREHOOK: Output: default@acid_dwnm -POSTHOOK: query: delete from acid_dwnm where b = 'nosuchvalue' -POSTHOOK: type: QUERY -POSTHOOK: Input: default@acid_dwnm -POSTHOOK: Output: default@acid_dwnm -PREHOOK: query: select a,b from acid_dwnm order by b -PREHOOK: type: QUERY -PREHOOK: Input: default@acid_dwnm -#### A masked pattern was here #### -POSTHOOK: query: select a,b from acid_dwnm order by b -POSTHOOK: type: QUERY -POSTHOOK: Input: default@acid_dwnm -#### A masked pattern was here #### --1072910839 0iqrc5 --1070883071 0ruyd6Y50JpdGRf6HqD --1072076362 2uLyD28144vklju213J1mr --1073051226 A34p7oRr2WvUJNf --1071363017 Anj0oF --1071480828 aw724t8c5558x2xneC624 --1072081801 dPkN74F7 --1070551679 iUR3Q --1069736047 k17Am8uPHWk02cEf1jet --1073279343 oj1YrV5Wa http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/delete_where_non_partitioned.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/delete_where_non_partitioned.q.out b/ql/src/test/results/clientpositive/tez/delete_where_non_partitioned.q.out deleted file mode 100644 index 1bdb1e6..0000000 --- a/ql/src/test/results/clientpositive/tez/delete_where_non_partitioned.q.out +++ /dev/null @@ -1,61 +0,0 @@ -PREHOOK: query: create table acid_dwnp(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true') -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@acid_dwnp -POSTHOOK: query: create table acid_dwnp(a int, b varchar(128)) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true') -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@acid_dwnp -PREHOOK: query: insert into table acid_dwnp select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null order by cint limit 10 -PREHOOK: type: QUERY -PREHOOK: Input: default@alltypesorc -PREHOOK: Output: default@acid_dwnp -POSTHOOK: query: insert into table acid_dwnp select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null order by cint limit 10 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@alltypesorc -POSTHOOK: Output: default@acid_dwnp -POSTHOOK: Lineage: acid_dwnp.a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ] -POSTHOOK: Lineage: acid_dwnp.b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ] -PREHOOK: query: select * from acid_dwnp order by a -PREHOOK: type: QUERY -PREHOOK: Input: default@acid_dwnp -#### A masked pattern was here #### -POSTHOOK: query: select * from acid_dwnp order by a -POSTHOOK: type: QUERY -POSTHOOK: Input: default@acid_dwnp -#### A masked pattern was here #### --1073279343 oj1YrV5Wa --1073051226 A34p7oRr2WvUJNf --1072910839 0iqrc5 --1072081801 dPkN74F7 --1072076362 2uLyD28144vklju213J1mr --1071480828 aw724t8c5558x2xneC624 --1071363017 Anj0oF --1070883071 0ruyd6Y50JpdGRf6HqD --1070551679 iUR3Q --1069736047 k17Am8uPHWk02cEf1jet -PREHOOK: query: delete from acid_dwnp where b = '0ruyd6Y50JpdGRf6HqD' -PREHOOK: type: QUERY -PREHOOK: Input: default@acid_dwnp -PREHOOK: Output: default@acid_dwnp -POSTHOOK: query: delete from acid_dwnp where b = '0ruyd6Y50JpdGRf6HqD' -POSTHOOK: type: QUERY -POSTHOOK: Input: default@acid_dwnp -POSTHOOK: Output: default@acid_dwnp -PREHOOK: query: select a,b from acid_dwnp order by b -PREHOOK: type: QUERY -PREHOOK: Input: default@acid_dwnp -#### A masked pattern was here #### -POSTHOOK: query: select a,b from acid_dwnp order by b -POSTHOOK: type: QUERY -POSTHOOK: Input: default@acid_dwnp -#### A masked pattern was here #### --1072910839 0iqrc5 --1072076362 2uLyD28144vklju213J1mr --1073051226 A34p7oRr2WvUJNf --1071363017 Anj0oF --1071480828 aw724t8c5558x2xneC624 --1072081801 dPkN74F7 --1070551679 iUR3Q --1069736047 k17Am8uPHWk02cEf1jet --1073279343 oj1YrV5Wa http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/delete_where_partitioned.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/delete_where_partitioned.q.out b/ql/src/test/results/clientpositive/tez/delete_where_partitioned.q.out deleted file mode 100644 index fc2e369..0000000 --- a/ql/src/test/results/clientpositive/tez/delete_where_partitioned.q.out +++ /dev/null @@ -1,105 +0,0 @@ -PREHOOK: query: create table acid_dwp(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true') -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@acid_dwp -POSTHOOK: query: create table acid_dwp(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true') -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@acid_dwp -PREHOOK: query: insert into table acid_dwp partition (ds='today') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint < 0 order by cint limit 10 -PREHOOK: type: QUERY -PREHOOK: Input: default@alltypesorc -PREHOOK: Output: default@acid_dwp@ds=today -POSTHOOK: query: insert into table acid_dwp partition (ds='today') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint < 0 order by cint limit 10 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@alltypesorc -POSTHOOK: Output: default@acid_dwp@ds=today -POSTHOOK: Lineage: acid_dwp PARTITION(ds=today).a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ] -POSTHOOK: Lineage: acid_dwp PARTITION(ds=today).b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ] -PREHOOK: query: insert into table acid_dwp partition (ds='tomorrow') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint > -10000000 order by cint limit 10 -PREHOOK: type: QUERY -PREHOOK: Input: default@alltypesorc -PREHOOK: Output: default@acid_dwp@ds=tomorrow -POSTHOOK: query: insert into table acid_dwp partition (ds='tomorrow') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint > -10000000 order by cint limit 10 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@alltypesorc -POSTHOOK: Output: default@acid_dwp@ds=tomorrow -POSTHOOK: Lineage: acid_dwp PARTITION(ds=tomorrow).a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ] -POSTHOOK: Lineage: acid_dwp PARTITION(ds=tomorrow).b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ] -PREHOOK: query: select a,b,ds from acid_dwp order by a, ds -PREHOOK: type: QUERY -PREHOOK: Input: default@acid_dwp -PREHOOK: Input: default@acid_dwp@ds=today -PREHOOK: Input: default@acid_dwp@ds=tomorrow -#### A masked pattern was here #### -POSTHOOK: query: select a,b,ds from acid_dwp order by a, ds -POSTHOOK: type: QUERY -POSTHOOK: Input: default@acid_dwp -POSTHOOK: Input: default@acid_dwp@ds=today -POSTHOOK: Input: default@acid_dwp@ds=tomorrow -#### A masked pattern was here #### --1073279343 oj1YrV5Wa today --1073051226 A34p7oRr2WvUJNf today --1072910839 0iqrc5 today --1072081801 dPkN74F7 today --1072076362 2uLyD28144vklju213J1mr today --1071480828 aw724t8c5558x2xneC624 today --1071363017 Anj0oF today --1070883071 0ruyd6Y50JpdGRf6HqD today --1070551679 iUR3Q today --1069736047 k17Am8uPHWk02cEf1jet today --9676535 MmMPCF2 tomorrow --9462165 7WLVW6F4h71Dgk7 tomorrow --9329892 e7sC5M0H5K6EgSTf41X tomorrow --9175632 UUBET8444iJDvjUlq3en tomorrow --9011819 A6CX2HDWN8 tomorrow --8987676 FhXANp2KDtMmA2gFd778pA tomorrow --8413710 81Rg5rR0IaInWw tomorrow --8230445 K6J1LIb5 tomorrow --7980033 HtI02nss6t8S0fqH4vcLkCD tomorrow --6882225 r6gCtT4Tgo5rG tomorrow -PREHOOK: query: delete from acid_dwp where a = '-1071363017' -PREHOOK: type: QUERY -PREHOOK: Input: default@acid_dwp -PREHOOK: Input: default@acid_dwp@ds=today -PREHOOK: Input: default@acid_dwp@ds=tomorrow -PREHOOK: Output: default@acid_dwp@ds=today -PREHOOK: Output: default@acid_dwp@ds=tomorrow -POSTHOOK: query: delete from acid_dwp where a = '-1071363017' -POSTHOOK: type: QUERY -POSTHOOK: Input: default@acid_dwp -POSTHOOK: Input: default@acid_dwp@ds=today -POSTHOOK: Input: default@acid_dwp@ds=tomorrow -POSTHOOK: Output: default@acid_dwp@ds=today -POSTHOOK: Output: default@acid_dwp@ds=tomorrow -PREHOOK: query: select * from acid_dwp order by a, ds -PREHOOK: type: QUERY -PREHOOK: Input: default@acid_dwp -PREHOOK: Input: default@acid_dwp@ds=today -PREHOOK: Input: default@acid_dwp@ds=tomorrow -#### A masked pattern was here #### -POSTHOOK: query: select * from acid_dwp order by a, ds -POSTHOOK: type: QUERY -POSTHOOK: Input: default@acid_dwp -POSTHOOK: Input: default@acid_dwp@ds=today -POSTHOOK: Input: default@acid_dwp@ds=tomorrow -#### A masked pattern was here #### --1073279343 oj1YrV5Wa today --1073051226 A34p7oRr2WvUJNf today --1072910839 0iqrc5 today --1072081801 dPkN74F7 today --1072076362 2uLyD28144vklju213J1mr today --1071480828 aw724t8c5558x2xneC624 today --1070883071 0ruyd6Y50JpdGRf6HqD today --1070551679 iUR3Q today --1069736047 k17Am8uPHWk02cEf1jet today --9676535 MmMPCF2 tomorrow --9462165 7WLVW6F4h71Dgk7 tomorrow --9329892 e7sC5M0H5K6EgSTf41X tomorrow --9175632 UUBET8444iJDvjUlq3en tomorrow --9011819 A6CX2HDWN8 tomorrow --8987676 FhXANp2KDtMmA2gFd778pA tomorrow --8413710 81Rg5rR0IaInWw tomorrow --8230445 K6J1LIb5 tomorrow --7980033 HtI02nss6t8S0fqH4vcLkCD tomorrow --6882225 r6gCtT4Tgo5rG tomorrow http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/delete_whole_partition.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/delete_whole_partition.q.out b/ql/src/test/results/clientpositive/tez/delete_whole_partition.q.out deleted file mode 100644 index 043daf4..0000000 --- a/ql/src/test/results/clientpositive/tez/delete_whole_partition.q.out +++ /dev/null @@ -1,92 +0,0 @@ -PREHOOK: query: create table acid_dwhp(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true') -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@acid_dwhp -POSTHOOK: query: create table acid_dwhp(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true') -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@acid_dwhp -PREHOOK: query: insert into table acid_dwhp partition (ds='today') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint < 0 order by cint limit 10 -PREHOOK: type: QUERY -PREHOOK: Input: default@alltypesorc -PREHOOK: Output: default@acid_dwhp@ds=today -POSTHOOK: query: insert into table acid_dwhp partition (ds='today') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint < 0 order by cint limit 10 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@alltypesorc -POSTHOOK: Output: default@acid_dwhp@ds=today -POSTHOOK: Lineage: acid_dwhp PARTITION(ds=today).a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ] -POSTHOOK: Lineage: acid_dwhp PARTITION(ds=today).b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ] -PREHOOK: query: insert into table acid_dwhp partition (ds='tomorrow') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint > -10000000 order by cint limit 10 -PREHOOK: type: QUERY -PREHOOK: Input: default@alltypesorc -PREHOOK: Output: default@acid_dwhp@ds=tomorrow -POSTHOOK: query: insert into table acid_dwhp partition (ds='tomorrow') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint > -10000000 order by cint limit 10 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@alltypesorc -POSTHOOK: Output: default@acid_dwhp@ds=tomorrow -POSTHOOK: Lineage: acid_dwhp PARTITION(ds=tomorrow).a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ] -POSTHOOK: Lineage: acid_dwhp PARTITION(ds=tomorrow).b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ] -PREHOOK: query: select a,b,ds from acid_dwhp order by a, ds -PREHOOK: type: QUERY -PREHOOK: Input: default@acid_dwhp -PREHOOK: Input: default@acid_dwhp@ds=today -PREHOOK: Input: default@acid_dwhp@ds=tomorrow -#### A masked pattern was here #### -POSTHOOK: query: select a,b,ds from acid_dwhp order by a, ds -POSTHOOK: type: QUERY -POSTHOOK: Input: default@acid_dwhp -POSTHOOK: Input: default@acid_dwhp@ds=today -POSTHOOK: Input: default@acid_dwhp@ds=tomorrow -#### A masked pattern was here #### --1073279343 oj1YrV5Wa today --1073051226 A34p7oRr2WvUJNf today --1072910839 0iqrc5 today --1072081801 dPkN74F7 today --1072076362 2uLyD28144vklju213J1mr today --1071480828 aw724t8c5558x2xneC624 today --1071363017 Anj0oF today --1070883071 0ruyd6Y50JpdGRf6HqD today --1070551679 iUR3Q today --1069736047 k17Am8uPHWk02cEf1jet today --9676535 MmMPCF2 tomorrow --9462165 7WLVW6F4h71Dgk7 tomorrow --9329892 e7sC5M0H5K6EgSTf41X tomorrow --9175632 UUBET8444iJDvjUlq3en tomorrow --9011819 A6CX2HDWN8 tomorrow --8987676 FhXANp2KDtMmA2gFd778pA tomorrow --8413710 81Rg5rR0IaInWw tomorrow --8230445 K6J1LIb5 tomorrow --7980033 HtI02nss6t8S0fqH4vcLkCD tomorrow --6882225 r6gCtT4Tgo5rG tomorrow -PREHOOK: query: delete from acid_dwhp where ds = 'today' -PREHOOK: type: QUERY -PREHOOK: Input: default@acid_dwhp -PREHOOK: Input: default@acid_dwhp@ds=today -PREHOOK: Output: default@acid_dwhp@ds=today -POSTHOOK: query: delete from acid_dwhp where ds = 'today' -POSTHOOK: type: QUERY -POSTHOOK: Input: default@acid_dwhp -POSTHOOK: Input: default@acid_dwhp@ds=today -POSTHOOK: Output: default@acid_dwhp@ds=today -PREHOOK: query: select * from acid_dwhp order by a, ds -PREHOOK: type: QUERY -PREHOOK: Input: default@acid_dwhp -PREHOOK: Input: default@acid_dwhp@ds=today -PREHOOK: Input: default@acid_dwhp@ds=tomorrow -#### A masked pattern was here #### -POSTHOOK: query: select * from acid_dwhp order by a, ds -POSTHOOK: type: QUERY -POSTHOOK: Input: default@acid_dwhp -POSTHOOK: Input: default@acid_dwhp@ds=today -POSTHOOK: Input: default@acid_dwhp@ds=tomorrow -#### A masked pattern was here #### --9676535 MmMPCF2 tomorrow --9462165 7WLVW6F4h71Dgk7 tomorrow --9329892 e7sC5M0H5K6EgSTf41X tomorrow --9175632 UUBET8444iJDvjUlq3en tomorrow --9011819 A6CX2HDWN8 tomorrow --8987676 FhXANp2KDtMmA2gFd778pA tomorrow --8413710 81Rg5rR0IaInWw tomorrow --8230445 K6J1LIb5 tomorrow --7980033 HtI02nss6t8S0fqH4vcLkCD tomorrow --6882225 r6gCtT4Tgo5rG tomorrow http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/disable_merge_for_bucketing.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/disable_merge_for_bucketing.q.out b/ql/src/test/results/clientpositive/tez/disable_merge_for_bucketing.q.out deleted file mode 100644 index 3955da3..0000000 --- a/ql/src/test/results/clientpositive/tez/disable_merge_for_bucketing.q.out +++ /dev/null @@ -1,494 +0,0 @@ -PREHOOK: query: CREATE TABLE bucket2_1(key int, value string) CLUSTERED BY (key) INTO 2 BUCKETS -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@bucket2_1 -POSTHOOK: query: CREATE TABLE bucket2_1(key int, value string) CLUSTERED BY (key) INTO 2 BUCKETS -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@bucket2_1 -PREHOOK: query: explain extended -insert overwrite table bucket2_1 -select * from src -PREHOOK: type: QUERY -POSTHOOK: query: explain extended -insert overwrite table bucket2_1 -select * from src -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-3 depends on stages: Stage-0 - -STAGE PLANS: - Stage: Stage-1 - Tez -#### A masked pattern was here #### - Edges: - Reducer 2 <- Map 1 (SIMPLE_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: src - Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE - GatherStats: false - Select Operator - expressions: key (type: string), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - null sort order: - sort order: - Map-reduce partition columns: UDFToInteger(_col0) (type: int) - Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE - tag: -1 - value expressions: _col0 (type: string), _col1 (type: string) - auto parallelism: false - Path -> Alias: -#### A masked pattern was here #### - Path -> Partition: -#### A masked pattern was here #### - Partition - base file name: src - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - properties: - COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} - bucket_count -1 - columns key,value - columns.comments 'default','default' - columns.types string:string -#### A masked pattern was here #### - name default.src - numFiles 1 - numRows 500 - rawDataSize 5312 - serialization.ddl struct src { string key, string value} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - totalSize 5812 -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - properties: - COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} - bucket_count -1 - columns key,value - columns.comments 'default','default' - columns.types string:string -#### A masked pattern was here #### - name default.src - numFiles 1 - numRows 500 - rawDataSize 5312 - serialization.ddl struct src { string key, string value} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - totalSize 5812 -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.src - name: default.src - Truncated Path -> Alias: - /src [src] - Reducer 2 - Needs Tagging: false - Reduce Operator Tree: - Select Operator - expressions: UDFToInteger(VALUE._col0) (type: int), VALUE._col1 (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 500 Data size: 47500 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - GlobalTableId: 1 -#### A masked pattern was here #### - NumFilesPerFileSink: 2 - Statistics: Num rows: 500 Data size: 47500 Basic stats: COMPLETE Column stats: COMPLETE -#### A masked pattern was here #### - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - properties: - COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} - bucket_count 2 - bucket_field_name key - columns key,value - columns.comments - columns.types int:string -#### A masked pattern was here #### - name default.bucket2_1 - numFiles 0 - numRows 0 - rawDataSize 0 - serialization.ddl struct bucket2_1 { i32 key, string value} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - totalSize 0 -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.bucket2_1 - TotalFiles: 2 - GatherStats: true - MultiFileSpray: true - - Stage: Stage-2 - Dependency Collection - - Stage: Stage-0 - Move Operator - tables: - replace: true -#### A masked pattern was here #### - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - properties: - COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} - bucket_count 2 - bucket_field_name key - columns key,value - columns.comments - columns.types int:string -#### A masked pattern was here #### - name default.bucket2_1 - numFiles 0 - numRows 0 - rawDataSize 0 - serialization.ddl struct bucket2_1 { i32 key, string value} - serialization.format 1 - serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - totalSize 0 -#### A masked pattern was here #### - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.bucket2_1 - - Stage: Stage-3 - Stats-Aggr Operator -#### A masked pattern was here #### - -PREHOOK: query: insert overwrite table bucket2_1 -select * from src -PREHOOK: type: QUERY -PREHOOK: Input: default@src -PREHOOK: Output: default@bucket2_1 -POSTHOOK: query: insert overwrite table bucket2_1 -select * from src -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -POSTHOOK: Output: default@bucket2_1 -POSTHOOK: Lineage: bucket2_1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: bucket2_1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: explain -select * from bucket2_1 tablesample (bucket 1 out of 2) s order by key -PREHOOK: type: QUERY -POSTHOOK: query: explain -select * from bucket2_1 tablesample (bucket 1 out of 2) s order by key -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-0 depends on stages: Stage-1 - -STAGE PLANS: - Stage: Stage-1 - Tez -#### A masked pattern was here #### - Edges: - Reducer 2 <- Map 1 (SIMPLE_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: s - Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE - Filter Operator - predicate: (((hash(key) & 2147483647) % 2) = 0) (type: boolean) - Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: key (type: int), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: _col0 (type: int) - sort order: + - Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE - value expressions: _col1 (type: string) - Reducer 2 - Reduce Operator Tree: - Select Operator - expressions: KEY.reducesinkkey0 (type: int), VALUE._col0 (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 250 Data size: 2656 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 - -PREHOOK: query: select * from bucket2_1 tablesample (bucket 1 out of 2) s order by key -PREHOOK: type: QUERY -PREHOOK: Input: default@bucket2_1 -#### A masked pattern was here #### -POSTHOOK: query: select * from bucket2_1 tablesample (bucket 1 out of 2) s order by key -POSTHOOK: type: QUERY -POSTHOOK: Input: default@bucket2_1 -#### A masked pattern was here #### -0 val_0 -0 val_0 -0 val_0 -2 val_2 -4 val_4 -8 val_8 -10 val_10 -12 val_12 -12 val_12 -18 val_18 -18 val_18 -20 val_20 -24 val_24 -24 val_24 -26 val_26 -26 val_26 -28 val_28 -30 val_30 -34 val_34 -42 val_42 -42 val_42 -44 val_44 -54 val_54 -58 val_58 -58 val_58 -64 val_64 -66 val_66 -70 val_70 -70 val_70 -70 val_70 -72 val_72 -72 val_72 -74 val_74 -76 val_76 -76 val_76 -78 val_78 -80 val_80 -82 val_82 -84 val_84 -84 val_84 -86 val_86 -90 val_90 -90 val_90 -90 val_90 -92 val_92 -96 val_96 -98 val_98 -98 val_98 -100 val_100 -100 val_100 -104 val_104 -104 val_104 -114 val_114 -116 val_116 -118 val_118 -118 val_118 -120 val_120 -120 val_120 -126 val_126 -128 val_128 -128 val_128 -128 val_128 -134 val_134 -134 val_134 -136 val_136 -138 val_138 -138 val_138 -138 val_138 -138 val_138 -146 val_146 -146 val_146 -150 val_150 -152 val_152 -152 val_152 -156 val_156 -158 val_158 -160 val_160 -162 val_162 -164 val_164 -164 val_164 -166 val_166 -168 val_168 -170 val_170 -172 val_172 -172 val_172 -174 val_174 -174 val_174 -176 val_176 -176 val_176 -178 val_178 -180 val_180 -186 val_186 -190 val_190 -192 val_192 -194 val_194 -196 val_196 -200 val_200 -200 val_200 -202 val_202 -208 val_208 -208 val_208 -208 val_208 -214 val_214 -216 val_216 -216 val_216 -218 val_218 -222 val_222 -224 val_224 -224 val_224 -226 val_226 -228 val_228 -230 val_230 -230 val_230 -230 val_230 -230 val_230 -230 val_230 -238 val_238 -238 val_238 -242 val_242 -242 val_242 -244 val_244 -248 val_248 -252 val_252 -256 val_256 -256 val_256 -258 val_258 -260 val_260 -262 val_262 -266 val_266 -272 val_272 -272 val_272 -274 val_274 -278 val_278 -278 val_278 -280 val_280 -280 val_280 -282 val_282 -282 val_282 -284 val_284 -286 val_286 -288 val_288 -288 val_288 -292 val_292 -296 val_296 -298 val_298 -298 val_298 -298 val_298 -302 val_302 -306 val_306 -308 val_308 -310 val_310 -316 val_316 -316 val_316 -316 val_316 -318 val_318 -318 val_318 -318 val_318 -322 val_322 -322 val_322 -332 val_332 -336 val_336 -338 val_338 -342 val_342 -342 val_342 -344 val_344 -344 val_344 -348 val_348 -348 val_348 -348 val_348 -348 val_348 -348 val_348 -356 val_356 -360 val_360 -362 val_362 -364 val_364 -366 val_366 -368 val_368 -374 val_374 -378 val_378 -382 val_382 -382 val_382 -384 val_384 -384 val_384 -384 val_384 -386 val_386 -392 val_392 -394 val_394 -396 val_396 -396 val_396 -396 val_396 -400 val_400 -402 val_402 -404 val_404 -404 val_404 -406 val_406 -406 val_406 -406 val_406 -406 val_406 -414 val_414 -414 val_414 -418 val_418 -424 val_424 -424 val_424 -430 val_430 -430 val_430 -430 val_430 -432 val_432 -436 val_436 -438 val_438 -438 val_438 -438 val_438 -444 val_444 -446 val_446 -448 val_448 -452 val_452 -454 val_454 -454 val_454 -454 val_454 -458 val_458 -458 val_458 -460 val_460 -462 val_462 -462 val_462 -466 val_466 -466 val_466 -466 val_466 -468 val_468 -468 val_468 -468 val_468 -468 val_468 -470 val_470 -472 val_472 -478 val_478 -478 val_478 -480 val_480 -480 val_480 -480 val_480 -482 val_482 -484 val_484 -490 val_490 -492 val_492 -492 val_492 -494 val_494 -496 val_496 -498 val_498 -498 val_498 -498 val_498
