Modified: hive/trunk/ql/src/test/results/clientpositive/ppd_join4.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_join4.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/ppd_join4.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/ppd_join4.q.out Sat Jul 26 15:39:55 2014 @@ -58,18 +58,13 @@ STAGE PLANS: predicate: ((id is not null and (name = 'c')) and (id = 'a')) (type: boolean) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator - expressions: id (type: string), name (type: string) - outputColumnNames: _col0, _col1 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Reduce Output Operator - key expressions: _col0 (type: string) + key expressions: 'a' (type: string) sort order: + Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE - value expressions: _col1 (type: string) Reduce Operator Tree: Select Operator - expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string) - outputColumnNames: _col0, _col1 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator compressed: false @@ -88,28 +83,24 @@ STAGE PLANS: predicate: (id is not null and (id = 'a')) (type: boolean) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Reduce Output Operator - key expressions: id (type: string) + key expressions: 'a' (type: string) sort order: + - Map-reduce partition columns: id (type: string) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE TableScan Reduce Output Operator - key expressions: _col0 (type: string) + key expressions: 'a' (type: string) sort order: + - Map-reduce partition columns: _col0 (type: string) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE - value expressions: _col1 (type: string) Reduce Operator Tree: Join Operator condition map: Inner Join 0 to 1 condition expressions: - 0 {KEY.reducesinkkey0} {VALUE._col0} + 0 1 - outputColumnNames: _col0, _col1 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string) + expressions: 'a' (type: string), 'c' (type: string) outputColumnNames: _col0, _col1 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator
Modified: hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join5.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join5.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join5.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/ppd_outer_join5.q.out Sat Jul 26 15:39:55 2014 @@ -45,9 +45,8 @@ STAGE PLANS: predicate: (id = 20) (type: boolean) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Reduce Output Operator - key expressions: id (type: int) + key expressions: 20 (type: int) sort order: + - Map-reduce partition columns: id (type: int) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE value expressions: key (type: string), value (type: string) TableScan @@ -82,11 +81,11 @@ STAGE PLANS: condition expressions: 0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col1} 1 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col1} - 2 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col1} - outputColumnNames: _col0, _col1, _col2, _col5, _col6, _col7, _col10, _col11, _col12 + 2 {VALUE._col0} {VALUE._col1} + outputColumnNames: _col0, _col1, _col2, _col5, _col6, _col7, _col11, _col12 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator - expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: string), _col10 (type: int), _col11 (type: string), _col12 (type: string) + expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: string), 20 (type: int), _col11 (type: string), _col12 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator @@ -134,9 +133,8 @@ STAGE PLANS: predicate: (id = 20) (type: boolean) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Reduce Output Operator - key expressions: id (type: int) + key expressions: 20 (type: int) sort order: + - Map-reduce partition columns: id (type: int) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE value expressions: key (type: string), value (type: string) TableScan @@ -146,9 +144,8 @@ STAGE PLANS: predicate: (id = 20) (type: boolean) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Reduce Output Operator - key expressions: id (type: int) + key expressions: 20 (type: int) sort order: + - Map-reduce partition columns: id (type: int) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE value expressions: key (type: string), value (type: string) Reduce Operator Tree: @@ -157,13 +154,13 @@ STAGE PLANS: Inner Join 0 to 1 Left Outer Join1 to 2 condition expressions: - 0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col1} - 1 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col1} + 0 {VALUE._col0} {VALUE._col1} + 1 {VALUE._col0} {VALUE._col1} 2 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col1} - outputColumnNames: _col0, _col1, _col2, _col5, _col6, _col7, _col10, _col11, _col12 + outputColumnNames: _col1, _col2, _col6, _col7, _col10, _col11, _col12 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator - expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: string), _col10 (type: int), _col11 (type: string), _col12 (type: string) + expressions: 20 (type: int), _col1 (type: string), _col2 (type: string), 20 (type: int), _col6 (type: string), _col7 (type: string), _col10 (type: int), _col11 (type: string), _col12 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator @@ -211,9 +208,8 @@ STAGE PLANS: predicate: (id = 20) (type: boolean) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Reduce Output Operator - key expressions: id (type: int) + key expressions: 20 (type: int) sort order: + - Map-reduce partition columns: id (type: int) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE value expressions: key (type: string), value (type: string) TableScan @@ -223,9 +219,8 @@ STAGE PLANS: predicate: (id = 20) (type: boolean) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Reduce Output Operator - key expressions: id (type: int) + key expressions: 20 (type: int) sort order: + - Map-reduce partition columns: id (type: int) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE value expressions: key (type: string), value (type: string) Reduce Operator Tree: @@ -234,13 +229,13 @@ STAGE PLANS: Inner Join 0 to 1 Left Outer Join0 to 2 condition expressions: - 0 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col1} - 1 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col1} + 0 {VALUE._col0} {VALUE._col1} + 1 {VALUE._col0} {VALUE._col1} 2 {KEY.reducesinkkey0} {VALUE._col0} {VALUE._col1} - outputColumnNames: _col0, _col1, _col2, _col5, _col6, _col7, _col10, _col11, _col12 + outputColumnNames: _col1, _col2, _col6, _col7, _col10, _col11, _col12 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator - expressions: _col0 (type: int), _col1 (type: string), _col2 (type: string), _col5 (type: int), _col6 (type: string), _col7 (type: string), _col10 (type: int), _col11 (type: string), _col12 (type: string) + expressions: 20 (type: int), _col1 (type: string), _col2 (type: string), 20 (type: int), _col6 (type: string), _col7 (type: string), _col10 (type: int), _col11 (type: string), _col12 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator Modified: hive/trunk/ql/src/test/results/clientpositive/ppd_repeated_alias.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_repeated_alias.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/ppd_repeated_alias.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/ppd_repeated_alias.q.out Sat Jul 26 15:39:55 2014 @@ -72,7 +72,7 @@ STAGE PLANS: predicate: (_col6 = 3) (type: boolean) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator - expressions: _col0 (type: int), _col5 (type: int), _col6 (type: int) + expressions: _col0 (type: int), _col5 (type: int), 3 (type: int) outputColumnNames: _col0, _col1, _col2 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator @@ -206,18 +206,17 @@ STAGE PLANS: sort order: + Map-reduce partition columns: foo (type: int) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE - value expressions: bar (type: int) Reduce Operator Tree: Join Operator condition map: Inner Join 0 to 1 condition expressions: - 0 {KEY.reducesinkkey0} {VALUE._col0} + 0 {KEY.reducesinkkey0} 1 {KEY.reducesinkkey0} - outputColumnNames: _col0, _col1, _col5 + outputColumnNames: _col0, _col5 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator - expressions: _col0 (type: int), _col5 (type: int), _col1 (type: int) + expressions: _col0 (type: int), _col5 (type: int), 3 (type: int) outputColumnNames: _col0, _col1, _col2 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator Modified: hive/trunk/ql/src/test/results/clientpositive/ppd_udf_case.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_udf_case.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/ppd_udf_case.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/ppd_udf_case.q.out Sat Jul 26 15:39:55 2014 @@ -70,8 +70,8 @@ STAGE PLANS: predicate: (((_col2 = '2008-04-08') and (_col8 = '2008-04-08')) and CASE (_col0) WHEN ('27') THEN (true) WHEN ('38') THEN (false) ELSE (null) END) (type: boolean) Statistics: Num rows: 1 Data size: 205 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col6 (type: string), _col7 (type: string), _col8 (type: string), _col9 (type: string) - outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7 + expressions: _col0 (type: string), _col1 (type: string), _col3 (type: string), _col6 (type: string), _col7 (type: string), _col9 (type: string) + outputColumnNames: _col0, _col1, _col3, _col4, _col5, _col7 Statistics: Num rows: 1 Data size: 205 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false @@ -85,12 +85,12 @@ STAGE PLANS: Map Operator Tree: TableScan Reduce Output Operator - key expressions: _col0 (type: string), _col1 (type: string), _col2 (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string), _col6 (type: string), _col7 (type: string) + key expressions: _col0 (type: string), _col1 (type: string), '2008-04-08' (type: string), _col3 (type: string), _col4 (type: string), _col5 (type: string), '2008-04-08' (type: string), _col7 (type: string) sort order: ++++++++ Statistics: Num rows: 1 Data size: 205 Basic stats: COMPLETE Column stats: NONE Reduce Operator Tree: Select Operator - expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: string), KEY.reducesinkkey2 (type: string), KEY.reducesinkkey3 (type: string), KEY.reducesinkkey4 (type: string), KEY.reducesinkkey5 (type: string), KEY.reducesinkkey6 (type: string), KEY.reducesinkkey7 (type: string) + expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: string), '2008-04-08' (type: string), KEY.reducesinkkey3 (type: string), KEY.reducesinkkey4 (type: string), KEY.reducesinkkey5 (type: string), '2008-04-08' (type: string), KEY.reducesinkkey7 (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7 Statistics: Num rows: 1 Data size: 205 Basic stats: COMPLETE Column stats: NONE File Output Operator Modified: hive/trunk/ql/src/test/results/clientpositive/ppd_udf_col.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_udf_col.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/ppd_udf_col.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/ppd_udf_col.q.out Sat Jul 26 15:39:55 2014 @@ -18,24 +18,24 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src - Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1937 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key = 100) (type: boolean) - Statistics: Num rows: 29 Data size: 2906 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 968 Data size: 2904 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: key (type: string), rand() (type: double) - outputColumnNames: _col0, _col2 - Statistics: Num rows: 29 Data size: 2906 Basic stats: COMPLETE Column stats: NONE + expressions: rand() (type: double) + outputColumnNames: _col2 + Statistics: Num rows: 968 Data size: 2904 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (_col2 <= 0.1) (type: boolean) - Statistics: Num rows: 9 Data size: 901 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 322 Data size: 966 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col2 (type: double) + expressions: '100' (type: string), _col2 (type: double) outputColumnNames: _col0, _col1 - Statistics: Num rows: 9 Data size: 901 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 322 Data size: 966 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 9 Data size: 901 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 322 Data size: 966 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -71,34 +71,34 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src - Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1937 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key = 100) (type: boolean) - Statistics: Num rows: 29 Data size: 2906 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 968 Data size: 2904 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: key (type: string), rand() (type: double) - outputColumnNames: _col0, _col2 - Statistics: Num rows: 29 Data size: 2906 Basic stats: COMPLETE Column stats: NONE + expressions: rand() (type: double) + outputColumnNames: _col2 + Statistics: Num rows: 968 Data size: 2904 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (_col2 <= 0.1) (type: boolean) - Statistics: Num rows: 9 Data size: 901 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 322 Data size: 966 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col2 (type: double) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 9 Data size: 901 Basic stats: COMPLETE Column stats: NONE + expressions: _col2 (type: double) + outputColumnNames: _col1 + Statistics: Num rows: 322 Data size: 966 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (_col1 > 0.1) (type: boolean) - Statistics: Num rows: 3 Data size: 300 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 107 Data size: 321 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col1 (type: double) + expressions: '100' (type: string), _col1 (type: double) outputColumnNames: _col0, _col1 - Statistics: Num rows: 3 Data size: 300 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 107 Data size: 321 Basic stats: COMPLETE Column stats: NONE Limit Number of rows: 20 - Statistics: Num rows: 3 Data size: 300 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 20 Data size: 60 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 3 Data size: 300 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 20 Data size: 60 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -130,24 +130,24 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src - Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1937 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key = 100) (type: boolean) - Statistics: Num rows: 29 Data size: 2906 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 968 Data size: 2904 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: key (type: string), rand() (type: double), hex(4) (type: string) - outputColumnNames: _col0, _col2, _col3 - Statistics: Num rows: 29 Data size: 2906 Basic stats: COMPLETE Column stats: NONE + expressions: rand() (type: double), '4' (type: string) + outputColumnNames: _col2, _col3 + Statistics: Num rows: 968 Data size: 2904 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (_col3 <= 3) (type: boolean) - Statistics: Num rows: 9 Data size: 901 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 322 Data size: 966 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col2 (type: double), _col3 (type: string) + expressions: '100' (type: string), _col2 (type: double), _col3 (type: string) outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 9 Data size: 901 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 322 Data size: 966 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 9 Data size: 901 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 322 Data size: 966 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -179,24 +179,24 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src - Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 56 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key = 100) (type: boolean) - Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 28 Data size: 2906 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: key (type: string), rand() (type: double), (value * 10) (type: double) - outputColumnNames: _col0, _col2, _col3 - Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE + expressions: rand() (type: double), (value * 10) (type: double) + outputColumnNames: _col2, _col3 + Statistics: Num rows: 28 Data size: 2906 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (_col3 <= 200.0) (type: boolean) - Statistics: Num rows: 4 Data size: 801 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 9 Data size: 934 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col2 (type: double), _col3 (type: double) + expressions: '100' (type: string), _col2 (type: double), _col3 (type: double) outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 4 Data size: 801 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 9 Data size: 934 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 4 Data size: 801 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 9 Data size: 934 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -228,24 +228,24 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src - Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1937 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key = 100) (type: boolean) - Statistics: Num rows: 29 Data size: 2906 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 968 Data size: 2904 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: key (type: string), rand() (type: double) - outputColumnNames: _col0, _col2 - Statistics: Num rows: 29 Data size: 2906 Basic stats: COMPLETE Column stats: NONE + expressions: rand() (type: double) + outputColumnNames: _col2 + Statistics: Num rows: 968 Data size: 2904 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (_col2 <= 0.1) (type: boolean) - Statistics: Num rows: 9 Data size: 901 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 322 Data size: 966 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col2 (type: double) + expressions: '100' (type: string), _col2 (type: double) outputColumnNames: _col0, _col1 - Statistics: Num rows: 9 Data size: 901 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 322 Data size: 966 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 9 Data size: 901 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 322 Data size: 966 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -281,27 +281,27 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src - Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1937 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key = 100) (type: boolean) - Statistics: Num rows: 29 Data size: 2906 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 968 Data size: 2904 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: key (type: string), rand() (type: double) - outputColumnNames: _col0, _col2 - Statistics: Num rows: 29 Data size: 2906 Basic stats: COMPLETE Column stats: NONE + expressions: rand() (type: double) + outputColumnNames: _col2 + Statistics: Num rows: 968 Data size: 2904 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((_col2 <= 0.1) and (_col2 > 0.1)) (type: boolean) - Statistics: Num rows: 3 Data size: 300 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 107 Data size: 321 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col2 (type: double) + expressions: '100' (type: string), _col2 (type: double) outputColumnNames: _col0, _col1 - Statistics: Num rows: 3 Data size: 300 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 107 Data size: 321 Basic stats: COMPLETE Column stats: NONE Limit Number of rows: 20 - Statistics: Num rows: 3 Data size: 300 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 20 Data size: 60 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 3 Data size: 300 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 20 Data size: 60 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -333,24 +333,24 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src - Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1937 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key = 100) (type: boolean) - Statistics: Num rows: 29 Data size: 2906 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 968 Data size: 2904 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: key (type: string), rand() (type: double), hex(4) (type: string) - outputColumnNames: _col0, _col2, _col3 - Statistics: Num rows: 29 Data size: 2906 Basic stats: COMPLETE Column stats: NONE + expressions: rand() (type: double), '4' (type: string) + outputColumnNames: _col2, _col3 + Statistics: Num rows: 968 Data size: 2904 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (_col3 <= 3) (type: boolean) - Statistics: Num rows: 9 Data size: 901 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 322 Data size: 966 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col2 (type: double), _col3 (type: string) + expressions: '100' (type: string), _col2 (type: double), _col3 (type: string) outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 9 Data size: 901 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 322 Data size: 966 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 9 Data size: 901 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 322 Data size: 966 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -382,24 +382,24 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src - Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 56 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key = 100) (type: boolean) - Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 28 Data size: 2906 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: key (type: string), rand() (type: double), (value * 10) (type: double) - outputColumnNames: _col0, _col2, _col3 - Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE + expressions: rand() (type: double), (value * 10) (type: double) + outputColumnNames: _col2, _col3 + Statistics: Num rows: 28 Data size: 2906 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (_col3 <= 200.0) (type: boolean) - Statistics: Num rows: 4 Data size: 801 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 9 Data size: 934 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: string), _col2 (type: double), _col3 (type: double) + expressions: '100' (type: string), _col2 (type: double), _col3 (type: double) outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 4 Data size: 801 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 9 Data size: 934 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 4 Data size: 801 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 9 Data size: 934 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Modified: hive/trunk/ql/src/test/results/clientpositive/ppd_union_view.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/ppd_union_view.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff ============================================================================== Files hive/trunk/ql/src/test/results/clientpositive/ppd_union_view.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/ppd_union_view.q.out Sat Jul 26 15:39:55 2014 differ Modified: hive/trunk/ql/src/test/results/clientpositive/query_result_fileformat.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/query_result_fileformat.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/query_result_fileformat.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/query_result_fileformat.q.out Sat Jul 26 15:39:55 2014 @@ -53,7 +53,7 @@ STAGE PLANS: predicate: (key = 'key1') (type: boolean) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator - expressions: key (type: string), value (type: string) + expressions: 'key1' (type: string), value (type: string) outputColumnNames: _col0, _col1 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator @@ -124,7 +124,7 @@ STAGE PLANS: predicate: (key = 'key1') (type: boolean) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator - expressions: key (type: string), value (type: string) + expressions: 'key1' (type: string), value (type: string) outputColumnNames: _col0, _col1 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator Modified: hive/trunk/ql/src/test/results/clientpositive/quotedid_basic.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/quotedid_basic.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/quotedid_basic.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/quotedid_basic.q.out Sat Jul 26 15:39:55 2014 @@ -76,7 +76,7 @@ STAGE PLANS: predicate: (!@#$%^&*()_q = '1') (type: boolean) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator - expressions: x+1 (type: string), y&y (type: string), !@#$%^&*()_q (type: string) + expressions: x+1 (type: string), y&y (type: string), '1' (type: string) outputColumnNames: _col0, _col1, _col2 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE File Output Operator @@ -112,7 +112,7 @@ STAGE PLANS: predicate: (!@#$%^&*()_q = '1') (type: boolean) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator - expressions: x+1 (type: string), y&y (type: string), !@#$%^&*()_q (type: string) + expressions: x+1 (type: string), y&y (type: string), '1' (type: string) outputColumnNames: x+1, y&y, !@#$%^&*()_q Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Group By Operator @@ -171,7 +171,7 @@ STAGE PLANS: predicate: (!@#$%^&*()_q = '1') (type: boolean) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator - expressions: x+1 (type: string), y&y (type: string), !@#$%^&*()_q (type: string) + expressions: x+1 (type: string), y&y (type: string), '1' (type: string) outputColumnNames: x+1, y&y, !@#$%^&*()_q Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Group By Operator @@ -254,7 +254,7 @@ STAGE PLANS: predicate: (!@#$%^&*()_q = '1') (type: boolean) Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Select Operator - expressions: x+1 (type: string), y&y (type: string), !@#$%^&*()_q (type: string) + expressions: x+1 (type: string), y&y (type: string), '1' (type: string) outputColumnNames: x+1, y&y, !@#$%^&*()_q Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE Group By Operator Modified: hive/trunk/ql/src/test/results/clientpositive/quotedid_partition.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/quotedid_partition.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/quotedid_partition.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/quotedid_partition.q.out Sat Jul 26 15:39:55 2014 @@ -45,7 +45,7 @@ STAGE PLANS: predicate: (x+1 = '10') (type: boolean) Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: x+1 (type: string), y&y (type: string), !@#$%^&*()_q (type: string) + expressions: '10' (type: string), y&y (type: string), !@#$%^&*()_q (type: string) outputColumnNames: x+1, y&y, !@#$%^&*()_q Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE Group By Operator Modified: hive/trunk/ql/src/test/results/clientpositive/regex_col.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/regex_col.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/regex_col.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/regex_col.q.out Sat Jul 26 15:39:55 2014 @@ -179,26 +179,26 @@ STAGE PLANS: Map Operator Tree: TableScan alias: b - Statistics: Num rows: 232 Data size: 23248 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 7748 Data size: 23248 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((key = 103) and key is not null) (type: boolean) - Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1937 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator - key expressions: key (type: string), hr (type: string), ds (type: string) + key expressions: '103' (type: string), hr (type: string), ds (type: string) sort order: +++ - Map-reduce partition columns: key (type: string), hr (type: string), ds (type: string) - Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Map-reduce partition columns: hr (type: string), ds (type: string) + Statistics: Num rows: 1937 Data size: 5812 Basic stats: COMPLETE Column stats: NONE TableScan alias: a - Statistics: Num rows: 232 Data size: 23248 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 7748 Data size: 23248 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((key = 103) and key is not null) (type: boolean) - Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1937 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator - key expressions: key (type: string), hr (type: string), ds (type: string) + key expressions: '103' (type: string), hr (type: string), ds (type: string) sort order: +++ - Map-reduce partition columns: key (type: string), hr (type: string), ds (type: string) - Statistics: Num rows: 58 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Map-reduce partition columns: hr (type: string), ds (type: string) + Statistics: Num rows: 1937 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Reduce Operator Tree: Join Operator condition map: @@ -207,11 +207,11 @@ STAGE PLANS: 0 1 {KEY.reducesinkkey2} {KEY.reducesinkkey1} outputColumnNames: _col8, _col9 - Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 2130 Data size: 6393 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col8 (type: string), _col9 (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 2130 Data size: 6393 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false table: @@ -226,15 +226,15 @@ STAGE PLANS: Reduce Output Operator key expressions: _col0 (type: string), _col1 (type: string) sort order: ++ - Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 2130 Data size: 6393 Basic stats: COMPLETE Column stats: NONE Reduce Operator Tree: Select Operator expressions: KEY.reducesinkkey0 (type: string), KEY.reducesinkkey1 (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 2130 Data size: 6393 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 63 Data size: 6393 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 2130 Data size: 6393 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Modified: hive/trunk/ql/src/test/results/clientpositive/regexp_extract.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/regexp_extract.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff ============================================================================== Files hive/trunk/ql/src/test/results/clientpositive/regexp_extract.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/regexp_extract.q.out Sat Jul 26 15:39:55 2014 differ Modified: hive/trunk/ql/src/test/results/clientpositive/sample8.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/sample8.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff ============================================================================== Files hive/trunk/ql/src/test/results/clientpositive/sample8.q.out (original) and hive/trunk/ql/src/test/results/clientpositive/sample8.q.out Sat Jul 26 15:39:55 2014 differ Modified: hive/trunk/ql/src/test/results/clientpositive/select_dummy_source.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/select_dummy_source.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/select_dummy_source.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/select_dummy_source.q.out Sat Jul 26 15:39:55 2014 @@ -64,7 +64,7 @@ STAGE PLANS: Row Limit Per Split: 1 Statistics: Num rows: 0 Data size: 1 Basic stats: PARTIAL Column stats: COMPLETE Select Operator - expressions: (1 + 1) (type: int) + expressions: 2 (type: int) outputColumnNames: _col0 Statistics: Num rows: 0 Data size: 1 Basic stats: PARTIAL Column stats: COMPLETE File Output Operator @@ -193,7 +193,7 @@ STAGE PLANS: Row Limit Per Split: 1 Statistics: Num rows: 0 Data size: 1 Basic stats: PARTIAL Column stats: COMPLETE Select Operator - expressions: (1 + 1) (type: int) + expressions: 2 (type: int) outputColumnNames: _col0 Statistics: Num rows: 0 Data size: 1 Basic stats: PARTIAL Column stats: COMPLETE ListSink @@ -277,7 +277,7 @@ STAGE PLANS: Row Limit Per Split: 1 Statistics: Num rows: 0 Data size: 1 Basic stats: PARTIAL Column stats: COMPLETE Select Operator - expressions: (2 + 3) (type: int), (1 + 2) (type: int) + expressions: 5 (type: int), (1 + 2) (type: int) outputColumnNames: _col0, _col1 Statistics: Num rows: 0 Data size: 1 Basic stats: PARTIAL Column stats: COMPLETE File Output Operator Modified: hive/trunk/ql/src/test/results/clientpositive/select_unquote_and.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/select_unquote_and.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/select_unquote_and.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/select_unquote_and.q.out Sat Jul 26 15:39:55 2014 @@ -58,7 +58,7 @@ STAGE PLANS: alias: npe_test Statistics: Num rows: 498 Data size: 5290 Basic stats: COMPLETE Column stats: NONE Filter Operator - predicate: ((ds > ((2012 - 11) - 31)) and (ds < ((2012 - 12) - 15))) (type: boolean) + predicate: ((ds > 1970) and (ds < 1985)) (type: boolean) Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: string), value (type: string), ds (type: string) Modified: hive/trunk/ql/src/test/results/clientpositive/select_unquote_not.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/select_unquote_not.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/select_unquote_not.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/select_unquote_not.q.out Sat Jul 26 15:39:55 2014 @@ -58,7 +58,7 @@ STAGE PLANS: alias: npe_test Statistics: Num rows: 498 Data size: 5290 Basic stats: COMPLETE Column stats: NONE Filter Operator - predicate: (not (ds < ((2012 - 11) - 31))) (type: boolean) + predicate: (not (ds < 1970)) (type: boolean) Statistics: Num rows: 332 Data size: 3526 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: string), value (type: string), ds (type: string) Modified: hive/trunk/ql/src/test/results/clientpositive/select_unquote_or.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/select_unquote_or.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/select_unquote_or.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/select_unquote_or.q.out Sat Jul 26 15:39:55 2014 @@ -58,7 +58,7 @@ STAGE PLANS: alias: npe_test Statistics: Num rows: 498 Data size: 5290 Basic stats: COMPLETE Column stats: NONE Filter Operator - predicate: ((ds > ((2012 - 11) - 31)) or (ds < ((2012 - 12) - 15))) (type: boolean) + predicate: ((ds > 1970) or (ds < 1985)) (type: boolean) Statistics: Num rows: 332 Data size: 3526 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: key (type: string), value (type: string), ds (type: string) Modified: hive/trunk/ql/src/test/results/clientpositive/set_processor_namespaces.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/set_processor_namespaces.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/set_processor_namespaces.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/set_processor_namespaces.q.out Sat Jul 26 15:39:55 2014 @@ -17,17 +17,17 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src - Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 57 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key = 5) (type: boolean) - Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: key (type: string), value (type: string) + expressions: '5' (type: string), value (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Modified: hive/trunk/ql/src/test/results/clientpositive/set_variable_sub.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/set_variable_sub.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/set_variable_sub.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/set_variable_sub.q.out Sat Jul 26 15:39:55 2014 @@ -12,17 +12,17 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src - Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 54 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key = 'value1') (type: boolean) - Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 27 Data size: 2906 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: key (type: string), value (type: string) + expressions: 'value1' (type: string), value (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 27 Data size: 2906 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 27 Data size: 2906 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -48,17 +48,17 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src - Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 54 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key = 'value1') (type: boolean) - Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 27 Data size: 2906 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: key (type: string), value (type: string) + expressions: 'value1' (type: string), value (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 27 Data size: 2906 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 27 Data size: 2906 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat @@ -84,17 +84,17 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src - Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 57 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key = '1') (type: boolean) - Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: key (type: string), value (type: string) + expressions: '1' (type: string), value (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 28 Data size: 2855 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Modified: hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_18.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_18.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_18.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_18.q.out Sat Jul 26 15:39:55 2014 @@ -208,12 +208,14 @@ POSTHOOK: Input: default@test_table2@ds= 253 PREHOOK: query: -- Insert data into the bucketed table by selecting from another bucketed table -- This should be a map-only operation, one of the buckets should be empty + EXPLAIN INSERT OVERWRITE TABLE test_table2 PARTITION (ds = '2') SELECT a.key, a.value FROM test_table1 a WHERE a.ds = '1' and a.key = 238 PREHOOK: type: QUERY POSTHOOK: query: -- Insert data into the bucketed table by selecting from another bucketed table -- This should be a map-only operation, one of the buckets should be empty + EXPLAIN INSERT OVERWRITE TABLE test_table2 PARTITION (ds = '2') SELECT a.key, a.value FROM test_table1 a WHERE a.ds = '1' and a.key = 238 Modified: hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_25.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_25.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_25.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/smb_mapjoin_25.q.out Sat Jul 26 15:39:55 2014 @@ -66,9 +66,8 @@ STAGE PLANS: predicate: (key is not null and (key = 5)) (type: boolean) Statistics: Num rows: 13 Data size: 52 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator - key expressions: key (type: int) + key expressions: 5 (type: int) sort order: + - Map-reduce partition columns: key (type: int) Statistics: Num rows: 13 Data size: 52 Basic stats: COMPLETE Column stats: NONE TableScan alias: a @@ -77,21 +76,19 @@ STAGE PLANS: predicate: (key is not null and (key = 5)) (type: boolean) Statistics: Num rows: 13 Data size: 52 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator - key expressions: key (type: int) + key expressions: 5 (type: int) sort order: + - Map-reduce partition columns: key (type: int) Statistics: Num rows: 13 Data size: 52 Basic stats: COMPLETE Column stats: NONE Reduce Operator Tree: Join Operator condition map: Inner Join 0 to 1 condition expressions: - 0 {KEY.reducesinkkey0} + 0 1 - outputColumnNames: _col0 Statistics: Num rows: 14 Data size: 57 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: int) + expressions: 5 (type: int) outputColumnNames: _col0 Statistics: Num rows: 14 Data size: 57 Basic stats: COMPLETE Column stats: NONE File Output Operator @@ -129,7 +126,7 @@ STAGE PLANS: predicate: (_col1 = 5) (type: boolean) Statistics: Num rows: 8 Data size: 33 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: int), _col1 (type: int) + expressions: _col0 (type: int), 5 (type: int) outputColumnNames: _col0, _col1 Statistics: Num rows: 8 Data size: 33 Basic stats: COMPLETE Column stats: NONE File Output Operator @@ -150,9 +147,8 @@ STAGE PLANS: predicate: (key is not null and (key = 5)) (type: boolean) Statistics: Num rows: 14 Data size: 56 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator - key expressions: key (type: int) + key expressions: 5 (type: int) sort order: + - Map-reduce partition columns: key (type: int) Statistics: Num rows: 14 Data size: 56 Basic stats: COMPLETE Column stats: NONE TableScan alias: c @@ -161,21 +157,19 @@ STAGE PLANS: predicate: (key is not null and (key = 5)) (type: boolean) Statistics: Num rows: 13 Data size: 52 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator - key expressions: key (type: int) + key expressions: 5 (type: int) sort order: + - Map-reduce partition columns: key (type: int) Statistics: Num rows: 13 Data size: 52 Basic stats: COMPLETE Column stats: NONE Reduce Operator Tree: Join Operator condition map: Inner Join 0 to 1 condition expressions: - 0 {KEY.reducesinkkey0} + 0 1 - outputColumnNames: _col0 Statistics: Num rows: 15 Data size: 61 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: _col0 (type: int) + expressions: 5 (type: int) outputColumnNames: _col0 Statistics: Num rows: 15 Data size: 61 Basic stats: COMPLETE Column stats: NONE File Output Operator Modified: hive/trunk/ql/src/test/results/clientpositive/stats_empty_dyn_part.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/stats_empty_dyn_part.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/stats_empty_dyn_part.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/stats_empty_dyn_part.q.out Sat Jul 26 15:39:55 2014 @@ -28,26 +28,26 @@ STAGE PLANS: Map Operator Tree: TableScan alias: src - Statistics: Num rows: 29 Data size: 5812 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 51 Data size: 5812 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: (key = 'no_such_value') (type: boolean) - Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 25 Data size: 2849 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: key (type: string), value (type: string) + expressions: 'no_such_value' (type: string), value (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 25 Data size: 2849 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col1 (type: string) sort order: + Map-reduce partition columns: _col1 (type: string) - Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 25 Data size: 2849 Basic stats: COMPLETE Column stats: NONE value expressions: _col0 (type: string), _col1 (type: string) Reduce Operator Tree: Extract - Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 25 Data size: 2849 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 14 Data size: 2805 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 25 Data size: 2849 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.TextInputFormat output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat Modified: hive/trunk/ql/src/test/results/clientpositive/subq_where_serialization.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/subq_where_serialization.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/subq_where_serialization.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/subq_where_serialization.q.out Sat Jul 26 15:39:55 2014 @@ -93,17 +93,15 @@ STAGE PLANS: 0 key (type: string) 1 _col0 (type: string) outputColumnNames: _col0 - Filter Operator - predicate: (1 = 1) (type: boolean) - Select Operator - expressions: _col0 (type: string) - outputColumnNames: _col0 - File Output Operator - compressed: false - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + Select Operator + expressions: _col0 (type: string) + outputColumnNames: _col0 + File Output Operator + compressed: false + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Local Work: Map Reduce Local Work @@ -136,20 +134,17 @@ STAGE PLANS: 1 outputColumnNames: _col0 Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE - Filter Operator - predicate: (1 = 1) (type: boolean) + Select Operator + expressions: _col0 (type: string) + outputColumnNames: _col0 Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: _col0 (type: string) - outputColumnNames: _col0 + File Output Operator + compressed: false Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Stage: Stage-0 Fetch Operator Modified: hive/trunk/ql/src/test/results/clientpositive/subquery_exists.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/subquery_exists.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/subquery_exists.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/subquery_exists.q.out Sat Jul 26 15:39:55 2014 @@ -66,20 +66,17 @@ STAGE PLANS: 1 outputColumnNames: _col0, _col1 Statistics: Num rows: 8 Data size: 1763 Basic stats: COMPLETE Column stats: NONE - Filter Operator - predicate: (1 = 1) (type: boolean) + Select Operator + expressions: _col0 (type: string), _col1 (type: string) + outputColumnNames: _col0, _col1 Statistics: Num rows: 8 Data size: 1763 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: _col0 (type: string), _col1 (type: string) - outputColumnNames: _col0, _col1 + File Output Operator + compressed: false Statistics: Num rows: 8 Data size: 1763 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 8 Data size: 1763 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Stage: Stage-0 Fetch Operator Modified: hive/trunk/ql/src/test/results/clientpositive/subquery_exists_having.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/subquery_exists_having.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/subquery_exists_having.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/subquery_exists_having.q.out Sat Jul 26 15:39:55 2014 @@ -104,20 +104,17 @@ STAGE PLANS: 1 outputColumnNames: _col0, _col1 Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE - Filter Operator - predicate: (1 = 1) (type: boolean) + Select Operator + expressions: _col0 (type: string), _col1 (type: bigint) + outputColumnNames: _col0, _col1 Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: _col0 (type: string), _col1 (type: bigint) - outputColumnNames: _col0, _col1 + File Output Operator + compressed: false Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 31 Data size: 3196 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Stage: Stage-0 Fetch Operator @@ -244,20 +241,17 @@ STAGE PLANS: 1 outputColumnNames: _col0, _col1 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE - Filter Operator - predicate: (1 = 1) (type: boolean) + Select Operator + expressions: _col0 (type: string), _col1 (type: bigint) + outputColumnNames: _col0, _col1 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE - Select Operator - expressions: _col0 (type: string), _col1 (type: bigint) - outputColumnNames: _col0, _col1 + File Output Operator + compressed: false Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Mux Operator Statistics: Num rows: 51 Data size: 5862 Basic stats: COMPLETE Column stats: NONE Join Operator @@ -268,20 +262,17 @@ STAGE PLANS: 1 outputColumnNames: _col0, _col1 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE - Filter Operator - predicate: (1 = 1) (type: boolean) + Select Operator + expressions: _col0 (type: string), _col1 (type: bigint) + outputColumnNames: _col0, _col1 Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE - Select Operator - expressions: _col0 (type: string), _col1 (type: bigint) - outputColumnNames: _col0, _col1 + File Output Operator + compressed: false Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 0 Data size: 0 Basic stats: NONE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Stage: Stage-0 Fetch Operator Modified: hive/trunk/ql/src/test/results/clientpositive/subquery_in.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/subquery_in.q.out?rev=1613661&r1=1613660&r2=1613661&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/subquery_in.q.out (original) +++ hive/trunk/ql/src/test/results/clientpositive/subquery_in.q.out Sat Jul 26 15:39:55 2014 @@ -157,20 +157,17 @@ STAGE PLANS: 1 outputColumnNames: _col0, _col1 Statistics: Num rows: 16 Data size: 3306 Basic stats: COMPLETE Column stats: NONE - Filter Operator - predicate: (1 = 1) (type: boolean) + Select Operator + expressions: _col0 (type: string), _col1 (type: string) + outputColumnNames: _col0, _col1 Statistics: Num rows: 16 Data size: 3306 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: _col0 (type: string), _col1 (type: string) - outputColumnNames: _col0, _col1 + File Output Operator + compressed: false Statistics: Num rows: 16 Data size: 3306 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 16 Data size: 3306 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Stage: Stage-0 Fetch Operator @@ -269,20 +266,17 @@ STAGE PLANS: 1 outputColumnNames: _col0, _col1 Statistics: Num rows: 8 Data size: 1763 Basic stats: COMPLETE Column stats: NONE - Filter Operator - predicate: (1 = 1) (type: boolean) + Select Operator + expressions: _col0 (type: string), _col1 (type: string) + outputColumnNames: _col0, _col1 Statistics: Num rows: 8 Data size: 1763 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: _col0 (type: string), _col1 (type: string) - outputColumnNames: _col0, _col1 + File Output Operator + compressed: false Statistics: Num rows: 8 Data size: 1763 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 8 Data size: 1763 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Stage: Stage-0 Fetch Operator @@ -447,20 +441,17 @@ STAGE PLANS: 1 outputColumnNames: _col1, _col5 Statistics: Num rows: 16 Data size: 1744 Basic stats: COMPLETE Column stats: NONE - Filter Operator - predicate: (1 = 1) (type: boolean) + Select Operator + expressions: _col1 (type: string), _col5 (type: int) + outputColumnNames: _col0, _col1 Statistics: Num rows: 16 Data size: 1744 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: _col1 (type: string), _col5 (type: int) - outputColumnNames: _col0, _col1 + File Output Operator + compressed: false Statistics: Num rows: 16 Data size: 1744 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 16 Data size: 1744 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Stage: Stage-0 Fetch Operator @@ -618,20 +609,17 @@ STAGE PLANS: 1 outputColumnNames: _col1, _col2, _col5 Statistics: Num rows: 4 Data size: 930 Basic stats: COMPLETE Column stats: NONE - Filter Operator - predicate: (1 = 1) (type: boolean) + Select Operator + expressions: _col2 (type: string), _col1 (type: string), _col5 (type: int) + outputColumnNames: _col0, _col1, _col2 Statistics: Num rows: 4 Data size: 930 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: _col2 (type: string), _col1 (type: string), _col5 (type: int) - outputColumnNames: _col0, _col1, _col2 + File Output Operator + compressed: false Statistics: Num rows: 4 Data size: 930 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 4 Data size: 930 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Stage: Stage-0 Fetch Operator @@ -763,20 +751,17 @@ STAGE PLANS: 1 outputColumnNames: _col0, _col1 Statistics: Num rows: 8 Data size: 1763 Basic stats: COMPLETE Column stats: NONE - Filter Operator - predicate: (1 = 1) (type: boolean) + Select Operator + expressions: _col0 (type: string), _col1 (type: string) + outputColumnNames: _col0, _col1 Statistics: Num rows: 8 Data size: 1763 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: _col0 (type: string), _col1 (type: string) - outputColumnNames: _col0, _col1 + File Output Operator + compressed: false Statistics: Num rows: 8 Data size: 1763 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 8 Data size: 1763 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe + table: + input format: org.apache.hadoop.mapred.TextInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat + serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe Stage: Stage-0 Fetch Operator @@ -947,24 +932,24 @@ STAGE PLANS: value expressions: _col0 (type: int), _col3 (type: int) TableScan alias: lineitem - Statistics: Num rows: 116 Data size: 12099 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 1728 Data size: 12099 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((l_shipmode = 'AIR') and l_orderkey is not null) (type: boolean) - Statistics: Num rows: 29 Data size: 3024 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 432 Data size: 3024 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: l_orderkey (type: int) outputColumnNames: _col0 - Statistics: Num rows: 29 Data size: 3024 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 432 Data size: 3024 Basic stats: COMPLETE Column stats: NONE Group By Operator keys: _col0 (type: int) mode: hash outputColumnNames: _col0 - Statistics: Num rows: 29 Data size: 3024 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 432 Data size: 3024 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: int) sort order: + Map-reduce partition columns: _col0 (type: int) - Statistics: Num rows: 29 Data size: 3024 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 432 Data size: 3024 Basic stats: COMPLETE Column stats: NONE Reduce Operator Tree: Join Operator condition map:
