Modified: hive/branches/cbo/ql/src/test/results/clientpositive/union_remove_22.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/union_remove_22.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/union_remove_22.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/union_remove_22.q.out Fri Aug 22 21:36:47 2014 @@ -11,6 +11,7 @@ PREHOOK: query: -- This is to test the u create table inputTbl1(key string, val string) stored as textfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@inputTbl1 POSTHOOK: query: -- This is to test the union->selectstar->filesink optimization -- Union of 2 map-reduce subqueries is performed followed by select and a file sink -- However, some columns are repeated. So, union cannot be removed. @@ -28,6 +29,7 @@ POSTHOOK: Output: default@inputTbl1 PREHOOK: query: create table outputTbl1(key string, values bigint, values2 bigint) stored as textfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@outputTbl1 POSTHOOK: query: create table outputTbl1(key string, values bigint, values2 bigint) stored as textfile POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/union_remove_23.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/union_remove_23.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/union_remove_23.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/union_remove_23.q.out Fri Aug 22 21:36:47 2014 @@ -12,6 +12,7 @@ PREHOOK: query: -- This is to test the u create table inputTbl1(key string, val string) stored as textfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@inputTbl1 POSTHOOK: query: -- This is to test the union->selectstar->filesink optimization -- Union of 2 map-reduce subqueries is performed followed by select star and a file sink -- There is no need to write the temporary results of the sub-queries, and then read them @@ -30,6 +31,7 @@ POSTHOOK: Output: default@inputTbl1 PREHOOK: query: create table outputTbl1(key string, values bigint) stored as textfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@outputTbl1 POSTHOOK: query: create table outputTbl1(key string, values bigint) stored as textfile POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/union_remove_24.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/union_remove_24.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/union_remove_24.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/union_remove_24.q.out Fri Aug 22 21:36:47 2014 @@ -10,6 +10,7 @@ PREHOOK: query: -- This is to test the u create table inputTbl1(key string, val string) stored as textfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@inputTbl1 POSTHOOK: query: -- This is to test the union->selectstar->filesink optimization -- Union of 2 map-reduce subqueries is performed followed by select star and a file sink -- There is no need to write the temporary results of the sub-queries, and then read them @@ -26,6 +27,7 @@ POSTHOOK: Output: default@inputTbl1 PREHOOK: query: create table outputTbl1(key double, values bigint) stored as textfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@outputTbl1 POSTHOOK: query: create table outputTbl1(key double, values bigint) stored as textfile POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/union_remove_25.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/union_remove_25.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/union_remove_25.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/union_remove_25.q.out Fri Aug 22 21:36:47 2014 @@ -11,6 +11,7 @@ PREHOOK: query: -- This is to test the u create table inputTbl1(key string, val string) stored as textfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@inputTbl1 POSTHOOK: query: -- This is to test the union->selectstar->filesink optimization -- Union of 2 map-reduce subqueries is performed followed by select star and a file sink -- There is no need to write the temporary results of the sub-queries, and then read them @@ -28,6 +29,7 @@ POSTHOOK: Output: default@inputTbl1 PREHOOK: query: create table outputTbl1(key string, values bigint) partitioned by (ds string) stored as textfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@outputTbl1 POSTHOOK: query: create table outputTbl1(key string, values bigint) partitioned by (ds string) stored as textfile POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -35,6 +37,7 @@ POSTHOOK: Output: default@outputTbl1 PREHOOK: query: create table outputTbl2(key string, values bigint) partitioned by (ds string) stored as textfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@outputTbl2 POSTHOOK: query: create table outputTbl2(key string, values bigint) partitioned by (ds string) stored as textfile POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -42,6 +45,7 @@ POSTHOOK: Output: default@outputTbl2 PREHOOK: query: create table outputTbl3(key string, values bigint) partitioned by (ds string,hr string) stored as textfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@outputTbl3 POSTHOOK: query: create table outputTbl3(key string, values bigint) partitioned by (ds string,hr string) stored as textfile POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/union_remove_3.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/union_remove_3.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/union_remove_3.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/union_remove_3.q.out Fri Aug 22 21:36:47 2014 @@ -12,6 +12,7 @@ PREHOOK: query: -- This is to test the u create table inputTbl1(key string, val string) stored as textfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@inputTbl1 POSTHOOK: query: -- This is to test the union->remove->filesink optimization -- Union of 3 subqueries is performed (all of which are map-only queries) -- followed by select star and a file sink. @@ -30,6 +31,7 @@ POSTHOOK: Output: default@inputTbl1 PREHOOK: query: create table outputTbl1(key string, values bigint) stored as textfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@outputTbl1 POSTHOOK: query: create table outputTbl1(key string, values bigint) stored as textfile POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/union_remove_4.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/union_remove_4.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/union_remove_4.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/union_remove_4.q.out Fri Aug 22 21:36:47 2014 @@ -11,6 +11,7 @@ PREHOOK: query: -- This is to test the u create table inputTbl1(key string, val string) stored as textfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@inputTbl1 POSTHOOK: query: -- This is to test the union->selectstar->filesink optimization -- Union of 2 map-reduce subqueries is performed followed by select star and a file sink -- There is no need to write the temporary results of the sub-queries, and then read them @@ -28,6 +29,7 @@ POSTHOOK: Output: default@inputTbl1 PREHOOK: query: create table outputTbl1(key string, values bigint) stored as textfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@outputTbl1 POSTHOOK: query: create table outputTbl1(key string, values bigint) stored as textfile POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/union_remove_5.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/union_remove_5.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/union_remove_5.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/union_remove_5.q.out Fri Aug 22 21:36:47 2014 @@ -13,6 +13,7 @@ PREHOOK: query: -- This is to test the u create table inputTbl1(key string, val string) stored as textfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@inputTbl1 POSTHOOK: query: -- This is to test the union->selectstar->filesink optimization -- Union of 3 subqueries is performed (exactly one of which requires a map-reduce job) -- followed by select star and a file sink. @@ -32,6 +33,7 @@ POSTHOOK: Output: default@inputTbl1 PREHOOK: query: create table outputTbl1(key string, values bigint) stored as textfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@outputTbl1 POSTHOOK: query: create table outputTbl1(key string, values bigint) stored as textfile POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/union_remove_6.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/union_remove_6.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/union_remove_6.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/union_remove_6.q.out Fri Aug 22 21:36:47 2014 @@ -8,6 +8,7 @@ PREHOOK: query: -- This is to test the u create table inputTbl1(key string, val string) stored as textfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@inputTbl1 POSTHOOK: query: -- This is to test the union->selectstar->filesink optimization -- Union of 2 subqueries is performed (all of which are mapred queries) -- followed by select star and a file sink in 2 output tables. @@ -22,6 +23,7 @@ POSTHOOK: Output: default@inputTbl1 PREHOOK: query: create table outputTbl1(key string, values bigint) stored as textfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@outputTbl1 POSTHOOK: query: create table outputTbl1(key string, values bigint) stored as textfile POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -29,6 +31,7 @@ POSTHOOK: Output: default@outputTbl1 PREHOOK: query: create table outputTbl2(key string, values bigint) stored as textfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@outputTbl2 POSTHOOK: query: create table outputTbl2(key string, values bigint) stored as textfile POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/union_remove_7.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/union_remove_7.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/union_remove_7.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/union_remove_7.q.out Fri Aug 22 21:36:47 2014 @@ -13,6 +13,7 @@ PREHOOK: query: -- This is to test the u create table inputTbl1(key string, val string) stored as textfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@inputTbl1 POSTHOOK: query: -- This is to test the union->selectstar->filesink optimization -- Union of 2 map-reduce subqueries is performed followed by select star and a file sink -- There is no need to write the temporary results of the sub-queries, and then read them @@ -32,6 +33,7 @@ POSTHOOK: Output: default@inputTbl1 PREHOOK: query: create table outputTbl1(key string, values bigint) stored as rcfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@outputTbl1 POSTHOOK: query: create table outputTbl1(key string, values bigint) stored as rcfile POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/union_remove_8.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/union_remove_8.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/union_remove_8.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/union_remove_8.q.out Fri Aug 22 21:36:47 2014 @@ -14,6 +14,7 @@ PREHOOK: query: -- This is to test the u create table inputTbl1(key string, val string) stored as textfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@inputTbl1 POSTHOOK: query: -- This is to test the union->selectstar->filesink optimization -- Union of 3 subqueries is performed (exactly one of which requires a map-reduce job) -- followed by select star and a file sink. @@ -34,6 +35,7 @@ POSTHOOK: Output: default@inputTbl1 PREHOOK: query: create table outputTbl1(key string, values bigint) stored as rcfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@outputTbl1 POSTHOOK: query: create table outputTbl1(key string, values bigint) stored as rcfile POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/union_remove_9.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/union_remove_9.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/union_remove_9.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/union_remove_9.q.out Fri Aug 22 21:36:47 2014 @@ -13,6 +13,7 @@ PREHOOK: query: -- This is to test the u create table inputTbl1(key string, val string) stored as textfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@inputTbl1 POSTHOOK: query: -- This is to test the union->selectstar->filesink optimization -- Union of 2 subqueries is performed (one of which contains a union and is map-only), -- and the other one is a map-reduce query followed by select star and a file sink. @@ -32,6 +33,7 @@ POSTHOOK: Output: default@inputTbl1 PREHOOK: query: create table outputTbl1(key string, values bigint) stored as rcfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@outputTbl1 POSTHOOK: query: create table outputTbl1(key string, values bigint) stored as rcfile POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/union_top_level.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/union_top_level.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/union_top_level.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/union_top_level.q.out Fri Aug 22 21:36:47 2014 @@ -260,10 +260,10 @@ STAGE PLANS: condition expressions: 0 {KEY.reducesinkkey0} 1 {VALUE._col0} - outputColumnNames: _col0, _col5 + outputColumnNames: _col0, _col6 Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col5 (type: string) + expressions: _col0 (type: string), _col6 (type: string) outputColumnNames: _col0, _col1 Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE Limit @@ -364,10 +364,10 @@ STAGE PLANS: condition expressions: 0 {KEY.reducesinkkey0} 1 {VALUE._col0} - outputColumnNames: _col0, _col5 + outputColumnNames: _col0, _col6 Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col5 (type: string) + expressions: _col0 (type: string), _col6 (type: string) outputColumnNames: _col0, _col1 Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE Limit Modified: hive/branches/cbo/ql/src/test/results/clientpositive/union_view.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/union_view.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/union_view.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/union_view.q.out Fri Aug 22 21:36:47 2014 @@ -1,38 +1,47 @@ PREHOOK: query: CREATE TABLE src_union_1 (key int, value string) PARTITIONED BY (ds string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@src_union_1 POSTHOOK: query: CREATE TABLE src_union_1 (key int, value string) PARTITIONED BY (ds string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@src_union_1 PREHOOK: query: CREATE INDEX src_union_1_key_idx ON TABLE src_union_1(key) AS 'COMPACT' WITH DEFERRED REBUILD PREHOOK: type: CREATEINDEX +PREHOOK: Input: default@src_union_1 POSTHOOK: query: CREATE INDEX src_union_1_key_idx ON TABLE src_union_1(key) AS 'COMPACT' WITH DEFERRED REBUILD POSTHOOK: type: CREATEINDEX +POSTHOOK: Input: default@src_union_1 POSTHOOK: Output: default@default__src_union_1_src_union_1_key_idx__ PREHOOK: query: CREATE TABLE src_union_2 (key int, value string) PARTITIONED BY (ds string, part_1 string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@src_union_2 POSTHOOK: query: CREATE TABLE src_union_2 (key int, value string) PARTITIONED BY (ds string, part_1 string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@src_union_2 PREHOOK: query: CREATE INDEX src_union_2_key_idx ON TABLE src_union_2(key) AS 'COMPACT' WITH DEFERRED REBUILD PREHOOK: type: CREATEINDEX +PREHOOK: Input: default@src_union_2 POSTHOOK: query: CREATE INDEX src_union_2_key_idx ON TABLE src_union_2(key) AS 'COMPACT' WITH DEFERRED REBUILD POSTHOOK: type: CREATEINDEX +POSTHOOK: Input: default@src_union_2 POSTHOOK: Output: default@default__src_union_2_src_union_2_key_idx__ PREHOOK: query: CREATE TABLE src_union_3(key int, value string) PARTITIONED BY (ds string, part_1 string, part_2 string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@src_union_3 POSTHOOK: query: CREATE TABLE src_union_3(key int, value string) PARTITIONED BY (ds string, part_1 string, part_2 string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@src_union_3 PREHOOK: query: CREATE INDEX src_union_3_key_idx ON TABLE src_union_3(key) AS 'COMPACT' WITH DEFERRED REBUILD PREHOOK: type: CREATEINDEX +PREHOOK: Input: default@src_union_3 POSTHOOK: query: CREATE INDEX src_union_3_key_idx ON TABLE src_union_3(key) AS 'COMPACT' WITH DEFERRED REBUILD POSTHOOK: type: CREATEINDEX +POSTHOOK: Input: default@src_union_3 POSTHOOK: Output: default@default__src_union_3_src_union_3_key_idx__ STAGE DEPENDENCIES: Stage-3 is a root stage Modified: hive/branches/cbo/ql/src/test/results/clientpositive/uniquejoin.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/uniquejoin.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/uniquejoin.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/uniquejoin.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE T1(key STRING, val STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@T1 POSTHOOK: query: CREATE TABLE T1(key STRING, val STRING) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -8,6 +9,7 @@ POSTHOOK: Output: default@T1 PREHOOK: query: CREATE TABLE T2(key STRING, val STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@T2 POSTHOOK: query: CREATE TABLE T2(key STRING, val STRING) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -15,6 +17,7 @@ POSTHOOK: Output: default@T2 PREHOOK: query: CREATE TABLE T3(key STRING, val STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@T3 POSTHOOK: query: CREATE TABLE T3(key STRING, val STRING) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/unset_table_view_property.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/unset_table_view_property.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/unset_table_view_property.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/unset_table_view_property.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE testTable(col1 INT, col2 INT) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@testTable POSTHOOK: query: CREATE TABLE testTable(col1 INT, col2 INT) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/updateAccessTime.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/updateAccessTime.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/updateAccessTime.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/updateAccessTime.q.out Fri Aug 22 21:36:47 2014 @@ -53,6 +53,7 @@ POSTHOOK: type: DROPTABLE PREHOOK: query: create table tstsrcpart like srcpart PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@tstsrcpart POSTHOOK: query: create table tstsrcpart like srcpart POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/varchar_1.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/varchar_1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/varchar_1.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/varchar_1.q.out Fri Aug 22 21:36:47 2014 @@ -9,6 +9,7 @@ POSTHOOK: type: DROPTABLE PREHOOK: query: create table varchar1 (key varchar(10), value varchar(20)) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@varchar1 POSTHOOK: query: create table varchar1 (key varchar(10), value varchar(20)) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -16,6 +17,7 @@ POSTHOOK: Output: default@varchar1 PREHOOK: query: create table varchar1_1 (key string, value string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@varchar1_1 POSTHOOK: query: create table varchar1_1 (key string, value string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/varchar_2.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/varchar_2.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/varchar_2.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/varchar_2.q.out Fri Aug 22 21:36:47 2014 @@ -8,6 +8,7 @@ PREHOOK: query: create table varchar_2 ( ) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@varchar_2 POSTHOOK: query: create table varchar_2 ( key varchar(10), value varchar(20) Modified: hive/branches/cbo/ql/src/test/results/clientpositive/varchar_join1.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/varchar_join1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/varchar_join1.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/varchar_join1.q.out Fri Aug 22 21:36:47 2014 @@ -16,6 +16,7 @@ PREHOOK: query: create table varchar_jo ) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@varchar_join1_vc1 POSTHOOK: query: create table varchar_join1_vc1 ( c1 int, c2 varchar(10) @@ -29,6 +30,7 @@ PREHOOK: query: create table varchar_jo ) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@varchar_join1_vc2 POSTHOOK: query: create table varchar_join1_vc2 ( c1 int, c2 varchar(20) @@ -42,6 +44,7 @@ PREHOOK: query: create table varchar_jo ) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@varchar_join1_str POSTHOOK: query: create table varchar_join1_str ( c1 int, c2 string Modified: hive/branches/cbo/ql/src/test/results/clientpositive/varchar_nested_types.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/varchar_nested_types.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/varchar_nested_types.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/varchar_nested_types.q.out Fri Aug 22 21:36:47 2014 @@ -25,6 +25,7 @@ POSTHOOK: type: DROPTABLE PREHOOK: query: create table varchar_nested_1 (key int, value varchar(20)) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@varchar_nested_1 POSTHOOK: query: create table varchar_nested_1 (key int, value varchar(20)) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -45,6 +46,7 @@ PREHOOK: query: -- arrays create table varchar_nested_array (c1 array<varchar(20)>) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@varchar_nested_array POSTHOOK: query: -- arrays create table varchar_nested_array (c1 array<varchar(20)>) POSTHOOK: type: CREATETABLE @@ -81,6 +83,7 @@ PREHOOK: query: -- maps create table varchar_nested_map (c1 map<int, varchar(20)>) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@varchar_nested_map POSTHOOK: query: -- maps create table varchar_nested_map (c1 map<int, varchar(20)>) POSTHOOK: type: CREATETABLE @@ -117,6 +120,7 @@ PREHOOK: query: -- structs create table varchar_nested_struct (c1 struct<a:int, b:varchar(20), c:string>) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@varchar_nested_struct POSTHOOK: query: -- structs create table varchar_nested_struct (c1 struct<a:int, b:varchar(20), c:string>) POSTHOOK: type: CREATETABLE Modified: hive/branches/cbo/ql/src/test/results/clientpositive/varchar_serde.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/varchar_serde.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/varchar_serde.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/varchar_serde.q.out Fri Aug 22 21:36:47 2014 @@ -36,6 +36,7 @@ with serdeproperties ( stored as textfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@varchar_serde_regex POSTHOOK: query: -- -- RegexSerDe -- @@ -94,6 +95,7 @@ create table varchar_serde_lb ( ) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@varchar_serde_lb POSTHOOK: query: -- -- LazyBinary -- @@ -159,6 +161,7 @@ create table varchar_serde_ls ( ) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@varchar_serde_ls POSTHOOK: query: -- -- LazySimple -- @@ -224,6 +227,7 @@ create table varchar_serde_c ( ) stored as rcfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@varchar_serde_c POSTHOOK: query: -- -- Columnar -- @@ -289,6 +293,7 @@ create table varchar_serde_lbc ( ) stored as rcfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@varchar_serde_lbc POSTHOOK: query: -- -- LazyBinaryColumnar -- @@ -354,6 +359,7 @@ create table varchar_serde_orc ( ) stored as orc PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@varchar_serde_orc POSTHOOK: query: -- -- ORC -- Modified: hive/branches/cbo/ql/src/test/results/clientpositive/varchar_udf1.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/varchar_udf1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/varchar_udf1.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/varchar_udf1.q.out Fri Aug 22 21:36:47 2014 @@ -5,6 +5,7 @@ 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 Modified: hive/branches/cbo/ql/src/test/results/clientpositive/varchar_union1.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/varchar_union1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/varchar_union1.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/varchar_union1.q.out Fri Aug 22 21:36:47 2014 @@ -16,6 +16,7 @@ PREHOOK: query: create table varchar_un ) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@varchar_union1_vc1 POSTHOOK: query: create table varchar_union1_vc1 ( c1 int, c2 varchar(10) @@ -29,6 +30,7 @@ PREHOOK: query: create table varchar_un ) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@varchar_union1_vc2 POSTHOOK: query: create table varchar_union1_vc2 ( c1 int, c2 varchar(20) @@ -42,6 +44,7 @@ PREHOOK: query: create table varchar_un ) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@varchar_union1_str POSTHOOK: query: create table varchar_union1_str ( c1 int, c2 string Modified: hive/branches/cbo/ql/src/test/results/clientpositive/vector_between_in.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/vector_between_in.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/vector_between_in.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/vector_between_in.q.out Fri Aug 22 21:36:47 2014 @@ -640,34 +640,34 @@ POSTHOOK: Input: default@decimal_date_te -18.5162162162 -17.3216216216 -16.7243243243 --16.127027027 +-16.1270270270 -15.5297297297 -10.7513513514 -9.5567567568 -8.3621621622 --5.972972973 +-5.9729729730 -3.5837837838 4.1810810811 4.7783783784 4.7783783784 5.3756756757 -5.972972973 -5.972972973 +5.9729729730 +5.9729729730 11.3486486486 11.3486486486 11.9459459459 14.9324324324 19.1135135135 20.3081081081 -22.1 +22.1000000000 24.4891891892 33.4486486486 34.6432432432 40.0189189189 42.4081081081 43.0054054054 -44.2 -44.2 +44.2000000000 +44.2000000000 44.7972972973 45.9918918919 PREHOOK: query: SELECT COUNT(*) FROM decimal_date_test WHERE cdecimal1 NOT BETWEEN -2000 AND 4390.1351351351 Modified: hive/branches/cbo/ql/src/test/results/clientpositive/vector_cast_constant.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/vector_cast_constant.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/vector_cast_constant.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/vector_cast_constant.q.out Fri Aug 22 21:36:47 2014 @@ -22,6 +22,7 @@ ROW FORMAT DELIMITED FIELDS TERMINATED B 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, @@ -61,6 +62,7 @@ PREHOOK: query: CREATE TABLE over1korc(t 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, Modified: hive/branches/cbo/ql/src/test/results/clientpositive/vector_data_types.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/vector_data_types.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/vector_data_types.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/vector_data_types.q.out Fri Aug 22 21:36:47 2014 @@ -22,6 +22,7 @@ ROW FORMAT DELIMITED FIELDS TERMINATED B 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, @@ -61,6 +62,7 @@ PREHOOK: query: CREATE TABLE over1korc(t 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, @@ -149,7 +151,7 @@ POSTHOOK: query: SELECT t, si, i, b, f, POSTHOOK: type: QUERY POSTHOOK: Input: default@over1korc #### A masked pattern was here #### -108 301 65536 4294967357 90.05 17.59 true ethan johnson 2013-03-01 09:11:58.703271 75.7 undecided +108 301 65536 4294967357 90.05 17.59 true ethan johnson 2013-03-01 09:11:58.703271 75.70 undecided 118 497 65536 4294967381 50.32 12.72 false david nixon 2013-03-01 09:11:58.703285 83.48 values clariffication 18 280 65536 4294967320 32.92 45.94 false holly white 2013-03-01 09:11:58.703086 58.86 topology 69 489 65536 4294967404 33.52 17.99 false oscar ichabod 2013-03-01 09:11:58.703247 32.68 topology @@ -224,7 +226,7 @@ POSTHOOK: query: SELECT t, si, i, b, f, POSTHOOK: type: QUERY POSTHOOK: Input: default@over1korc #### A masked pattern was here #### -108 301 65536 4294967357 90.05 17.59 true ethan johnson 1860-11-12 20:05:55.011470936 75.7 undecided +108 301 65536 4294967357 90.05 17.59 true ethan johnson 1860-11-12 20:05:55.011470936 75.70 undecided 118 497 65536 4294967381 50.32 12.72 false david nixon 1860-11-12 20:05:55.011484936 83.48 values clariffication 18 280 65536 4294967320 32.92 45.94 false holly white 1860-11-12 20:05:55.011285936 58.86 topology 69 489 65536 4294967404 33.52 17.99 false oscar ichabod 1860-11-12 20:05:55.011446936 32.68 topology Modified: hive/branches/cbo/ql/src/test/results/clientpositive/vector_decimal_aggregate.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/vector_decimal_aggregate.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/vector_decimal_aggregate.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/vector_decimal_aggregate.q.out Fri Aug 22 21:36:47 2014 @@ -101,11 +101,11 @@ POSTHOOK: query: SELECT cint, POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_vgby #### A masked pattern was here #### -NULL 3072 9318.4351351351 -4298.1513513514 5018444.1081079808 1633.60810810806667 5695.483082135364 5696.4103077145055 3072 11160.715384615385 -5147.907692307693 6010604.3076923073536 1956.576923076922966667 6821.495748565159 6822.606289190924 --3728 6 5831542.269248378 -3367.6517567568 5817556.0411483778 969592.67352472963333 2174330.2092403853 2381859.406131774 6 6984454.211097692 -4033.445769230769 6967702.8672438458471 1161283.811207307641183333 2604201.2704476737 2852759.5602156054 --563 2 -515.621072973 -3367.6517567568 -3883.2728297298 -1941.6364148649 1426.0153418918999 2016.6902366556308 2 -617.5607769230769 -4033.445769230769 -4651.0065461538459 -2325.50327307692295 1707.9424961538462 2415.395441814127 -762 2 5831542.269248378 1531.2194054054 5833073.4886537834 2916536.7443268917 2915005.5249214866 4122440.3477364695 2 6984454.211097692 1833.9456923076925 6986288.1567899996925 3493144.07839499984625 3491310.1327026924 4937458.140118758 -6981 3 5831542.269248378 -515.621072973 5830511.027102432 1943503.67570081066667 2749258.455012492 3367140.1929065133 3 6984454.211097692 -617.5607769230769 6983219.0895438458462 2327739.696514615282066667 3292794.4113115156 4032833.0678006653 -253665376 1024 9767.0054054054 -9779.5486486487 -347484.0818378374 -339.33992366976309 5708.9563478862 5711.745967572779 1024 11697.969230769231 -11712.99230769231 -416182.64030769233089 -406.428359675480791885 6837.632716002934 6840.973851172274 -528534767 1024 5831542.269248378 -9777.1594594595 11646372.8607481068 11373.41099682432305 257528.92988206653 257654.7686043977 1024 6984454.211097692 -11710.130769230771 13948892.79980307629003 13621.965624807691689482 308443.1074570801 308593.82484083984 -626923679 1024 9723.4027027027 -9778.9513513514 10541.0525297287 10.29399661106318 5742.09145323734 5744.897264034267 1024 11645.746153846154 -11712.276923076923 12625.04759999997746 12.329148046874977988 6877.318722794877 6880.679250101603 +NULL 3072 9318.4351351351 -4298.1513513514 5018444.1081079808 1633.60810810806667 5695.483082135364 5696.4103077145055 3072 11160.71538461538500 -5147.90769230769300 6010604.30769230735360 1956.576923076922966667 6821.495748565159 6822.606289190924 +-3728 6 5831542.2692483780 -3367.6517567568 5817556.0411483778 969592.67352472963333 2174330.2092403853 2381859.406131774 6 6984454.21109769200000 -4033.445769230769 6967702.86724384584710 1161283.811207307641183333 2604201.2704476737 2852759.5602156054 +-563 2 -515.6210729730 -3367.6517567568 -3883.2728297298 -1941.6364148649 1426.0153418918999 2016.6902366556308 2 -617.56077692307690 -4033.445769230769 -4651.00654615384590 -2325.50327307692295 1707.9424961538462 2415.395441814127 +762 2 5831542.2692483780 1531.2194054054 5833073.4886537834 2916536.7443268917 2915005.5249214866 4122440.3477364695 2 6984454.21109769200000 1833.9456923076925 6986288.15678999969250 3493144.07839499984625 3491310.1327026924 4937458.140118758 +6981 3 5831542.269248378 -515.6210729730 5830511.0271024320 1943503.67570081066667 2749258.455012492 3367140.1929065133 3 6984454.211097692 -617.56077692307690 6983219.08954384584620 2327739.696514615282066667 3292794.4113115156 4032833.0678006653 +253665376 1024 9767.0054054054 -9779.5486486487 -347484.0818378374 -339.33992366976309 5708.9563478862 5711.745967572779 1024 11697.96923076923100 -11712.99230769231000 -416182.64030769233089 -406.428359675480791885 6837.632716002934 6840.973851172274 +528534767 1024 5831542.2692483780 -9777.1594594595 11646372.8607481068 11373.41099682432305 257528.92988206653 257654.7686043977 1024 6984454.21109769200000 -11710.13076923077100 13948892.79980307629003 13621.965624807691689482 308443.1074570801 308593.82484083984 +626923679 1024 9723.4027027027 -9778.9513513514 10541.0525297287 10.29399661106318 5742.09145323734 5744.897264034267 1024 11645.74615384615400 -11712.27692307692300 12625.04759999997746 12.329148046874977988 6877.318722794877 6880.679250101603 Modified: hive/branches/cbo/ql/src/test/results/clientpositive/vector_decimal_cast.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/vector_decimal_cast.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/vector_decimal_cast.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/vector_decimal_cast.q.out Fri Aug 22 21:36:47 2014 @@ -46,13 +46,13 @@ POSTHOOK: query: SELECT cdouble, cint, c POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc #### A masked pattern was here #### --13326.0 528534767 true 1969-12-31 15:59:46.674 -13326 528534767 1 -13 --15813.0 528534767 true 1969-12-31 15:59:55.787 -15813 528534767 1 -4 --9566.0 528534767 true 1969-12-31 15:59:44.187 -9566 528534767 1 -16 -15007.0 528534767 true 1969-12-31 15:59:50.434 15007 528534767 1 -10 -7021.0 528534767 true 1969-12-31 16:00:15.007 7021 528534767 1 15 -4963.0 528534767 true 1969-12-31 16:00:07.021 4963 528534767 1 7 --7824.0 528534767 true 1969-12-31 16:00:04.963 -7824 528534767 1 5 --15431.0 528534767 true 1969-12-31 15:59:52.176 -15431 528534767 1 -8 --15549.0 528534767 true 1969-12-31 15:59:44.569 -15549 528534767 1 -15 -5780.0 528534767 true 1969-12-31 15:59:44.451 5780 528534767 1 -16 +-13326.0 528534767 true 1969-12-31 15:59:46.674 -13326.0000000000 528534767.00000000000000 1.00 -13 +-15813.0 528534767 true 1969-12-31 15:59:55.787 -15813.0000000000 528534767.00000000000000 1.00 -4 +-9566.0 528534767 true 1969-12-31 15:59:44.187 -9566.0000000000 528534767.00000000000000 1.00 -16 +15007.0 528534767 true 1969-12-31 15:59:50.434 15007.0000000000 528534767.00000000000000 1.00 -10 +7021.0 528534767 true 1969-12-31 16:00:15.007 7021.0000000000 528534767.00000000000000 1.00 15 +4963.0 528534767 true 1969-12-31 16:00:07.021 4963.0000000000 528534767.00000000000000 1.00 7 +-7824.0 528534767 true 1969-12-31 16:00:04.963 -7824.0000000000 528534767.00000000000000 1.00 5 +-15431.0 528534767 true 1969-12-31 15:59:52.176 -15431.0000000000 528534767.00000000000000 1.00 -8 +-15549.0 528534767 true 1969-12-31 15:59:44.569 -15549.0000000000 528534767.00000000000000 1.00 -15 +5780.0 528534767 true 1969-12-31 15:59:44.451 5780.0000000000 528534767.00000000000000 1.00 -16 Modified: hive/branches/cbo/ql/src/test/results/clientpositive/vector_decimal_expressions.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/vector_decimal_expressions.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/vector_decimal_expressions.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/vector_decimal_expressions.q.out Fri Aug 22 21:36:47 2014 @@ -53,13 +53,13 @@ POSTHOOK: query: SELECT cdecimal1 + cdec POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_test #### A masked pattern was here #### -19699.417463617423 -12507.913305613346 0.8351496686995997 2.8303425077026896E7 3.6405405405 8963 10735 -17 8963 true 10735.776923076923 8963.641 10735.776923076923 1969-12-31 18:29:23.64054054 -9216.339708939685 -5851.80644490647 0.8353975893550668 6195112.1797296945 3.6243243243 4193 5022 -98 4193 true 5022.715384615385 4193.6245 5022.715384615385 1969-12-31 17:09:53.624324324 -6514.8403326403464 -4136.5212058211928 0.8355907765708067 3095563.9418919063 4.3864864865 2964 3550 -34 2964 true 3550.4538461538464 2964.3865 3550.4538461538464 1969-12-31 16:49:24.386486486 -7587.301455301477 -4817.467775467754 0.8354976172734904 4198623.24324327 2.3783783784 3452 4134 38 3452 true 4134.923076923077 3452.3784 4134.923076923077 1969-12-31 16:57:32.378378378 -19197.972972973 -12189.527027027 0.835155361813429 2.6880848817567654E7 5.472972973 8735 10462 -34 8735 true 10462.5 8735.473 10462.5 1969-12-31 18:25:35.472972973 -17098.9945945946 -10856.8054054054 0.8351828165813104 2.132423090270272E7 0.3945945946 7780 9318 102 7780 true 9318.6 7780.3945 9318.6 1969-12-31 18:09:40.394594594 -12433.723076923077 -7894.646153846154 0.8352770361086894 1.12754688E7 7.6 5657 6776 120 5657 true 6776.123076923077 5657.6 6776.123076923077 1969-12-31 17:34:17.6 -7247.316839916862 -4601.598544698524 0.8355241651897876 3830775.6932432684 7.6783783784 3297 3949 109 3297 true 3949.638461538462 3297.6785 3949.638461538462 1969-12-31 16:54:57.678378378 -14757.1700623700465 -9369.891476091493 0.8352226654922171 1.5883214124324286E7 4.8162162162 6714 8042 106 6714 true 8042.3538461538465 6714.8164 8042.3538461538465 1969-12-31 17:51:54.816216216 -10964.832016631993 -6961.991060291086 0.8353232978714221 8768719.779729689 9.2243243243 4989 5975 87 4989 true 5975.607692307693 4989.224 5975.607692307693 1969-12-31 17:23:09.224324324 +19699.41746361742300 -12507.91330561334600 0.8351496686995997 2.8303425077026896E7 3.6405405405 8963 10735 -17 8963 true 10735.776923076923 8963.641 10735.776923076923 1969-12-31 18:29:23.64054054 +9216.33970893968500 -5851.80644490647000 0.8353975893550668 6195112.1797296945 3.6243243243 4193 5022 -98 4193 true 5022.715384615385 4193.6245 5022.715384615385 1969-12-31 17:09:53.624324324 +6514.84033264034640 -4136.52120582119280 0.8355907765708067 3095563.9418919063 4.3864864865 2964 3550 -34 2964 true 3550.4538461538464 2964.3865 3550.4538461538464 1969-12-31 16:49:24.386486486 +7587.30145530147700 -4817.46777546775400 0.8354976172734904 4198623.24324327 2.3783783784 3452 4134 38 3452 true 4134.923076923077 3452.3784 4134.923076923077 1969-12-31 16:57:32.378378378 +19197.97297297300000 -12189.52702702700000 0.835155361813429 2.6880848817567654E7 5.4729729730 8735 10462 -34 8735 true 10462.5 8735.473 10462.5 1969-12-31 18:25:35.472972973 +17098.99459459460000 -10856.80540540540000 0.8351828165813104 2.132423090270272E7 0.3945945946 7780 9318 102 7780 true 9318.6 7780.3945 9318.6 1969-12-31 18:09:40.394594594 +12433.72307692307700 -7894.64615384615400 0.8352770361086894 1.12754688E7 7.6000000000 5657 6776 120 5657 true 6776.123076923077 5657.6 6776.123076923077 1969-12-31 17:34:17.6 +7247.31683991686200 -4601.59854469852400 0.8355241651897876 3830775.6932432684 7.6783783784 3297 3949 109 3297 true 3949.638461538462 3297.6785 3949.638461538462 1969-12-31 16:54:57.678378378 +14757.17006237004650 -9369.89147609149300 0.8352226654922171 1.5883214124324286E7 4.8162162162 6714 8042 106 6714 true 8042.3538461538465 6714.8164 8042.3538461538465 1969-12-31 17:51:54.816216216 +10964.83201663199300 -6961.99106029108600 0.8353232978714221 8768719.779729689 9.2243243243 4989 5975 87 4989 true 5975.607692307693 4989.224 5975.607692307693 1969-12-31 17:23:09.224324324 Modified: hive/branches/cbo/ql/src/test/results/clientpositive/vector_decimal_mapjoin.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/vector_decimal_mapjoin.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/vector_decimal_mapjoin.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/vector_decimal_mapjoin.q.out Fri Aug 22 21:36:47 2014 @@ -69,10 +69,10 @@ STAGE PLANS: keys: 0 6981 (type: int) 1 6981 (type: int) - outputColumnNames: _col1, _col8 + outputColumnNames: _col1, _col9 Statistics: Num rows: 3379 Data size: 595391 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: 6981 (type: int), 6981 (type: int), _col1 (type: decimal(20,10)), _col8 (type: decimal(23,14)) + expressions: 6981 (type: int), 6981 (type: int), _col1 (type: decimal(20,10)), _col9 (type: decimal(23,14)) outputColumnNames: _col0, _col1, _col2, _col3 Statistics: Num rows: 3379 Data size: 595391 Basic stats: COMPLETE Column stats: NONE File Output Operator @@ -114,8 +114,8 @@ POSTHOOK: Input: default@decimal_mapjoin 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 -515.621072973 NULL -6981 6981 -515.621072973 NULL +6981 6981 -515.6210729730 NULL +6981 6981 -515.6210729730 NULL 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL @@ -124,8 +124,8 @@ POSTHOOK: Input: default@decimal_mapjoin 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 -515.621072973 NULL -6981 6981 -515.621072973 NULL +6981 6981 -515.6210729730 NULL +6981 6981 -515.6210729730 NULL 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL @@ -134,8 +134,8 @@ POSTHOOK: Input: default@decimal_mapjoin 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 -515.621072973 NULL -6981 6981 -515.621072973 NULL +6981 6981 -515.6210729730 NULL +6981 6981 -515.6210729730 NULL 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL @@ -144,8 +144,8 @@ POSTHOOK: Input: default@decimal_mapjoin 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 -515.621072973 NULL -6981 6981 -515.621072973 NULL +6981 6981 -515.6210729730 NULL +6981 6981 -515.6210729730 NULL 6981 6981 NULL 6984454.211097692 6981 6981 NULL 6984454.211097692 6981 6981 NULL 6984454.211097692 @@ -154,8 +154,8 @@ POSTHOOK: Input: default@decimal_mapjoin 6981 6981 NULL 6984454.211097692 6981 6981 NULL 6984454.211097692 6981 6981 NULL 6984454.211097692 -6981 6981 -515.621072973 6984454.211097692 -6981 6981 -515.621072973 6984454.211097692 +6981 6981 -515.6210729730 6984454.211097692 +6981 6981 -515.6210729730 6984454.211097692 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL @@ -164,8 +164,8 @@ POSTHOOK: Input: default@decimal_mapjoin 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 -515.621072973 NULL -6981 6981 -515.621072973 NULL +6981 6981 -515.6210729730 NULL +6981 6981 -515.6210729730 NULL 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL @@ -174,8 +174,8 @@ POSTHOOK: Input: default@decimal_mapjoin 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 -515.621072973 NULL -6981 6981 -515.621072973 NULL +6981 6981 -515.6210729730 NULL +6981 6981 -515.6210729730 NULL 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL @@ -184,8 +184,8 @@ POSTHOOK: Input: default@decimal_mapjoin 6981 6981 NULL NULL 6981 6981 NULL NULL 6981 6981 NULL NULL -6981 6981 -515.621072973 NULL -6981 6981 -515.621072973 NULL +6981 6981 -515.6210729730 NULL +6981 6981 -515.6210729730 NULL 6981 6981 NULL -617.5607769230769 6981 6981 NULL -617.5607769230769 6981 6981 NULL -617.5607769230769 @@ -194,8 +194,8 @@ POSTHOOK: Input: default@decimal_mapjoin 6981 6981 NULL -617.5607769230769 6981 6981 NULL -617.5607769230769 6981 6981 NULL -617.5607769230769 -6981 6981 -515.621072973 -617.5607769230769 -6981 6981 -515.621072973 -617.5607769230769 +6981 6981 -515.6210729730 -617.5607769230769 +6981 6981 -515.6210729730 -617.5607769230769 6981 6981 NULL -617.5607769230769 6981 6981 NULL -617.5607769230769 6981 6981 NULL -617.5607769230769 @@ -204,5 +204,5 @@ POSTHOOK: Input: default@decimal_mapjoin 6981 6981 NULL -617.5607769230769 6981 6981 NULL -617.5607769230769 6981 6981 NULL -617.5607769230769 -6981 6981 -515.621072973 -617.5607769230769 -6981 6981 -515.621072973 -617.5607769230769 +6981 6981 -515.6210729730 -617.5607769230769 +6981 6981 -515.6210729730 -617.5607769230769 Modified: hive/branches/cbo/ql/src/test/results/clientpositive/vector_decimal_math_funcs.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/vector_decimal_math_funcs.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/vector_decimal_math_funcs.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/vector_decimal_math_funcs.q.out Fri Aug 22 21:36:47 2014 @@ -192,14 +192,14 @@ and sin(cdecimal1) >= -1.0 POSTHOOK: type: QUERY POSTHOOK: Input: default@decimal_test #### A masked pattern was here #### --119.4594594595 -119.46 -119 -120 -119 1.316485E-52 NULL NULL NULL NULL NULL NULL NULL NULL 119.4594594595 -0.07885666683797002 NaN 0.9968859644388647 NaN -1.5624254815943668 -6844.522849943508 -2.0849608902209606 -119.4594594595 119.4594594595 -1 NULL -9318.4351351351 9318.44 9318 9318 9319 Infinity 9.13974998962673 3.969342986470191 13.185871984999437 NULL 13.185871984999437 173.867220004793 173.867220004793 96.53204201266593 9318.4351351351 0.4540668481851705 NaN 0.8909676185918236 NaN 1.5706890126394983 533907.0049096602 162.63737424163023 9318.4351351351 -9318.4351351351 1 -0.9607267417229353 -9318.4351351351 9318.44 9318 9318 9319 Infinity 9.13974998962673 3.969342986470191 13.185871984999437 NULL 13.185871984999437 173.867220004793 173.867220004793 96.53204201266593 9318.4351351351 0.4540668481851705 NaN 0.8909676185918236 NaN 1.5706890126394983 533907.0049096602 162.63737424163023 9318.4351351351 -9318.4351351351 1 -0.9607267417229353 -9318.4351351351 9318.44 9318 9318 9319 Infinity 9.13974998962673 3.969342986470191 13.185871984999437 NULL 13.185871984999437 173.867220004793 173.867220004793 96.53204201266593 9318.4351351351 0.4540668481851705 NaN 0.8909676185918236 NaN 1.5706890126394983 533907.0049096602 162.63737424163023 9318.4351351351 -9318.4351351351 1 -0.9607267417229353 --4298.1513513514 -4298.15 -4298 -4299 -4298 0.0 NULL NULL NULL NULL NULL NULL NULL NULL 4298.1513513514 -0.43730633941118113 NaN 0.899312607223313 NaN -1.5705636686355597 -246265.93214088667 -75.01689283012556 -4298.1513513514 4298.1513513514 -1 NULL --4298.1513513514 -4298.15 -4298 -4299 -4298 0.0 NULL NULL NULL NULL NULL NULL NULL NULL 4298.1513513514 -0.43730633941118113 NaN 0.899312607223313 NaN -1.5705636686355597 -246265.93214088667 -75.01689283012556 -4298.1513513514 4298.1513513514 -1 NULL --4298.1513513514 -4298.15 -4298 -4299 -4298 0.0 NULL NULL NULL NULL NULL NULL NULL NULL 4298.1513513514 -0.43730633941118113 NaN 0.899312607223313 NaN -1.5705636686355597 -246265.93214088667 -75.01689283012556 -4298.1513513514 4298.1513513514 -1 NULL --4298.1513513514 -4298.15 -4298 -4299 -4298 0.0 NULL NULL NULL NULL NULL NULL NULL NULL 4298.1513513514 -0.43730633941118113 NaN 0.899312607223313 NaN -1.5705636686355597 -246265.93214088667 -75.01689283012556 -4298.1513513514 4298.1513513514 -1 NULL --4298.1513513514 -4298.15 -4298 -4299 -4298 0.0 NULL NULL NULL NULL NULL NULL NULL NULL 4298.1513513514 -0.43730633941118113 NaN 0.899312607223313 NaN -1.5705636686355597 -246265.93214088667 -75.01689283012556 -4298.1513513514 4298.1513513514 -1 NULL --4298.1513513514 -4298.15 -4298 -4299 -4298 0.0 NULL NULL NULL NULL NULL NULL NULL NULL 4298.1513513514 -0.43730633941118113 NaN 0.899312607223313 NaN -1.5705636686355597 -246265.93214088667 -75.01689283012556 -4298.1513513514 4298.1513513514 -1 NULL --4298.1513513514 -4298.15 -4298 -4299 -4298 0.0 NULL NULL NULL NULL NULL NULL NULL NULL 4298.1513513514 -0.43730633941118113 NaN 0.899312607223313 NaN -1.5705636686355597 -246265.93214088667 -75.01689283012556 -4298.1513513514 4298.1513513514 -1 NULL +-119.4594594595 -119.46 -119 -120 -119 1.316485E-52 NULL NULL NULL NULL NULL NULL NULL NULL 119.459459459500000000 -0.07885666683797002 NaN 0.9968859644388647 NaN -1.5624254815943668 -6844.522849943508 -2.0849608902209606 -119.4594594595 119.4594594595 -1 NULL +9318.4351351351 9318.44 9318 9318 9319 Infinity 9.13974998962673 3.969342986470191 13.185871984999437 NULL 13.185871984999437 173.867220004793 173.867220004793 96.53204201266593 9318.435135135100000000 0.4540668481851705 NaN 0.8909676185918236 NaN 1.5706890126394983 533907.0049096602 162.63737424163023 9318.4351351351 -9318.4351351351 1 -0.9607267417229353 +9318.4351351351 9318.44 9318 9318 9319 Infinity 9.13974998962673 3.969342986470191 13.185871984999437 NULL 13.185871984999437 173.867220004793 173.867220004793 96.53204201266593 9318.435135135100000000 0.4540668481851705 NaN 0.8909676185918236 NaN 1.5706890126394983 533907.0049096602 162.63737424163023 9318.4351351351 -9318.4351351351 1 -0.9607267417229353 +9318.4351351351 9318.44 9318 9318 9319 Infinity 9.13974998962673 3.969342986470191 13.185871984999437 NULL 13.185871984999437 173.867220004793 173.867220004793 96.53204201266593 9318.435135135100000000 0.4540668481851705 NaN 0.8909676185918236 NaN 1.5706890126394983 533907.0049096602 162.63737424163023 9318.4351351351 -9318.4351351351 1 -0.9607267417229353 +-4298.1513513514 -4298.15 -4298 -4299 -4298 0.0 NULL NULL NULL NULL NULL NULL NULL NULL 4298.151351351400000000 -0.43730633941118113 NaN 0.899312607223313 NaN -1.5705636686355597 -246265.93214088667 -75.01689283012556 -4298.1513513514 4298.1513513514 -1 NULL +-4298.1513513514 -4298.15 -4298 -4299 -4298 0.0 NULL NULL NULL NULL NULL NULL NULL NULL 4298.151351351400000000 -0.43730633941118113 NaN 0.899312607223313 NaN -1.5705636686355597 -246265.93214088667 -75.01689283012556 -4298.1513513514 4298.1513513514 -1 NULL +-4298.1513513514 -4298.15 -4298 -4299 -4298 0.0 NULL NULL NULL NULL NULL NULL NULL NULL 4298.151351351400000000 -0.43730633941118113 NaN 0.899312607223313 NaN -1.5705636686355597 -246265.93214088667 -75.01689283012556 -4298.1513513514 4298.1513513514 -1 NULL +-4298.1513513514 -4298.15 -4298 -4299 -4298 0.0 NULL NULL NULL NULL NULL NULL NULL NULL 4298.151351351400000000 -0.43730633941118113 NaN 0.899312607223313 NaN -1.5705636686355597 -246265.93214088667 -75.01689283012556 -4298.1513513514 4298.1513513514 -1 NULL +-4298.1513513514 -4298.15 -4298 -4299 -4298 0.0 NULL NULL NULL NULL NULL NULL NULL NULL 4298.151351351400000000 -0.43730633941118113 NaN 0.899312607223313 NaN -1.5705636686355597 -246265.93214088667 -75.01689283012556 -4298.1513513514 4298.1513513514 -1 NULL +-4298.1513513514 -4298.15 -4298 -4299 -4298 0.0 NULL NULL NULL NULL NULL NULL NULL NULL 4298.151351351400000000 -0.43730633941118113 NaN 0.899312607223313 NaN -1.5705636686355597 -246265.93214088667 -75.01689283012556 -4298.1513513514 4298.1513513514 -1 NULL +-4298.1513513514 -4298.15 -4298 -4299 -4298 0.0 NULL NULL NULL NULL NULL NULL NULL NULL 4298.151351351400000000 -0.43730633941118113 NaN 0.899312607223313 NaN -1.5705636686355597 -246265.93214088667 -75.01689283012556 -4298.1513513514 4298.1513513514 -1 NULL Modified: hive/branches/cbo/ql/src/test/results/clientpositive/vector_non_string_partition.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/vector_non_string_partition.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/vector_non_string_partition.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/vector_non_string_partition.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE non_string_part(cint INT, cstring1 STRING, cdouble DOUBLE, ctimestamp1 TIMESTAMP) PARTITIONED BY (ctinyint tinyint) STORED AS ORC PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@non_string_part POSTHOOK: query: CREATE TABLE non_string_part(cint INT, cstring1 STRING, cdouble DOUBLE, ctimestamp1 TIMESTAMP) PARTITIONED BY (ctinyint tinyint) STORED AS ORC POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/vector_string_concat.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/vector_string_concat.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/vector_string_concat.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/vector_string_concat.q.out Fri Aug 22 21:36:47 2014 @@ -22,6 +22,7 @@ ROW FORMAT DELIMITED FIELDS TERMINATED B 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, @@ -61,6 +62,7 @@ PREHOOK: query: CREATE TABLE over1korc(t 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, Modified: hive/branches/cbo/ql/src/test/results/clientpositive/vectorization_part.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/vectorization_part.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/vectorization_part.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/vectorization_part.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE alltypesorc_part(ctinyint tinyint, csmallint smallint, cint int, cbigint bigint, cfloat float, cdouble double, cstring1 string, cstring2 string, ctimestamp1 timestamp, ctimestamp2 timestamp, cboolean1 boolean, cboolean2 boolean) partitioned by (ds string) STORED AS ORC PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@alltypesorc_part POSTHOOK: query: CREATE TABLE alltypesorc_part(ctinyint tinyint, csmallint smallint, cint int, cbigint bigint, cfloat float, cdouble double, cstring1 string, cstring2 string, ctimestamp1 timestamp, ctimestamp2 timestamp, cboolean1 boolean, cboolean2 boolean) partitioned by (ds string) STORED AS ORC POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/vectorization_part_project.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/vectorization_part_project.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/vectorization_part_project.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/vectorization_part_project.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE alltypesorc_part(ctinyint tinyint, csmallint smallint, cint int, cbigint bigint, cfloat float, cdouble double, cstring1 string, cstring2 string, ctimestamp1 timestamp, ctimestamp2 timestamp, cboolean1 boolean, cboolean2 boolean) partitioned by (ds string) STORED AS ORC PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@alltypesorc_part POSTHOOK: query: CREATE TABLE alltypesorc_part(ctinyint tinyint, csmallint smallint, cint int, cbigint bigint, cfloat float, cdouble double, cstring1 string, cstring2 string, ctimestamp1 timestamp, ctimestamp2 timestamp, cboolean1 boolean, cboolean2 boolean) partitioned by (ds string) STORED AS ORC POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/vectorized_bucketmapjoin1.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/vectorized_bucketmapjoin1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/vectorized_bucketmapjoin1.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/vectorized_bucketmapjoin1.q.out Fri Aug 22 21:36:47 2014 @@ -4,6 +4,7 @@ PREHOOK: query: create table vsmb_bucket STORED AS ORC PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@vsmb_bucket_1 POSTHOOK: query: create table vsmb_bucket_1(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS @@ -17,6 +18,7 @@ PREHOOK: query: create table vsmb_bucket STORED AS ORC PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@vsmb_bucket_2 POSTHOOK: query: create table vsmb_bucket_2(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS @@ -30,6 +32,7 @@ PREHOOK: query: create table vsmb_bucket STORED AS RCFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@vsmb_bucket_RC POSTHOOK: query: create table vsmb_bucket_RC(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS @@ -43,6 +46,7 @@ PREHOOK: query: create table vsmb_bucket STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@vsmb_bucket_TXT POSTHOOK: query: create table vsmb_bucket_TXT(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS @@ -119,9 +123,9 @@ STAGE PLANS: keys: 0 key (type: int) 1 key (type: int) - outputColumnNames: _col0, _col1, _col4, _col5 + outputColumnNames: _col0, _col1, _col5, _col6 Select Operator - expressions: _col0 (type: int), _col1 (type: string), _col4 (type: int), _col5 (type: string) + expressions: _col0 (type: int), _col1 (type: string), _col5 (type: int), _col6 (type: string) outputColumnNames: _col0, _col1, _col2, _col3 File Output Operator compressed: false @@ -180,9 +184,9 @@ STAGE PLANS: keys: 0 key (type: int) 1 key (type: int) - outputColumnNames: _col0, _col1, _col4, _col5 + outputColumnNames: _col0, _col1, _col5, _col6 Select Operator - expressions: _col0 (type: int), _col1 (type: string), _col4 (type: int), _col5 (type: string) + expressions: _col0 (type: int), _col1 (type: string), _col5 (type: int), _col6 (type: string) outputColumnNames: _col0, _col1, _col2, _col3 File Output Operator compressed: false @@ -251,9 +255,9 @@ STAGE PLANS: keys: 0 key (type: int) 1 key (type: int) - outputColumnNames: _col0, _col1, _col4, _col5 + outputColumnNames: _col0, _col1, _col5, _col6 Select Operator - expressions: _col0 (type: int), _col1 (type: string), _col4 (type: int), _col5 (type: string) + expressions: _col0 (type: int), _col1 (type: string), _col5 (type: int), _col6 (type: string) outputColumnNames: _col0, _col1, _col2, _col3 File Output Operator compressed: false Modified: hive/branches/cbo/ql/src/test/results/clientpositive/vectorized_context.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/vectorized_context.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/vectorized_context.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/vectorized_context.q.out Fri Aug 22 21:36:47 2014 @@ -2,6 +2,7 @@ PREHOOK: query: create table store(s_sto stored as orc PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@store POSTHOOK: query: create table store(s_store_sk int, s_city string) stored as orc POSTHOOK: type: CREATETABLE @@ -29,6 +30,7 @@ PREHOOK: query: create table store_sales stored as orc PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@store_sales POSTHOOK: query: create table store_sales(ss_store_sk int, ss_hdemo_sk int, ss_net_profit double) stored as orc POSTHOOK: type: CREATETABLE @@ -57,6 +59,7 @@ PREHOOK: query: create table household_d stored as orc PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@household_demographics POSTHOOK: query: create table household_demographics(hd_demo_sk int) stored as orc POSTHOOK: type: CREATETABLE @@ -118,7 +121,7 @@ STAGE PLANS: Statistics: Num rows: 3038 Data size: 12152 Basic stats: COMPLETE Column stats: NONE HashTable Sink Operator condition expressions: - 0 {_col2} {_col6} + 0 {_col2} {_col7} 1 keys: 0 _col1 (type: int) @@ -156,21 +159,21 @@ STAGE PLANS: keys: 0 ss_store_sk (type: int) 1 s_store_sk (type: int) - outputColumnNames: _col1, _col2, _col6 + outputColumnNames: _col1, _col2, _col7 Statistics: Num rows: 3341 Data size: 338652 Basic stats: COMPLETE Column stats: NONE Map Join Operator condition map: Inner Join 0 to 1 condition expressions: - 0 {_col2} {_col6} + 0 {_col2} {_col7} 1 keys: 0 _col1 (type: int) 1 hd_demo_sk (type: int) - outputColumnNames: _col2, _col6 + outputColumnNames: _col2, _col7 Statistics: Num rows: 3675 Data size: 372517 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col6 (type: string), _col2 (type: double) + expressions: _col7 (type: string), _col2 (type: double) outputColumnNames: _col0, _col1 Statistics: Num rows: 3675 Data size: 372517 Basic stats: COMPLETE Column stats: NONE Limit Modified: hive/branches/cbo/ql/src/test/results/clientpositive/vectorized_date_funcs.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/vectorized_date_funcs.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/vectorized_date_funcs.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/vectorized_date_funcs.q.out Fri Aug 22 21:36:47 2014 @@ -9,6 +9,7 @@ CREATE TABLE date_udf_flight ( ) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@date_udf_flight POSTHOOK: query: -- Test timestamp functions in vectorized mode to verify they run correctly end-to-end. CREATE TABLE date_udf_flight ( @@ -35,6 +36,7 @@ PREHOOK: query: CREATE TABLE date_udf_fl ) STORED AS ORC PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@date_udf_flight_orc POSTHOOK: query: CREATE TABLE date_udf_flight_orc ( fl_date DATE, fl_time TIMESTAMP Modified: hive/branches/cbo/ql/src/test/results/clientpositive/vectorized_distinct_gby.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/vectorized_distinct_gby.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/vectorized_distinct_gby.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/vectorized_distinct_gby.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: create table dtest(a int, b int) clustered by (a) sorted by (a) into 1 buckets stored as orc PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dtest POSTHOOK: query: create table dtest(a int, b int) clustered by (a) sorted by (a) into 1 buckets stored as orc POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/vectorized_mapjoin.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/vectorized_mapjoin.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/vectorized_mapjoin.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/vectorized_mapjoin.q.out Fri Aug 22 21:36:47 2014 @@ -52,14 +52,14 @@ STAGE PLANS: keys: 0 cint (type: int) 1 cint (type: int) - outputColumnNames: _col2, _col16 + outputColumnNames: _col2, _col17 Statistics: Num rows: 51870 Data size: 207482 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col2 (type: int), _col16 (type: int) - outputColumnNames: _col2, _col16 + expressions: _col2 (type: int), _col17 (type: int) + outputColumnNames: _col2, _col17 Statistics: Num rows: 51870 Data size: 207482 Basic stats: COMPLETE Column stats: NONE Group By Operator - aggregations: count(_col2), max(_col16), min(_col2), avg((_col2 + _col16)) + aggregations: count(_col2), max(_col17), min(_col2), avg((_col2 + _col17)) mode: hash outputColumnNames: _col0, _col1, _col2, _col3 Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE Modified: hive/branches/cbo/ql/src/test/results/clientpositive/vectorized_nested_mapjoin.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/vectorized_nested_mapjoin.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/vectorized_nested_mapjoin.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/vectorized_nested_mapjoin.q.out Fri Aug 22 21:36:47 2014 @@ -65,10 +65,10 @@ STAGE PLANS: keys: 0 ctinyint (type: tinyint) 1 ctinyint (type: tinyint) - outputColumnNames: _col0, _col1, _col5, _col14 + outputColumnNames: _col0, _col1, _col5, _col15 Statistics: Num rows: 51870 Data size: 207482 Basic stats: COMPLETE Column stats: NONE Filter Operator - predicate: (_col0 = _col14) (type: boolean) + predicate: (_col0 = _col15) (type: boolean) Statistics: Num rows: 25935 Data size: 103741 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col1 (type: smallint), _col5 (type: double) Modified: hive/branches/cbo/ql/src/test/results/clientpositive/vectorized_parquet.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/vectorized_parquet.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/vectorized_parquet.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/vectorized_parquet.q.out Fri Aug 22 21:36:47 2014 @@ -7,6 +7,7 @@ PREHOOK: query: create table if not exis cstring1 string) stored as parquet PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@alltypes_parquet POSTHOOK: query: create table if not exists alltypes_parquet ( cint int, ctinyint tinyint, Modified: hive/branches/cbo/ql/src/test/results/clientpositive/vectorized_ptf.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/vectorized_ptf.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== Files hive/branches/cbo/ql/src/test/results/clientpositive/vectorized_ptf.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/vectorized_ptf.q.out Fri Aug 22 21:36:47 2014 differ Modified: hive/branches/cbo/ql/src/test/results/clientpositive/vectorized_rcfile_columnar.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/vectorized_rcfile_columnar.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/vectorized_rcfile_columnar.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/vectorized_rcfile_columnar.q.out Fri Aug 22 21:36:47 2014 @@ -9,6 +9,7 @@ STORED AS OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.RCFileOutputFormat' PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@columnTable POSTHOOK: query: --This query must pass even when vectorized reader is not available for --RC files. The query must fall back to the non-vector mode and run successfully. Modified: hive/branches/cbo/ql/src/test/results/clientpositive/vectorized_shufflejoin.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/vectorized_shufflejoin.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/vectorized_shufflejoin.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/vectorized_shufflejoin.q.out Fri Aug 22 21:36:47 2014 @@ -45,14 +45,14 @@ STAGE PLANS: condition expressions: 0 {KEY.reducesinkkey0} 1 {KEY.reducesinkkey0} - outputColumnNames: _col2, _col16 + outputColumnNames: _col2, _col17 Statistics: Num rows: 51870 Data size: 207482 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col2 (type: int), _col16 (type: int) - outputColumnNames: _col2, _col16 + expressions: _col2 (type: int), _col17 (type: int) + outputColumnNames: _col2, _col17 Statistics: Num rows: 51870 Data size: 207482 Basic stats: COMPLETE Column stats: NONE Group By Operator - aggregations: count(_col2), max(_col16), min(_col2), avg((_col2 + _col16)) + aggregations: count(_col2), max(_col17), min(_col2), avg((_col2 + _col17)) mode: hash outputColumnNames: _col0, _col1, _col2, _col3 Statistics: Num rows: 1 Data size: 16 Basic stats: COMPLETE Column stats: NONE Modified: hive/branches/cbo/ql/src/test/results/clientpositive/vectorized_timestamp_funcs.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/vectorized_timestamp_funcs.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/vectorized_timestamp_funcs.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/vectorized_timestamp_funcs.q.out Fri Aug 22 21:36:47 2014 @@ -3,6 +3,7 @@ PREHOOK: query: -- Test timestamp functi CREATE TABLE alltypesorc_string(ctimestamp1 timestamp, stimestamp1 string) STORED AS ORC PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@alltypesorc_string POSTHOOK: query: -- Test timestamp functions in vectorized mode to verify they run correctly end-to-end. CREATE TABLE alltypesorc_string(ctimestamp1 timestamp, stimestamp1 string) STORED AS ORC @@ -32,6 +33,7 @@ POSTHOOK: Lineage: alltypesorc_string.st PREHOOK: query: CREATE TABLE alltypesorc_wrong(stimestamp1 string) STORED AS ORC PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@alltypesorc_wrong POSTHOOK: query: CREATE TABLE alltypesorc_wrong(stimestamp1 string) STORED AS ORC POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/view.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/view.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/view.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/view.q.out Fri Aug 22 21:36:47 2014 @@ -1,15 +1,20 @@ PREHOOK: query: CREATE DATABASE db1 PREHOOK: type: CREATEDATABASE +PREHOOK: Output: database:db1 POSTHOOK: query: CREATE DATABASE db1 POSTHOOK: type: CREATEDATABASE +POSTHOOK: Output: database:db1 PREHOOK: query: USE db1 PREHOOK: type: SWITCHDATABASE +PREHOOK: Input: database:db1 POSTHOOK: query: USE db1 POSTHOOK: type: SWITCHDATABASE +POSTHOOK: Input: database:db1 PREHOOK: query: CREATE TABLE table1 (key STRING, value STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:db1 +PREHOOK: Output: db1@table1 POSTHOOK: query: CREATE TABLE table1 (key STRING, value STRING) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE @@ -29,6 +34,7 @@ PREHOOK: query: CREATE TABLE table2 (key STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:db1 +PREHOOK: Output: db1@table2 POSTHOOK: query: CREATE TABLE table2 (key STRING, value STRING) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE @@ -122,12 +128,16 @@ POSTHOOK: Input: db1@table1 POSTHOOK: Output: db1@v8 PREHOOK: query: CREATE DATABASE db2 PREHOOK: type: CREATEDATABASE +PREHOOK: Output: database:db2 POSTHOOK: query: CREATE DATABASE db2 POSTHOOK: type: CREATEDATABASE +POSTHOOK: Output: database:db2 PREHOOK: query: USE db2 PREHOOK: type: SWITCHDATABASE +PREHOOK: Input: database:db2 POSTHOOK: query: USE db2 POSTHOOK: type: SWITCHDATABASE +POSTHOOK: Input: database:db2 PREHOOK: query: SELECT * FROM db1.v1 PREHOOK: type: QUERY PREHOOK: Input: db1@table1 Modified: hive/branches/cbo/ql/src/test/results/clientpositive/view_cast.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/view_cast.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/view_cast.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/view_cast.q.out Fri Aug 22 21:36:47 2014 @@ -5,6 +5,7 @@ POSTHOOK: type: DROPTABLE PREHOOK: query: CREATE TABLE IF NOT EXISTS atab (ks_uid BIGINT, sr_uid STRING, sr_id STRING, tstamp STRING, m_id STRING, act STRING, at_sr_uid STRING, tstamp_type STRING, original_m_id STRING, original_tstamp STRING, registered_flag TINYINT, at_ks_uid BIGINT) PARTITIONED BY (dt STRING,nt STRING) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@atab POSTHOOK: query: CREATE TABLE IF NOT EXISTS atab (ks_uid BIGINT, sr_uid STRING, sr_id STRING, tstamp STRING, m_id STRING, act STRING, at_sr_uid STRING, tstamp_type STRING, original_m_id STRING, original_tstamp STRING, registered_flag TINYINT, at_ks_uid BIGINT) PARTITIONED BY (dt STRING,nt STRING) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -34,6 +35,7 @@ POSTHOOK: type: DROPTABLE PREHOOK: query: CREATE TABLE mstab(ks_uid INT, csc INT) PARTITIONED BY (dt STRING) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@mstab POSTHOOK: query: CREATE TABLE mstab(ks_uid INT, csc INT) PARTITIONED BY (dt STRING) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/virtual_column.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/virtual_column.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/virtual_column.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/virtual_column.q.out Fri Aug 22 21:36:47 2014 @@ -351,6 +351,7 @@ POSTHOOK: Input: default@src PREHOOK: query: CREATE TABLE src_index_test_rc (key int, value string) STORED AS RCFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@src_index_test_rc POSTHOOK: query: CREATE TABLE src_index_test_rc (key int, value string) STORED AS RCFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -373,15 +374,3 @@ POSTHOOK: query: select INPUT__FILE__NAM POSTHOOK: type: QUERY POSTHOOK: Input: default@src_index_test_rc #### A masked pattern was here #### -PREHOOK: query: DROP TABLE src_index_test_rc -PREHOOK: type: DROPTABLE -PREHOOK: Input: default@src_index_test_rc -PREHOOK: Output: default@src_index_test_rc -POSTHOOK: query: DROP TABLE src_index_test_rc -POSTHOOK: type: DROPTABLE -POSTHOOK: Input: default@src_index_test_rc -POSTHOOK: Output: default@src_index_test_rc -PREHOOK: query: DROP INDEX src_index on src_index_test_rc -PREHOOK: type: DROPINDEX -POSTHOOK: query: DROP INDEX src_index on src_index_test_rc -POSTHOOK: type: DROPINDEX
