Modified: hive/branches/cbo/ql/src/test/results/clientpositive/auto_join21.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/auto_join21.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/auto_join21.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/auto_join21.q.out Fri Aug 22 21:36:47 2014 @@ -80,10 +80,10 @@ STAGE PLANS: 0 key (type: string) 1 key (type: string) 2 key (type: string) - outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 + outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11 Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator
Modified: hive/branches/cbo/ql/src/test/results/clientpositive/auto_join22.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/auto_join22.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/auto_join22.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/auto_join22.q.out Fri Aug 22 21:36:47 2014 @@ -82,10 +82,10 @@ STAGE PLANS: keys: 0 key (type: string) 1 _col2 (type: string) - outputColumnNames: _col7 + outputColumnNames: _col8 Statistics: Num rows: 34 Data size: 3515 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col7 (type: string) + expressions: _col8 (type: string) outputColumnNames: _col3 Statistics: Num rows: 34 Data size: 3515 Basic stats: COMPLETE Column stats: NONE Group By Operator Modified: hive/branches/cbo/ql/src/test/results/clientpositive/auto_join23.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/auto_join23.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/auto_join23.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/auto_join23.q.out Fri Aug 22 21:36:47 2014 @@ -51,10 +51,10 @@ STAGE PLANS: keys: 0 1 - outputColumnNames: _col0, _col1, _col4, _col5 + outputColumnNames: _col0, _col1, _col5, _col6 Statistics: Num rows: 9 Data size: 1983 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string) outputColumnNames: _col0, _col1, _col2, _col3 Statistics: Num rows: 9 Data size: 1983 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator Modified: hive/branches/cbo/ql/src/test/results/clientpositive/auto_join24.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/auto_join24.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/auto_join24.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/auto_join24.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: create table tst1(key STRING, cnt INT) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@tst1 POSTHOOK: query: create table tst1(key STRING, cnt INT) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/auto_join25.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/auto_join25.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/auto_join25.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/auto_join25.q.out Fri Aug 22 21:36:47 2014 @@ -2,6 +2,7 @@ PREHOOK: query: -- This test tests the s CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest1 POSTHOOK: query: -- This test tests the scenario when the mapper dies. So, create a conditional task for the mapjoin CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE @@ -52,6 +53,7 @@ RUN: Stage-1:MAPRED PREHOOK: query: CREATE TABLE dest_j2(key INT, value STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest_j2 POSTHOOK: query: CREATE TABLE dest_j2(key INT, value STRING) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -94,6 +96,7 @@ RUN: Stage-1:MAPRED PREHOOK: query: CREATE TABLE dest_j1(key INT, value STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest_j1 POSTHOOK: query: CREATE TABLE dest_j1(key INT, value STRING) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/auto_join26.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/auto_join26.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/auto_join26.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/auto_join26.q.out Fri Aug 22 21:36:47 2014 @@ -3,6 +3,7 @@ PREHOOK: query: --SORT_QUERY_RESULTS CREATE TABLE dest_j1(key INT, cnt INT) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest_j1 POSTHOOK: query: --SORT_QUERY_RESULTS CREATE TABLE dest_j1(key INT, cnt INT) Modified: hive/branches/cbo/ql/src/test/results/clientpositive/auto_join28.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/auto_join28.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/auto_join28.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/auto_join28.q.out Fri Aug 22 21:36:47 2014 @@ -80,10 +80,10 @@ STAGE PLANS: 0 key (type: string) 1 key (type: string) 2 key (type: string) - outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 + outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11 Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator @@ -196,10 +196,10 @@ STAGE PLANS: 0 key (type: string) 1 key (type: string) 2 key (type: string) - outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 + outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11 Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator @@ -312,10 +312,10 @@ STAGE PLANS: 0 key (type: string) 1 key (type: string) 2 key (type: string) - outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 + outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11 Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator @@ -425,10 +425,10 @@ STAGE PLANS: 0 key (type: string) 1 key (type: string) 2 key (type: string) - outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 + outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11 Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator Modified: hive/branches/cbo/ql/src/test/results/clientpositive/auto_join29.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/auto_join29.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/auto_join29.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/auto_join29.q.out Fri Aug 22 21:36:47 2014 @@ -80,10 +80,10 @@ STAGE PLANS: 0 key (type: string) 1 key (type: string) 2 key (type: string) - outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 + outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11 Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator @@ -704,10 +704,10 @@ STAGE PLANS: 0 key (type: string) 1 key (type: string) 2 key (type: string) - outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 + outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11 Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator @@ -1328,10 +1328,10 @@ STAGE PLANS: 0 key (type: string) 1 key (type: string) 2 key (type: string) - outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 + outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11 Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator @@ -1961,10 +1961,10 @@ STAGE PLANS: 0 key (type: string) 1 key (type: string) 2 key (type: string) - outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 + outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11 Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator @@ -2588,10 +2588,10 @@ STAGE PLANS: 0 key (type: string) 1 key (type: string) 2 key (type: string) - outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 + outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11 Statistics: Num rows: 6 Data size: 1322 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 Statistics: Num rows: 6 Data size: 1322 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator @@ -2712,10 +2712,10 @@ STAGE PLANS: 0 key (type: string) 1 key (type: string) 2 key (type: string) - outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 + outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11 Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator @@ -3336,10 +3336,10 @@ STAGE PLANS: 0 key (type: string) 1 key (type: string) 2 key (type: string) - outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 + outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11 Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 Statistics: Num rows: 63 Data size: 12786 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator @@ -3463,10 +3463,10 @@ STAGE PLANS: 0 key (type: string) 1 key (type: string) 2 key (type: string) - outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 + outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11 Statistics: Num rows: 19 Data size: 3966 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 Statistics: Num rows: 19 Data size: 3966 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator @@ -3600,10 +3600,10 @@ STAGE PLANS: 0 key (type: string) 1 key (type: string) 2 key (type: string) - outputColumnNames: _col0, _col1, _col4, _col5, _col8, _col9 + outputColumnNames: _col0, _col1, _col5, _col6, _col10, _col11 Statistics: Num rows: 2 Data size: 440 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col4 (type: string), _col5 (type: string), _col8 (type: string), _col9 (type: string) + expressions: _col0 (type: string), _col1 (type: string), _col5 (type: string), _col6 (type: string), _col10 (type: string), _col11 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5 Statistics: Num rows: 2 Data size: 440 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator Modified: hive/branches/cbo/ql/src/test/results/clientpositive/auto_join3.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/auto_join3.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/auto_join3.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/auto_join3.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest1 POSTHOOK: query: CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -84,10 +85,10 @@ STAGE PLANS: 0 key (type: string) 1 key (type: string) 2 key (type: string) - outputColumnNames: _col0, _col9 + outputColumnNames: _col0, _col11 Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: UDFToInteger(_col0) (type: int), _col9 (type: string) + expressions: UDFToInteger(_col0) (type: int), _col11 (type: string) outputColumnNames: _col0, _col1 Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE File Output Operator Modified: hive/branches/cbo/ql/src/test/results/clientpositive/auto_join32.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/auto_join32.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/auto_join32.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/auto_join32.q.out Fri Aug 22 21:36:47 2014 @@ -2,6 +2,7 @@ PREHOOK: query: -- empty tables create table studenttab10k (name string, age int, gpa double) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@studenttab10k POSTHOOK: query: -- empty tables create table studenttab10k (name string, age int, gpa double) POSTHOOK: type: CREATETABLE @@ -10,6 +11,7 @@ POSTHOOK: Output: default@studenttab10k PREHOOK: query: create table votertab10k (name string, age int, registration string, contributions float) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@votertab10k POSTHOOK: query: create table votertab10k (name string, age int, registration string, contributions float) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -70,15 +72,15 @@ STAGE PLANS: keys: 0 name (type: string) 1 name (type: string) - outputColumnNames: _col0, _col7 + outputColumnNames: _col0, _col8 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col7 (type: string) - outputColumnNames: _col0, _col7 + expressions: _col0 (type: string), _col8 (type: string) + outputColumnNames: _col0, _col8 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Group By Operator - aggregations: count(DISTINCT _col7) - keys: _col0 (type: string), _col7 (type: string) + aggregations: count(DISTINCT _col8) + keys: _col0 (type: string), _col8 (type: string) mode: hash outputColumnNames: _col0, _col1, _col2 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE @@ -134,6 +136,7 @@ PREHOOK: query: -- smb create table studenttab10k_smb (name string, age int, gpa double) clustered by (name) sorted by (name) into 2 buckets PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@studenttab10k_smb POSTHOOK: query: -- smb create table studenttab10k_smb (name string, age int, gpa double) clustered by (name) sorted by (name) into 2 buckets POSTHOOK: type: CREATETABLE @@ -142,6 +145,7 @@ POSTHOOK: Output: default@studenttab10k_ PREHOOK: query: create table votertab10k_smb (name string, age int, registration string, contributions float) clustered by (name) sorted by (name) into 2 buckets PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@votertab10k_smb POSTHOOK: query: create table votertab10k_smb (name string, age int, registration string, contributions float) clustered by (name) sorted by (name) into 2 buckets POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -179,13 +183,13 @@ STAGE PLANS: keys: 0 name (type: string) 1 name (type: string) - outputColumnNames: _col0, _col7 + outputColumnNames: _col0, _col8 Select Operator - expressions: _col0 (type: string), _col7 (type: string) - outputColumnNames: _col0, _col7 + expressions: _col0 (type: string), _col8 (type: string) + outputColumnNames: _col0, _col8 Group By Operator - aggregations: count(DISTINCT _col7) - keys: _col0 (type: string), _col7 (type: string) + aggregations: count(DISTINCT _col8) + keys: _col0 (type: string), _col8 (type: string) mode: hash outputColumnNames: _col0, _col1, _col2 Reduce Output Operator @@ -295,13 +299,13 @@ STAGE PLANS: keys: 0 name (type: string) 1 name (type: string) - outputColumnNames: _col0, _col7 + outputColumnNames: _col0, _col8 Select Operator - expressions: _col0 (type: string), _col7 (type: string) - outputColumnNames: _col0, _col7 + expressions: _col0 (type: string), _col8 (type: string) + outputColumnNames: _col0, _col8 Group By Operator - aggregations: count(DISTINCT _col7) - keys: _col0 (type: string), _col7 (type: string) + aggregations: count(DISTINCT _col8) + keys: _col0 (type: string), _col8 (type: string) mode: hash outputColumnNames: _col0, _col1, _col2 Reduce Output Operator @@ -350,6 +354,7 @@ PREHOOK: query: -- smb + partitions create table studenttab10k_part (name string, age int, gpa double) partitioned by (p string) clustered by (name) sorted by (name) into 2 buckets PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@studenttab10k_part POSTHOOK: query: -- smb + partitions create table studenttab10k_part (name string, age int, gpa double) partitioned by (p string) clustered by (name) sorted by (name) into 2 buckets POSTHOOK: type: CREATETABLE @@ -358,6 +363,7 @@ POSTHOOK: Output: default@studenttab10k_ PREHOOK: query: create table votertab10k_part (name string, age int, registration string, contributions float) partitioned by (p string) clustered by (name) sorted by (name) into 2 buckets PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@votertab10k_part POSTHOOK: query: create table votertab10k_part (name string, age int, registration string, contributions float) partitioned by (p string) clustered by (name) sorted by (name) into 2 buckets POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/auto_join4.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/auto_join4.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/auto_join4.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/auto_join4.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE dest1(c1 INT, c2 STRING, c3 INT, c4 STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest1 POSTHOOK: query: CREATE TABLE dest1(c1 INT, c2 STRING, c3 INT, c4 STRING) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/auto_join5.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/auto_join5.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/auto_join5.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/auto_join5.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE dest1(c1 INT, c2 STRING, c3 INT, c4 STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest1 POSTHOOK: query: CREATE TABLE dest1(c1 INT, c2 STRING, c3 INT, c4 STRING) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/auto_join6.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/auto_join6.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/auto_join6.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/auto_join6.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE dest1(c1 INT, c2 STRING, c3 INT, c4 STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest1 POSTHOOK: query: CREATE TABLE dest1(c1 INT, c2 STRING, c3 INT, c4 STRING) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/auto_join7.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/auto_join7.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/auto_join7.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/auto_join7.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE dest1(c1 INT, c2 STRING, c3 INT, c4 STRING, c5 INT, c6 STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest1 POSTHOOK: query: CREATE TABLE dest1(c1 INT, c2 STRING, c3 INT, c4 STRING, c5 INT, c6 STRING) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/auto_join8.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/auto_join8.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/auto_join8.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/auto_join8.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE dest1(c1 INT, c2 STRING, c3 INT, c4 STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest1 POSTHOOK: query: CREATE TABLE dest1(c1 INT, c2 STRING, c3 INT, c4 STRING) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/auto_join9.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/auto_join9.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/auto_join9.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/auto_join9.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest1 POSTHOOK: query: CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -60,10 +61,10 @@ STAGE PLANS: keys: 0 key (type: string) 1 key (type: string) - outputColumnNames: _col0, _col7 + outputColumnNames: _col0, _col8 Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: UDFToInteger(_col0) (type: int), _col7 (type: string) + expressions: UDFToInteger(_col0) (type: int), _col8 (type: string) outputColumnNames: _col0, _col1 Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE File Output Operator Modified: hive/branches/cbo/ql/src/test/results/clientpositive/auto_join_filters.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/auto_join_filters.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/auto_join_filters.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/auto_join_filters.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE myinput1(key int, value int) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@myinput1 POSTHOOK: query: CREATE TABLE myinput1(key int, value int) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -254,6 +255,7 @@ POSTHOOK: Input: default@myinput1 PREHOOK: query: CREATE TABLE smb_input1(key int, value int) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@smb_input1 POSTHOOK: query: CREATE TABLE smb_input1(key int, value int) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -261,6 +263,7 @@ POSTHOOK: Output: default@smb_input1 PREHOOK: query: CREATE TABLE smb_input2(key int, value int) CLUSTERED BY (value) SORTED BY (value) INTO 2 BUCKETS PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@smb_input2 POSTHOOK: query: CREATE TABLE smb_input2(key int, value int) CLUSTERED BY (value) SORTED BY (value) INTO 2 BUCKETS POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/auto_join_nulls.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/auto_join_nulls.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/auto_join_nulls.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/auto_join_nulls.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE myinput1(key int, value int) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@myinput1 POSTHOOK: query: CREATE TABLE myinput1(key int, value int) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/auto_join_reordering_values.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/auto_join_reordering_values.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== Files hive/branches/cbo/ql/src/test/results/clientpositive/auto_join_reordering_values.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/auto_join_reordering_values.q.out Fri Aug 22 21:36:47 2014 differ Modified: hive/branches/cbo/ql/src/test/results/clientpositive/auto_smb_mapjoin_14.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/auto_smb_mapjoin_14.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/auto_smb_mapjoin_14.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/auto_smb_mapjoin_14.q.out Fri Aug 22 21:36:47 2014 @@ -3,6 +3,7 @@ PREHOOK: query: -- SORT_QUERY_RESULTS CREATE TABLE tbl1(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@tbl1 POSTHOOK: query: -- SORT_QUERY_RESULTS CREATE TABLE tbl1(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS @@ -12,6 +13,7 @@ POSTHOOK: Output: default@tbl1 PREHOOK: query: CREATE TABLE tbl2(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@tbl2 POSTHOOK: query: CREATE TABLE tbl2(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -1357,6 +1359,7 @@ POSTHOOK: Input: default@tbl2 PREHOOK: query: CREATE TABLE dest1(key int, value string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest1 POSTHOOK: query: CREATE TABLE dest1(key int, value string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -1364,6 +1367,7 @@ POSTHOOK: Output: default@dest1 PREHOOK: query: CREATE TABLE dest2(key int, val1 string, val2 string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest2 POSTHOOK: query: CREATE TABLE dest2(key int, val1 string, val2 string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -1422,9 +1426,9 @@ STAGE PLANS: keys: 0 key (type: int) 1 key (type: int) - outputColumnNames: _col0, _col1, _col5 + outputColumnNames: _col0, _col1, _col6 Select Operator - expressions: _col0 (type: int), _col1 (type: string), _col5 (type: string) + expressions: _col0 (type: int), _col1 (type: string), _col6 (type: string) outputColumnNames: _col0, _col1, _col2 Select Operator expressions: _col0 (type: int), _col1 (type: string) @@ -1647,6 +1651,7 @@ POSTHOOK: Output: default@dest2 PREHOOK: query: CREATE TABLE dest2(key int, cnt int) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest2 POSTHOOK: query: CREATE TABLE dest2(key int, cnt int) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_1.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== Files hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_1.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_1.q.out Fri Aug 22 21:36:47 2014 differ Modified: hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_10.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_10.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_10.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_10.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE tbl1(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@tbl1 POSTHOOK: query: CREATE TABLE tbl1(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -8,6 +9,7 @@ POSTHOOK: Output: default@tbl1 PREHOOK: query: CREATE TABLE tbl2(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@tbl2 POSTHOOK: query: CREATE TABLE tbl2(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_11.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_11.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== Files hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_11.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_11.q.out Fri Aug 22 21:36:47 2014 differ Modified: hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_12.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_12.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== Files hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_12.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_12.q.out Fri Aug 22 21:36:47 2014 differ Modified: hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_13.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_13.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_13.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_13.q.out Fri Aug 22 21:36:47 2014 @@ -3,6 +3,7 @@ PREHOOK: query: -- SORT_QUERY_RESULTS CREATE TABLE tbl1(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@tbl1 POSTHOOK: query: -- SORT_QUERY_RESULTS CREATE TABLE tbl1(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS @@ -12,6 +13,7 @@ POSTHOOK: Output: default@tbl1 PREHOOK: query: CREATE TABLE tbl2(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@tbl2 POSTHOOK: query: CREATE TABLE tbl2(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -39,6 +41,7 @@ POSTHOOK: Lineage: tbl2.value SIMPLE [(s PREHOOK: query: CREATE TABLE dest1(k1 int, k2 int) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest1 POSTHOOK: query: CREATE TABLE dest1(k1 int, k2 int) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -46,6 +49,7 @@ POSTHOOK: Output: default@dest1 PREHOOK: query: CREATE TABLE dest2(k1 string, k2 string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest2 POSTHOOK: query: CREATE TABLE dest2(k1 string, k2 string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -94,9 +98,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 Select Operator expressions: _col0 (type: int), _col2 (type: int) @@ -275,9 +279,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 Select Operator expressions: _col0 (type: int), _col2 (type: int) @@ -456,9 +460,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 Select Operator expressions: _col0 (type: int), _col2 (type: int) Modified: hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_14.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_14.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_14.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_14.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE tbl1(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@tbl1 POSTHOOK: query: CREATE TABLE tbl1(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -8,6 +9,7 @@ POSTHOOK: Output: default@tbl1 PREHOOK: query: CREATE TABLE tbl2(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@tbl2 POSTHOOK: query: CREATE TABLE tbl2(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_15.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_15.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_15.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_15.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE tbl1(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@tbl1 POSTHOOK: query: CREATE TABLE tbl1(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -8,6 +9,7 @@ POSTHOOK: Output: default@tbl1 PREHOOK: query: CREATE TABLE tbl2(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@tbl2 POSTHOOK: query: CREATE TABLE tbl2(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_16.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_16.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_16.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_16.q.out Fri Aug 22 21:36:47 2014 @@ -6,6 +6,7 @@ value STRING PARTITIONED BY (file_tag STRING) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@stage_bucket_big POSTHOOK: query: CREATE TABLE stage_bucket_big ( key BIGINT, @@ -25,6 +26,7 @@ clustered by (key) sorted by (key) into stored as RCFile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@bucket_big POSTHOOK: query: CREATE TABLE bucket_big ( key BIGINT, @@ -44,6 +46,7 @@ value string PARTITIONED BY (file_tag STRING) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@stage_bucket_small POSTHOOK: query: CREATE TABLE stage_bucket_small ( key BIGINT, @@ -63,6 +66,7 @@ clustered by (key) sorted by (key) into stored as RCFile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@bucket_small POSTHOOK: query: CREATE TABLE bucket_small ( key BIGINT, Modified: hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_2.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_2.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== Files hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_2.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_2.q.out Fri Aug 22 21:36:47 2014 differ Modified: hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_3.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_3.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== Files hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_3.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_3.q.out Fri Aug 22 21:36:47 2014 differ Modified: hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_4.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_4.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== Files hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_4.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_4.q.out Fri Aug 22 21:36:47 2014 differ Modified: hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_5.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_5.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== Files hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_5.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_5.q.out Fri Aug 22 21:36:47 2014 differ Modified: hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_6.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_6.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_6.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_6.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE tbl1(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@tbl1 POSTHOOK: query: CREATE TABLE tbl1(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -8,6 +9,7 @@ POSTHOOK: Output: default@tbl1 PREHOOK: query: CREATE TABLE tbl2(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@tbl2 POSTHOOK: query: CREATE TABLE tbl2(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -15,6 +17,7 @@ POSTHOOK: Output: default@tbl2 PREHOOK: query: CREATE TABLE tbl3(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@tbl3 POSTHOOK: query: CREATE TABLE tbl3(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -22,6 +25,7 @@ POSTHOOK: Output: default@tbl3 PREHOOK: query: CREATE TABLE tbl4(key int, value string) CLUSTERED BY (value) SORTED BY (value) INTO 2 BUCKETS PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@tbl4 POSTHOOK: query: CREATE TABLE tbl4(key int, value string) CLUSTERED BY (value) SORTED BY (value) INTO 2 BUCKETS POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_7.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_7.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== Files hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_7.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_7.q.out Fri Aug 22 21:36:47 2014 differ Modified: hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_8.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_8.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== Files hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_8.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_8.q.out Fri Aug 22 21:36:47 2014 differ Modified: hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_9.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_9.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_9.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/auto_sortmerge_join_9.q.out Fri Aug 22 21:36:47 2014 @@ -3,6 +3,7 @@ PREHOOK: query: -- SORT_QUERY_RESULTS CREATE TABLE tbl1(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@tbl1 POSTHOOK: query: -- SORT_QUERY_RESULTS CREATE TABLE tbl1(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS @@ -12,6 +13,7 @@ POSTHOOK: Output: default@tbl1 PREHOOK: query: CREATE TABLE tbl2(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@tbl2 POSTHOOK: query: CREATE TABLE tbl2(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/avro_change_schema.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/avro_change_schema.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/avro_change_schema.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/avro_change_schema.q.out Fri Aug 22 21:36:47 2014 @@ -14,6 +14,7 @@ TBLPROPERTIES ('avro.schema.literal'='{ ] }') PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@avro2 POSTHOOK: query: -- verify that we can update the table properties CREATE TABLE avro2 ROW FORMAT Modified: hive/branches/cbo/ql/src/test/results/clientpositive/avro_compression_enabled.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/avro_compression_enabled.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/avro_compression_enabled.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/avro_compression_enabled.q.out Fri Aug 22 21:36:47 2014 @@ -36,6 +36,7 @@ TBLPROPERTIES ('avro.schema.literal'='{ }') PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@doctors4 POSTHOOK: query: -- verify that new joins bring in correct schemas (including evolved schemas) CREATE TABLE doctors4 Modified: hive/branches/cbo/ql/src/test/results/clientpositive/avro_compression_enabled_native.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/avro_compression_enabled_native.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/avro_compression_enabled_native.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/avro_compression_enabled_native.q.out Fri Aug 22 21:36:47 2014 @@ -8,6 +8,7 @@ CREATE TABLE doctors4 ( STORED AS AVRO PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@doctors4 POSTHOOK: query: -- verify that new joins bring in correct schemas (including evolved schemas) CREATE TABLE doctors4 ( Modified: hive/branches/cbo/ql/src/test/results/clientpositive/avro_decimal.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/avro_decimal.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/avro_decimal.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/avro_decimal.q.out Fri Aug 22 21:36:47 2014 @@ -5,6 +5,7 @@ POSTHOOK: type: DROPTABLE PREHOOK: query: CREATE TABLE dec(name string, value decimal(8,4)) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dec POSTHOOK: query: CREATE TABLE dec(name string, value decimal(8,4)) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -54,6 +55,7 @@ TBLPROPERTIES ( ) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@avro_dec POSTHOOK: query: CREATE TABLE `avro_dec`( `name` string COMMENT 'from deserializer', `value` decimal(5,2) COMMENT 'from deserializer') @@ -104,9 +106,9 @@ Mary 4.33 Cluck 5.96 Tom -12.25 Mary 33.33 -Tom 19 -Beck 0 -Beck 79.9 +Tom 19.00 +Beck 0.00 +Beck 79.90 PREHOOK: query: DROP TABLE IF EXISTS avro_dec1 PREHOOK: type: DROPTABLE POSTHOOK: query: DROP TABLE IF EXISTS avro_dec1 @@ -127,6 +129,7 @@ TBLPROPERTIES ( ) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@avro_dec1 POSTHOOK: query: CREATE TABLE `avro_dec1`( `name` string COMMENT 'from deserializer', `value` decimal(4,1) COMMENT 'from deserializer') @@ -172,10 +175,10 @@ POSTHOOK: Input: default@avro_dec1 77.3 55.7 4.3 -6 +6.0 12.3 33.3 -19 +19.0 3.2 79.9 PREHOOK: query: DROP TABLE dec Modified: hive/branches/cbo/ql/src/test/results/clientpositive/avro_decimal_native.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/avro_decimal_native.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/avro_decimal_native.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/avro_decimal_native.q.out Fri Aug 22 21:36:47 2014 @@ -7,6 +7,7 @@ PREHOOK: query: CREATE TABLE dec ( value decimal(8,4)) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dec POSTHOOK: query: CREATE TABLE dec ( name string, value decimal(8,4)) @@ -49,6 +50,7 @@ COMMENT 'just drop the schema right into STORED AS AVRO PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@avro_dec POSTHOOK: query: CREATE TABLE avro_dec( name string, value decimal(5,2)) @@ -90,9 +92,9 @@ Mary 4.33 Cluck 5.96 Tom -12.25 Mary 33.33 -Tom 19 -Beck 0 -Beck 79.9 +Tom 19.00 +Beck 0.00 +Beck 79.90 PREHOOK: query: DROP TABLE IF EXISTS avro_dec1 PREHOOK: type: DROPTABLE POSTHOOK: query: DROP TABLE IF EXISTS avro_dec1 @@ -104,6 +106,7 @@ COMMENT 'just drop the schema right into STORED AS AVRO PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@avro_dec1 POSTHOOK: query: CREATE TABLE avro_dec1( name string, value decimal(4,1)) @@ -140,10 +143,10 @@ POSTHOOK: Input: default@avro_dec1 77.3 55.7 4.3 -6 +6.0 12.3 33.3 -19 +19.0 3.2 79.9 PREHOOK: query: DROP TABLE dec Modified: hive/branches/cbo/ql/src/test/results/clientpositive/avro_evolved_schemas.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/avro_evolved_schemas.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/avro_evolved_schemas.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/avro_evolved_schemas.q.out Fri Aug 22 21:36:47 2014 @@ -37,6 +37,7 @@ TBLPROPERTIES ('avro.schema.literal'='{ }') PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@doctors_with_new_field POSTHOOK: query: -- SORT_QUERY_RESULTS -- verify that new fields in schema get propagated to table scans Modified: hive/branches/cbo/ql/src/test/results/clientpositive/avro_joins.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/avro_joins.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/avro_joins.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/avro_joins.q.out Fri Aug 22 21:36:47 2014 @@ -38,6 +38,7 @@ TBLPROPERTIES ('avro.schema.literal'='{ }') PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@doctors4 POSTHOOK: query: -- SORT_QUERY_RESULTS -- verify that new joins bring in correct schemas (including evolved schemas) @@ -127,6 +128,7 @@ TBLPROPERTIES ('avro.schema.literal'='{ }') PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@episodes POSTHOOK: query: CREATE TABLE episodes ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe' Modified: hive/branches/cbo/ql/src/test/results/clientpositive/avro_joins_native.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/avro_joins_native.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/avro_joins_native.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/avro_joins_native.q.out Fri Aug 22 21:36:47 2014 @@ -9,6 +9,7 @@ CREATE TABLE doctors4 ( STORED AS AVRO PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@doctors4 POSTHOOK: query: -- SORT_QUERY_RESULTS -- verify that new joins bring in correct schemas (including evolved schemas) @@ -45,6 +46,7 @@ PREHOOK: query: CREATE TABLE episodes ( STORED AS AVRO PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@episodes POSTHOOK: query: CREATE TABLE episodes ( title string COMMENT "episode title", air_date string COMMENT "initial date", Modified: hive/branches/cbo/ql/src/test/results/clientpositive/avro_native.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/avro_native.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/avro_native.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/avro_native.q.out Fri Aug 22 21:36:47 2014 @@ -8,6 +8,7 @@ CREATE TABLE doctors ( STORED AS AVRO PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@doctors POSTHOOK: query: -- SORT_QUERY_RESULTS -- verify that we can actually read avro files Modified: hive/branches/cbo/ql/src/test/results/clientpositive/avro_nullable_fields.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/avro_nullable_fields.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/avro_nullable_fields.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/avro_nullable_fields.q.out Fri Aug 22 21:36:47 2014 @@ -18,6 +18,7 @@ CREATE TABLE test_serializer(string1 STR STORED AS TEXTFILE PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@test_serializer POSTHOOK: query: -- Verify that nullable fields properly work CREATE TABLE test_serializer(string1 STRING, int1 INT, @@ -83,6 +84,7 @@ PREHOOK: query: CREATE TABLE as_avro ) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@as_avro POSTHOOK: query: CREATE TABLE as_avro ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe' Modified: hive/branches/cbo/ql/src/test/results/clientpositive/avro_partitioned.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/avro_partitioned.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/avro_partitioned.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/avro_partitioned.q.out Fri Aug 22 21:36:47 2014 @@ -30,6 +30,7 @@ TBLPROPERTIES ('avro.schema.literal'='{ }') PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@episodes POSTHOOK: query: -- SORT_QUERY_RESULTS -- Verify that table scans work with partitioned Avro tables CREATE TABLE episodes @@ -102,6 +103,7 @@ TBLPROPERTIES ('avro.schema.literal'='{ }') PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@episodes_partitioned POSTHOOK: query: CREATE TABLE episodes_partitioned PARTITIONED BY (doctor_pt INT) ROW FORMAT @@ -305,6 +307,7 @@ INPUTFORMAT 'org.apache.hadoop.hive.ql.i OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat' PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@episodes_partitioned_serdeproperties POSTHOOK: query: -- Verify that reading from an Avro partition works -- even if it has an old schema relative to the current table level schema Modified: hive/branches/cbo/ql/src/test/results/clientpositive/avro_partitioned_native.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/avro_partitioned_native.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/avro_partitioned_native.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/avro_partitioned_native.q.out Fri Aug 22 21:36:47 2014 @@ -7,6 +7,7 @@ CREATE TABLE episodes ( STORED AS AVRO PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@episodes POSTHOOK: query: -- SORT_QUERY_RESULTS -- Verify that table scans work with partitioned Avro tables CREATE TABLE episodes ( @@ -33,6 +34,7 @@ PARTITIONED BY (doctor_pt INT) STORED AS AVRO PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@episodes_partitioned POSTHOOK: query: CREATE TABLE episodes_partitioned ( title string COMMENT "episode title", air_date string COMMENT "initial date", Modified: hive/branches/cbo/ql/src/test/results/clientpositive/avro_sanity_test.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/avro_sanity_test.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/avro_sanity_test.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/avro_sanity_test.q.out Fri Aug 22 21:36:47 2014 @@ -31,6 +31,7 @@ TBLPROPERTIES ('avro.schema.literal'='{ }') PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@doctors POSTHOOK: query: -- SORT_QUERY_RESULTS -- verify that we can actually read avro files Modified: hive/branches/cbo/ql/src/test/results/clientpositive/avro_schema_error_message.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/avro_schema_error_message.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/avro_schema_error_message.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/avro_schema_error_message.q.out Fri Aug 22 21:36:47 2014 @@ -8,6 +8,7 @@ INPUTFORMAT 'org.apache.hadoop.hive.ql.i OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat' PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@avro_with_no_schema POSTHOOK: query: -- verify we get the sentinel schema if we don't provide one CREATE TABLE avro_with_no_schema Modified: hive/branches/cbo/ql/src/test/results/clientpositive/avro_schema_evolution_native.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/avro_schema_evolution_native.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/avro_schema_evolution_native.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/avro_schema_evolution_native.q.out Fri Aug 22 21:36:47 2014 @@ -7,6 +7,7 @@ CREATE TABLE episodes ( STORED AS AVRO PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@episodes POSTHOOK: query: -- SORT_QUERY_RESULTS -- Verify that table scans work with partitioned Avro tables CREATE TABLE episodes ( @@ -33,6 +34,7 @@ PARTITIONED BY (doctor_pt INT) STORED AS AVRO PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@episodes_partitioned POSTHOOK: query: CREATE TABLE episodes_partitioned ( title string COMMENT "episode title", air_date string COMMENT "initial date", Modified: hive/branches/cbo/ql/src/test/results/clientpositive/avro_schema_literal.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/avro_schema_literal.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/avro_schema_literal.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/avro_schema_literal.q.out Fri Aug 22 21:36:47 2014 @@ -30,6 +30,7 @@ TBLPROPERTIES ('avro.schema.literal'='{ ] }') PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@avro1 POSTHOOK: query: CREATE TABLE avro1 ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe' Modified: hive/branches/cbo/ql/src/test/results/clientpositive/ba_table1.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/ba_table1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/ba_table1.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/ba_table1.q.out Fri Aug 22 21:36:47 2014 @@ -11,6 +11,7 @@ PREHOOK: query: -- This query tests a) b create table ba_test (ba_key binary, ba_val binary) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@ba_test POSTHOOK: query: -- This query tests a) binary type works correctly in grammar b) string can be cast into binary c) binary can be stored in a table d) binary data can be loaded back again and queried d) order-by on a binary key create table ba_test (ba_key binary, ba_val binary) Modified: hive/branches/cbo/ql/src/test/results/clientpositive/ba_table2.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/ba_table2.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/ba_table2.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/ba_table2.q.out Fri Aug 22 21:36:47 2014 @@ -11,6 +11,7 @@ PREHOOK: query: -- All the test in ba_te create table ba_test (ba_key binary, ba_val binary) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@ba_test POSTHOOK: query: -- All the test in ba_test1.q + using LazyBinarySerde instead of LazySimpleSerde create table ba_test (ba_key binary, ba_val binary) Modified: hive/branches/cbo/ql/src/test/results/clientpositive/ba_table3.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/ba_table3.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/ba_table3.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/ba_table3.q.out Fri Aug 22 21:36:47 2014 @@ -7,6 +7,7 @@ PREHOOK: query: -- All the tests of ba_t create table ba_test (ba_key binary, ba_val binary) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@ba_test POSTHOOK: query: -- All the tests of ba_table1.q + test for a group-by and aggregation on a binary key. create table ba_test (ba_key binary, ba_val binary) Modified: hive/branches/cbo/ql/src/test/results/clientpositive/ba_table_udfs.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/ba_table_udfs.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/ba_table_udfs.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/ba_table_udfs.q.out Fri Aug 22 21:36:47 2014 @@ -2,15 +2,18 @@ PREHOOK: query: -- SORT_QUERY_RESULTS USE default PREHOOK: type: SWITCHDATABASE +PREHOOK: Input: database:default POSTHOOK: query: -- SORT_QUERY_RESULTS USE default POSTHOOK: type: SWITCHDATABASE +POSTHOOK: Input: database:default PREHOOK: query: CREATE TABLE dest1(bytes1 BINARY, bytes2 BINARY, string STRING) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@dest1 POSTHOOK: query: CREATE TABLE dest1(bytes1 BINARY, bytes2 BINARY, string STRING) Modified: hive/branches/cbo/ql/src/test/results/clientpositive/ba_table_union.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/ba_table_union.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/ba_table_union.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/ba_table_union.q.out Fri Aug 22 21:36:47 2014 @@ -6,6 +6,7 @@ PREHOOK: query: -- this query tests ba_t create table ba_test (ba_key binary, ba_val binary) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@ba_test POSTHOOK: query: -- this query tests ba_table1.q + nested queries with multiple operations on binary data types + union on binary types create table ba_test (ba_key binary, ba_val binary) POSTHOOK: type: CREATETABLE Modified: hive/branches/cbo/ql/src/test/results/clientpositive/binary_output_format.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/binary_output_format.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== Files hive/branches/cbo/ql/src/test/results/clientpositive/binary_output_format.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/binary_output_format.q.out Fri Aug 22 21:36:47 2014 differ Modified: hive/branches/cbo/ql/src/test/results/clientpositive/binary_table_bincolserde.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/binary_table_bincolserde.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/binary_table_bincolserde.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/binary_table_bincolserde.q.out Fri Aug 22 21:36:47 2014 @@ -7,6 +7,7 @@ PREHOOK: query: -- Tests everything in b create table ba_test (ba_key binary, ba_val binary) stored as rcfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@ba_test POSTHOOK: query: -- Tests everything in binary_table_colserde.q + uses LazyBinaryColumnarSerde create table ba_test (ba_key binary, ba_val binary) stored as rcfile Modified: hive/branches/cbo/ql/src/test/results/clientpositive/binary_table_colserde.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/binary_table_colserde.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/binary_table_colserde.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/binary_table_colserde.q.out Fri Aug 22 21:36:47 2014 @@ -7,6 +7,7 @@ PREHOOK: query: -- Everything in ba_tabl create table ba_test (ba_key binary, ba_val binary) stored as rcfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@ba_test POSTHOOK: query: -- Everything in ba_table1.q + columnar serde in RCFILE. create table ba_test (ba_key binary, ba_val binary) stored as rcfile Modified: hive/branches/cbo/ql/src/test/results/clientpositive/binarysortable_1.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/binarysortable_1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== Files hive/branches/cbo/ql/src/test/results/clientpositive/binarysortable_1.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/binarysortable_1.q.out Fri Aug 22 21:36:47 2014 differ Modified: hive/branches/cbo/ql/src/test/results/clientpositive/bool_literal.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/bool_literal.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/bool_literal.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/bool_literal.q.out Fri Aug 22 21:36:47 2014 @@ -5,6 +5,7 @@ POSTHOOK: type: DROPTABLE PREHOOK: query: CREATE TABLE bool_literal(key int, value boolean) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@bool_literal POSTHOOK: query: CREATE TABLE bool_literal(key int, value boolean) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/bucket1.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/bucket1.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== Files hive/branches/cbo/ql/src/test/results/clientpositive/bucket1.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/bucket1.q.out Fri Aug 22 21:36:47 2014 differ Modified: hive/branches/cbo/ql/src/test/results/clientpositive/bucket2.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/bucket2.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== Files hive/branches/cbo/ql/src/test/results/clientpositive/bucket2.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/bucket2.q.out Fri Aug 22 21:36:47 2014 differ Modified: hive/branches/cbo/ql/src/test/results/clientpositive/bucket3.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/bucket3.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== Files hive/branches/cbo/ql/src/test/results/clientpositive/bucket3.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/bucket3.q.out Fri Aug 22 21:36:47 2014 differ Modified: hive/branches/cbo/ql/src/test/results/clientpositive/bucket4.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/bucket4.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== Files hive/branches/cbo/ql/src/test/results/clientpositive/bucket4.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/bucket4.q.out Fri Aug 22 21:36:47 2014 differ Modified: hive/branches/cbo/ql/src/test/results/clientpositive/bucket5.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/bucket5.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== Files hive/branches/cbo/ql/src/test/results/clientpositive/bucket5.q.out (original) and hive/branches/cbo/ql/src/test/results/clientpositive/bucket5.q.out Fri Aug 22 21:36:47 2014 differ Modified: hive/branches/cbo/ql/src/test/results/clientpositive/bucket6.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/bucket6.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/bucket6.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/bucket6.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: CREATE TABLE src_bucket(key STRING, value STRING) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@src_bucket POSTHOOK: query: CREATE TABLE src_bucket(key STRING, value STRING) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default Modified: hive/branches/cbo/ql/src/test/results/clientpositive/bucket_groupby.q.out URL: http://svn.apache.org/viewvc/hive/branches/cbo/ql/src/test/results/clientpositive/bucket_groupby.q.out?rev=1619936&r1=1619935&r2=1619936&view=diff ============================================================================== --- hive/branches/cbo/ql/src/test/results/clientpositive/bucket_groupby.q.out (original) +++ hive/branches/cbo/ql/src/test/results/clientpositive/bucket_groupby.q.out Fri Aug 22 21:36:47 2014 @@ -1,6 +1,7 @@ PREHOOK: query: create table clustergroupby(key string, value string) partitioned by(ds string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@clustergroupby POSTHOOK: query: create table clustergroupby(key string, value string) partitioned by(ds string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -995,6 +996,7 @@ POSTHOOK: Output: default@clustergroupby PREHOOK: query: create table clustergroupby(key string, value string) partitioned by(ds string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@clustergroupby POSTHOOK: query: create table clustergroupby(key string, value string) partitioned by(ds string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default @@ -1293,6 +1295,7 @@ POSTHOOK: Output: default@clustergroupby PREHOOK: query: create table clustergroupby(key string, value string) partitioned by(ds string) PREHOOK: type: CREATETABLE PREHOOK: Output: database:default +PREHOOK: Output: default@clustergroupby POSTHOOK: query: create table clustergroupby(key string, value string) partitioned by(ds string) POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default