You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by ha...@apache.org on 2013/03/02 23:38:08 UTC
svn commit: r1451954 [17/27] - in /hive/branches/ptf-windowing: ./
cli/src/java/org/apache/hadoop/hive/cli/ common/src/java/conf/
common/src/java/org/apache/hadoop/hive/conf/ conf/
contrib/src/test/results/clientpositive/ data/conf/ data/files/ hbase-h...
Modified: hive/branches/ptf-windowing/ql/src/test/results/clientpositive/index_auto_self_join.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientpositive/index_auto_self_join.q.out?rev=1451954&r1=1451953&r2=1451954&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientpositive/index_auto_self_join.q.out (original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientpositive/index_auto_self_join.q.out Sat Mar 2 22:37:59 2013
@@ -185,44 +185,28 @@ STAGE PLANS:
type: string
expr: _offset
type: bigint
- expr: _bitmaps
- type: array<bigint>
- outputColumnNames: _col1, _col2, _col3
- Select Operator
- expressions:
- expr: _col1
+ outputColumnNames: _col0, _col1
+ Group By Operator
+ aggregations:
+ expr: collect_set(_col1)
+ bucketGroup: false
+ keys:
+ expr: _col0
type: string
- expr: _col2
- type: bigint
+ mode: hash
outputColumnNames: _col0, _col1
- Select Operator
- expressions:
+ Reduce Output Operator
+ key expressions:
expr: _col0
type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ tag: -1
+ value expressions:
expr: _col1
- type: bigint
- outputColumnNames: _col0, _col1
- Group By Operator
- aggregations:
- expr: collect_set(_col1)
- bucketGroup: false
- keys:
- expr: _col0
- type: string
- mode: hash
- outputColumnNames: _col0, _col1
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: _col0
- type: string
- tag: -1
- value expressions:
- expr: _col1
- type: array<bigint>
+ type: array<bigint>
Reduce Operator Tree:
Group By Operator
aggregations:
@@ -366,44 +350,28 @@ STAGE PLANS:
type: string
expr: _offset
type: bigint
- expr: _bitmaps
- type: array<bigint>
- outputColumnNames: _col1, _col2, _col3
- Select Operator
- expressions:
- expr: _col1
+ outputColumnNames: _col0, _col1
+ Group By Operator
+ aggregations:
+ expr: collect_set(_col1)
+ bucketGroup: false
+ keys:
+ expr: _col0
type: string
- expr: _col2
- type: bigint
+ mode: hash
outputColumnNames: _col0, _col1
- Select Operator
- expressions:
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
expr: _col0
type: string
+ tag: -1
+ value expressions:
expr: _col1
- type: bigint
- outputColumnNames: _col0, _col1
- Group By Operator
- aggregations:
- expr: collect_set(_col1)
- bucketGroup: false
- keys:
- expr: _col0
- type: string
- mode: hash
- outputColumnNames: _col0, _col1
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: _col0
- type: string
- tag: -1
- value expressions:
- expr: _col1
- type: array<bigint>
+ type: array<bigint>
Reduce Operator Tree:
Group By Operator
aggregations:
Modified: hive/branches/ptf-windowing/ql/src/test/results/clientpositive/index_bitmap_auto_partitioned.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientpositive/index_bitmap_auto_partitioned.q.out?rev=1451954&r1=1451953&r2=1451954&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientpositive/index_bitmap_auto_partitioned.q.out (original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientpositive/index_bitmap_auto_partitioned.q.out Sat Mar 2 22:37:59 2013
@@ -68,44 +68,28 @@ STAGE PLANS:
type: string
expr: _offset
type: bigint
- expr: _bitmaps
- type: array<bigint>
- outputColumnNames: _col1, _col2, _col3
- Select Operator
- expressions:
- expr: _col1
+ outputColumnNames: _col0, _col1
+ Group By Operator
+ aggregations:
+ expr: collect_set(_col1)
+ bucketGroup: false
+ keys:
+ expr: _col0
type: string
- expr: _col2
- type: bigint
+ mode: hash
outputColumnNames: _col0, _col1
- Select Operator
- expressions:
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
expr: _col0
type: string
+ tag: -1
+ value expressions:
expr: _col1
- type: bigint
- outputColumnNames: _col0, _col1
- Group By Operator
- aggregations:
- expr: collect_set(_col1)
- bucketGroup: false
- keys:
- expr: _col0
- type: string
- mode: hash
- outputColumnNames: _col0, _col1
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: _col0
- type: string
- tag: -1
- value expressions:
- expr: _col1
- type: array<bigint>
+ type: array<bigint>
Reduce Operator Tree:
Group By Operator
aggregations:
Modified: hive/branches/ptf-windowing/ql/src/test/results/clientpositive/index_bitmap_compression.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientpositive/index_bitmap_compression.q.out?rev=1451954&r1=1451953&r2=1451954&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientpositive/index_bitmap_compression.q.out (original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientpositive/index_bitmap_compression.q.out Sat Mar 2 22:37:59 2013
@@ -54,44 +54,28 @@ STAGE PLANS:
type: string
expr: _offset
type: bigint
- expr: _bitmaps
- type: array<bigint>
- outputColumnNames: _col1, _col2, _col3
- Select Operator
- expressions:
- expr: _col1
+ outputColumnNames: _col0, _col1
+ Group By Operator
+ aggregations:
+ expr: collect_set(_col1)
+ bucketGroup: false
+ keys:
+ expr: _col0
type: string
- expr: _col2
- type: bigint
+ mode: hash
outputColumnNames: _col0, _col1
- Select Operator
- expressions:
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
expr: _col0
type: string
+ tag: -1
+ value expressions:
expr: _col1
- type: bigint
- outputColumnNames: _col0, _col1
- Group By Operator
- aggregations:
- expr: collect_set(_col1)
- bucketGroup: false
- keys:
- expr: _col0
- type: string
- mode: hash
- outputColumnNames: _col0, _col1
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: _col0
- type: string
- tag: -1
- value expressions:
- expr: _col1
- type: array<bigint>
+ type: array<bigint>
Reduce Operator Tree:
Group By Operator
aggregations:
Modified: hive/branches/ptf-windowing/ql/src/test/results/clientpositive/infer_bucket_sort_dyn_part.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientpositive/infer_bucket_sort_dyn_part.q.out?rev=1451954&r1=1451953&r2=1451954&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientpositive/infer_bucket_sort_dyn_part.q.out (original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientpositive/infer_bucket_sort_dyn_part.q.out Sat Mar 2 22:37:59 2013
@@ -673,35 +673,19 @@ STAGE PLANS:
expressions:
expr: _col0
type: string
- expr: _col1
- type: bigint
- outputColumnNames: _col0, _col1
- Select Operator
- expressions:
- expr: _col0
- type: string
- expr: _col1
- type: bigint
- expr: if(((_col0 % 100) = 0), '11', '12')
- type: string
- outputColumnNames: _col0, _col1, _col2
- Select Operator
- expressions:
- expr: _col0
- type: string
- expr: UDFToString(_col1)
- type: string
- expr: _col2
- type: string
- outputColumnNames: _col0, _col1, _col2
- File Output Operator
- compressed: false
- GlobalTableId: 1
- table:
- input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat
- output format: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
- serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
- name: default.test_table
+ expr: UDFToString(_col1)
+ type: string
+ expr: if(((_col0 % 100) = 0), '11', '12')
+ type: string
+ outputColumnNames: _col0, _col1, _col2
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ table:
+ input format: org.apache.hadoop.hive.ql.io.RCFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.RCFileOutputFormat
+ serde: org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe
+ name: default.test_table
Stage: Stage-7
Conditional Operator
Modified: hive/branches/ptf-windowing/ql/src/test/results/clientpositive/infer_bucket_sort_map_operators.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientpositive/infer_bucket_sort_map_operators.q.out?rev=1451954&r1=1451953&r2=1451954&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientpositive/infer_bucket_sort_map_operators.q.out (original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientpositive/infer_bucket_sort_map_operators.q.out Sat Mar 2 22:37:59 2013
@@ -492,22 +492,15 @@ STAGE PLANS:
type: string
expr: _col5
type: string
- outputColumnNames: _col0, _col5
- Select Operator
- expressions:
- expr: _col0
- type: string
- expr: _col5
- type: string
- outputColumnNames: _col0, _col1
- File Output Operator
- compressed: false
- GlobalTableId: 1
- 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
- name: default.test_table_out
+ outputColumnNames: _col0, _col1
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ 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
+ name: default.test_table_out
Stage: Stage-7
Conditional Operator
@@ -688,32 +681,27 @@ STAGE PLANS:
expr: _col5
type: string
outputColumnNames: _col5
- Select Operator
- expressions:
+ Group By Operator
+ aggregations:
+ expr: count()
+ bucketGroup: false
+ keys:
expr: _col5
type: string
- outputColumnNames: _col5
- Group By Operator
- aggregations:
- expr: count()
- bucketGroup: false
- keys:
- expr: _col5
+ mode: hash
+ outputColumnNames: _col0, _col1
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
type: string
- mode: hash
- outputColumnNames: _col0, _col1
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: _col0
- type: string
- tag: -1
- value expressions:
- expr: _col1
- type: bigint
+ tag: -1
+ value expressions:
+ expr: _col1
+ type: bigint
Reduce Operator Tree:
Group By Operator
aggregations:
Modified: hive/branches/ptf-windowing/ql/src/test/results/clientpositive/infer_bucket_sort_num_buckets.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientpositive/infer_bucket_sort_num_buckets.q.out?rev=1451954&r1=1451953&r2=1451954&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientpositive/infer_bucket_sort_num_buckets.q.out (original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientpositive/infer_bucket_sort_num_buckets.q.out Sat Mar 2 22:37:59 2013
@@ -66,31 +66,22 @@ STAGE PLANS:
type: int
expr: value
type: string
- expr: (key % 2)
- type: double
+ expr: UDFToInteger((key % 2))
+ type: int
outputColumnNames: _col0, _col1, _col2
- Select Operator
- expressions:
+ Reduce Output Operator
+ sort order:
+ Map-reduce partition columns:
+ expr: _col0
+ type: int
+ tag: -1
+ value expressions:
expr: _col0
type: int
expr: _col1
type: string
- expr: UDFToInteger(_col2)
+ expr: _col2
type: int
- outputColumnNames: _col0, _col1, _col2
- Reduce Output Operator
- sort order:
- Map-reduce partition columns:
- expr: _col0
- type: int
- tag: -1
- value expressions:
- expr: _col0
- type: int
- expr: _col1
- type: string
- expr: _col2
- type: int
Reduce Operator Tree:
Extract
File Output Operator
Modified: hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input11.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input11.q.out?rev=1451954&r1=1451953&r2=1451954&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input11.q.out (original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input11.q.out Sat Mar 2 22:37:59 2013
@@ -37,26 +37,19 @@ STAGE PLANS:
type: boolean
Select Operator
expressions:
- expr: key
- type: string
+ expr: UDFToInteger(key)
+ type: int
expr: value
type: string
outputColumnNames: _col0, _col1
- Select Operator
- expressions:
- expr: UDFToInteger(_col0)
- type: int
- expr: _col1
- type: string
- outputColumnNames: _col0, _col1
- File Output Operator
- compressed: false
- GlobalTableId: 1
- 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
- name: default.dest1
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ 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
+ name: default.dest1
Stage: Stage-7
Conditional Operator
Modified: hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input12_hadoop20.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input12_hadoop20.q.out?rev=1451954&r1=1451953&r2=1451954&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input12_hadoop20.q.out (original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input12_hadoop20.q.out Sat Mar 2 22:37:59 2013
@@ -69,74 +69,55 @@ STAGE PLANS:
type: boolean
Select Operator
expressions:
- expr: key
- type: string
+ expr: UDFToInteger(key)
+ type: int
expr: value
type: string
outputColumnNames: _col0, _col1
- Select Operator
- expressions:
- expr: UDFToInteger(_col0)
- type: int
- expr: _col1
- type: string
- outputColumnNames: _col0, _col1
- File Output Operator
- compressed: false
- GlobalTableId: 1
- 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
- name: default.dest1
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ 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
+ name: default.dest1
Filter Operator
predicate:
expr: ((key >= 100.0) and (key < 200.0))
type: boolean
Select Operator
expressions:
- expr: key
- type: string
+ expr: UDFToInteger(key)
+ type: int
expr: value
type: string
outputColumnNames: _col0, _col1
- Select Operator
- expressions:
- expr: UDFToInteger(_col0)
- type: int
- expr: _col1
- type: string
- outputColumnNames: _col0, _col1
- File Output Operator
- compressed: false
- GlobalTableId: 2
- 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
- name: default.dest2
+ File Output Operator
+ compressed: false
+ GlobalTableId: 2
+ 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
+ name: default.dest2
Filter Operator
predicate:
expr: (key >= 200.0)
type: boolean
Select Operator
expressions:
- expr: key
- type: string
+ expr: UDFToInteger(key)
+ type: int
outputColumnNames: _col0
- Select Operator
- expressions:
- expr: UDFToInteger(_col0)
- type: int
- outputColumnNames: _col0
- File Output Operator
- compressed: false
- GlobalTableId: 3
- 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
- name: default.dest3
+ File Output Operator
+ compressed: false
+ GlobalTableId: 3
+ 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
+ name: default.dest3
Stage: Stage-9
Conditional Operator
Modified: hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input13.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input13.q.out?rev=1451954&r1=1451953&r2=1451954&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input13.q.out (original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input13.q.out Sat Mar 2 22:37:59 2013
@@ -73,74 +73,55 @@ STAGE PLANS:
type: boolean
Select Operator
expressions:
- expr: key
- type: string
+ expr: UDFToInteger(key)
+ type: int
expr: value
type: string
outputColumnNames: _col0, _col1
- Select Operator
- expressions:
- expr: UDFToInteger(_col0)
- type: int
- expr: _col1
- type: string
- outputColumnNames: _col0, _col1
- File Output Operator
- compressed: false
- GlobalTableId: 1
- 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
- name: default.dest1
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ 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
+ name: default.dest1
Filter Operator
predicate:
expr: ((key >= 100.0) and (key < 200.0))
type: boolean
Select Operator
expressions:
- expr: key
- type: string
+ expr: UDFToInteger(key)
+ type: int
expr: value
type: string
outputColumnNames: _col0, _col1
- Select Operator
- expressions:
- expr: UDFToInteger(_col0)
- type: int
- expr: _col1
- type: string
- outputColumnNames: _col0, _col1
- File Output Operator
- compressed: false
- GlobalTableId: 2
- 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
- name: default.dest2
+ File Output Operator
+ compressed: false
+ GlobalTableId: 2
+ 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
+ name: default.dest2
Filter Operator
predicate:
expr: ((key >= 200.0) and (key < 300.0))
type: boolean
Select Operator
expressions:
- expr: key
- type: string
+ expr: UDFToInteger(key)
+ type: int
outputColumnNames: _col0
- Select Operator
- expressions:
- expr: UDFToInteger(_col0)
- type: int
- outputColumnNames: _col0
- File Output Operator
- compressed: false
- GlobalTableId: 3
- 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
- name: default.dest3
+ File Output Operator
+ compressed: false
+ GlobalTableId: 3
+ 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
+ name: default.dest3
Filter Operator
predicate:
expr: (key >= 300.0)
Modified: hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input14.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input14.q.out?rev=1451954&r1=1451953&r2=1451954&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input14.q.out (original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input14.q.out Sat Mar 2 22:37:59 2013
@@ -70,26 +70,19 @@ STAGE PLANS:
Extract
Select Operator
expressions:
- expr: _col0
- type: string
+ expr: UDFToInteger(_col0)
+ type: int
expr: _col1
type: string
outputColumnNames: _col0, _col1
- Select Operator
- expressions:
- expr: UDFToInteger(_col0)
- type: int
- expr: _col1
- type: string
- outputColumnNames: _col0, _col1
- File Output Operator
- compressed: false
- GlobalTableId: 1
- 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
- name: default.dest1
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ 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
+ name: default.dest1
Stage: Stage-0
Move Operator
Modified: hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input14_limit.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input14_limit.q.out?rev=1451954&r1=1451953&r2=1451954&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input14_limit.q.out (original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input14_limit.q.out Sat Mar 2 22:37:59 2013
@@ -100,26 +100,19 @@ STAGE PLANS:
type: boolean
Select Operator
expressions:
- expr: _col0
- type: string
+ expr: UDFToInteger(_col0)
+ type: int
expr: _col1
type: string
outputColumnNames: _col0, _col1
- Select Operator
- expressions:
- expr: UDFToInteger(_col0)
- type: int
- expr: _col1
- type: string
- outputColumnNames: _col0, _col1
- File Output Operator
- compressed: false
- GlobalTableId: 1
- 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
- name: default.dest1
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ 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
+ name: default.dest1
Stage: Stage-0
Move Operator
Modified: hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input17.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input17.q.out?rev=1451954&r1=1451953&r2=1451954&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input17.q.out (original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input17.q.out Sat Mar 2 22:37:59 2013
@@ -66,26 +66,19 @@ STAGE PLANS:
Extract
Select Operator
expressions:
- expr: _col0
- type: string
+ expr: UDFToInteger(_col0)
+ type: int
expr: _col1
type: string
outputColumnNames: _col0, _col1
- Select Operator
- expressions:
- expr: UDFToInteger(_col0)
- type: int
- expr: _col1
- type: string
- outputColumnNames: _col0, _col1
- File Output Operator
- compressed: false
- GlobalTableId: 1
- 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
- name: default.dest1
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ 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
+ name: default.dest1
Stage: Stage-0
Move Operator
Modified: hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input18.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input18.q.out?rev=1451954&r1=1451953&r2=1451954&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input18.q.out (original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input18.q.out Sat Mar 2 22:37:59 2013
@@ -74,26 +74,19 @@ STAGE PLANS:
Extract
Select Operator
expressions:
- expr: _col0
- type: string
+ expr: UDFToInteger(_col0)
+ type: int
expr: regexp_replace(_col1, ' ', '+')
type: string
outputColumnNames: _col0, _col1
- Select Operator
- expressions:
- expr: UDFToInteger(_col0)
- type: int
- expr: _col1
- type: string
- outputColumnNames: _col0, _col1
- File Output Operator
- compressed: false
- GlobalTableId: 1
- 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
- name: default.dest1
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ 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
+ name: default.dest1
Stage: Stage-0
Move Operator
Modified: hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input22.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input22.q.out?rev=1451954&r1=1451953&r2=1451954&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input22.q.out (original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input22.q.out Sat Mar 2 22:37:59 2013
@@ -39,21 +39,16 @@ STAGE PLANS:
expressions:
expr: key
type: string
- outputColumnNames: _col2
- Select Operator
- expressions:
- expr: _col2
+ outputColumnNames: _col0
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ tag: -1
+ value expressions:
+ expr: _col0
type: string
- outputColumnNames: _col0
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- sort order: +
- tag: -1
- value expressions:
- expr: _col0
- type: string
Reduce Operator Tree:
Extract
Limit
Modified: hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input30.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input30.q.out?rev=1451954&r1=1451953&r2=1451954&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input30.q.out (original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input30.q.out Sat Mar 2 22:37:59 2013
@@ -57,22 +57,17 @@ STAGE PLANS:
outputColumnNames: _col0
Select Operator
expressions:
- expr: _col0
- type: bigint
+ expr: UDFToInteger(_col0)
+ type: int
outputColumnNames: _col0
- Select Operator
- expressions:
- expr: UDFToInteger(_col0)
- type: int
- outputColumnNames: _col0
- File Output Operator
- compressed: false
- GlobalTableId: 1
- 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
- name: default.tst_dest30
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ 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
+ name: default.tst_dest30
Stage: Stage-0
Move Operator
Modified: hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input31.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input31.q.out?rev=1451954&r1=1451953&r2=1451954&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input31.q.out (original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input31.q.out Sat Mar 2 22:37:59 2013
@@ -57,22 +57,17 @@ STAGE PLANS:
outputColumnNames: _col0
Select Operator
expressions:
- expr: _col0
- type: bigint
+ expr: UDFToInteger(_col0)
+ type: int
outputColumnNames: _col0
- Select Operator
- expressions:
- expr: UDFToInteger(_col0)
- type: int
- outputColumnNames: _col0
- File Output Operator
- compressed: false
- GlobalTableId: 1
- 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
- name: default.tst_dest31
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ 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
+ name: default.tst_dest31
Stage: Stage-0
Move Operator
Modified: hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input32.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input32.q.out?rev=1451954&r1=1451953&r2=1451954&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input32.q.out (original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input32.q.out Sat Mar 2 22:37:59 2013
@@ -53,22 +53,17 @@ STAGE PLANS:
outputColumnNames: _col0
Select Operator
expressions:
- expr: _col0
- type: bigint
+ expr: UDFToInteger(_col0)
+ type: int
outputColumnNames: _col0
- Select Operator
- expressions:
- expr: UDFToInteger(_col0)
- type: int
- outputColumnNames: _col0
- File Output Operator
- compressed: false
- GlobalTableId: 1
- 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
- name: default.tst_dest32
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ 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
+ name: default.tst_dest32
Stage: Stage-0
Move Operator
Modified: hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input34.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input34.q.out?rev=1451954&r1=1451953&r2=1451954&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input34.q.out (original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input34.q.out Sat Mar 2 22:37:59 2013
@@ -55,26 +55,19 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Select Operator
expressions:
- expr: _col0
- type: string
+ expr: UDFToInteger(_col0)
+ type: int
expr: _col1
type: string
outputColumnNames: _col0, _col1
- Select Operator
- expressions:
- expr: UDFToInteger(_col0)
- type: int
- expr: _col1
- type: string
- outputColumnNames: _col0, _col1
- File Output Operator
- compressed: false
- GlobalTableId: 1
- 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
- name: default.dest1
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ 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
+ name: default.dest1
Stage: Stage-7
Conditional Operator
Modified: hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input35.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input35.q.out?rev=1451954&r1=1451953&r2=1451954&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input35.q.out (original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input35.q.out Sat Mar 2 22:37:59 2013
@@ -55,26 +55,19 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Select Operator
expressions:
- expr: _col0
- type: string
+ expr: UDFToInteger(_col0)
+ type: int
expr: _col1
type: string
outputColumnNames: _col0, _col1
- Select Operator
- expressions:
- expr: UDFToInteger(_col0)
- type: int
- expr: _col1
- type: string
- outputColumnNames: _col0, _col1
- File Output Operator
- compressed: false
- GlobalTableId: 1
- 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
- name: default.dest1
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ 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
+ name: default.dest1
Stage: Stage-7
Conditional Operator
Modified: hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input36.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input36.q.out?rev=1451954&r1=1451953&r2=1451954&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input36.q.out (original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input36.q.out Sat Mar 2 22:37:59 2013
@@ -55,26 +55,19 @@ STAGE PLANS:
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Select Operator
expressions:
- expr: _col0
- type: string
+ expr: UDFToInteger(_col0)
+ type: int
expr: _col1
type: string
outputColumnNames: _col0, _col1
- Select Operator
- expressions:
- expr: UDFToInteger(_col0)
- type: int
- expr: _col1
- type: string
- outputColumnNames: _col0, _col1
- File Output Operator
- compressed: false
- GlobalTableId: 1
- 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
- name: default.dest1
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ 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
+ name: default.dest1
Stage: Stage-7
Conditional Operator
Modified: hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input7.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input7.q.out?rev=1451954&r1=1451953&r2=1451954&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input7.q.out (original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input7.q.out Sat Mar 2 22:37:59 2013
@@ -33,26 +33,19 @@ STAGE PLANS:
alias: src1
Select Operator
expressions:
- expr: null
- type: string
- expr: key
- type: string
+ expr: UDFToDouble(null)
+ type: double
+ expr: UDFToInteger(key)
+ type: int
outputColumnNames: _col0, _col1
- Select Operator
- expressions:
- expr: UDFToDouble(_col0)
- type: double
- expr: UDFToInteger(_col1)
- type: int
- outputColumnNames: _col0, _col1
- File Output Operator
- compressed: false
- GlobalTableId: 1
- 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
- name: default.dest1
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ 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
+ name: default.dest1
Stage: Stage-7
Conditional Operator
Modified: hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input8.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input8.q.out?rev=1451954&r1=1451953&r2=1451954&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input8.q.out (original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input8.q.out Sat Mar 2 22:37:59 2013
@@ -35,28 +35,19 @@ STAGE PLANS:
expressions:
expr: (4 + null)
type: int
- expr: (key - null)
+ expr: UDFToInteger((key - null))
+ type: int
+ expr: UDFToDouble((null + null))
type: double
- expr: (null + null)
- type: tinyint
outputColumnNames: _col0, _col1, _col2
- Select Operator
- expressions:
- expr: _col0
- type: int
- expr: UDFToInteger(_col1)
- type: int
- expr: UDFToDouble(_col2)
- type: double
- outputColumnNames: _col0, _col1, _col2
- File Output Operator
- compressed: false
- GlobalTableId: 1
- 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
- name: default.dest1
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ 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
+ name: default.dest1
Stage: Stage-7
Conditional Operator
Modified: hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input9.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input9.q.out?rev=1451954&r1=1451953&r2=1451954&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input9.q.out (original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input9.q.out Sat Mar 2 22:37:59 2013
@@ -39,24 +39,17 @@ STAGE PLANS:
expressions:
expr: null
type: string
- expr: key
- type: string
+ expr: UDFToInteger(key)
+ type: int
outputColumnNames: _col0, _col1
- Select Operator
- expressions:
- expr: _col0
- type: void
- expr: UDFToInteger(_col1)
- type: int
- outputColumnNames: _col0, _col1
- File Output Operator
- compressed: false
- GlobalTableId: 1
- 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
- name: default.dest1
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ 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
+ name: default.dest1
Stage: Stage-7
Conditional Operator
Modified: hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input_part1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input_part1.q.out?rev=1451954&r1=1451953&r2=1451954&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input_part1.q.out (original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input_part1.q.out Sat Mar 2 22:37:59 2013
@@ -39,8 +39,8 @@ STAGE PLANS:
type: boolean
Select Operator
expressions:
- expr: key
- type: string
+ expr: UDFToInteger(key)
+ type: int
expr: value
type: string
expr: hr
@@ -48,41 +48,30 @@ STAGE PLANS:
expr: ds
type: string
outputColumnNames: _col0, _col1, _col2, _col3
- Select Operator
- expressions:
- expr: UDFToInteger(_col0)
- type: int
- expr: _col1
- type: string
- expr: _col2
- type: string
- expr: _col3
- type: string
- outputColumnNames: _col0, _col1, _col2, _col3
- File Output Operator
- compressed: false
- GlobalTableId: 1
-#### A masked pattern was here ####
- NumFilesPerFileSink: 1
-#### A masked pattern was here ####
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- properties:
- bucket_count -1
- columns key,value,hr,ds
- columns.types int:string:string:string
-#### A masked pattern was here ####
- name default.dest1
- serialization.ddl struct dest1 { i32 key, string value, string hr, string ds}
- serialization.format 1
- serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-#### A masked pattern was here ####
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.dest1
- TotalFiles: 1
- GatherStats: true
- MultiFileSpray: false
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+#### A masked pattern was here ####
+ NumFilesPerFileSink: 1
+#### A masked pattern was here ####
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ bucket_count -1
+ columns key,value,hr,ds
+ columns.types int:string:string:string
+#### A masked pattern was here ####
+ name default.dest1
+ serialization.ddl struct dest1 { i32 key, string value, string hr, string ds}
+ serialization.format 1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+#### A masked pattern was here ####
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: default.dest1
+ TotalFiles: 1
+ GatherStats: true
+ MultiFileSpray: false
Needs Tagging: false
Path -> Alias:
#### A masked pattern was here ####
Modified: hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input_part2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input_part2.q.out?rev=1451954&r1=1451953&r2=1451954&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input_part2.q.out (original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input_part2.q.out Sat Mar 2 22:37:59 2013
@@ -53,8 +53,8 @@ STAGE PLANS:
type: boolean
Select Operator
expressions:
- expr: key
- type: string
+ expr: UDFToInteger(key)
+ type: int
expr: value
type: string
expr: hr
@@ -62,41 +62,30 @@ STAGE PLANS:
expr: ds
type: string
outputColumnNames: _col0, _col1, _col2, _col3
- Select Operator
- expressions:
- expr: UDFToInteger(_col0)
- type: int
- expr: _col1
- type: string
- expr: _col2
- type: string
- expr: _col3
- type: string
- outputColumnNames: _col0, _col1, _col2, _col3
- File Output Operator
- compressed: false
- GlobalTableId: 1
-#### A masked pattern was here ####
- NumFilesPerFileSink: 1
-#### A masked pattern was here ####
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- properties:
- bucket_count -1
- columns key,value,hr,ds
- columns.types int:string:string:string
-#### A masked pattern was here ####
- name default.dest1
- serialization.ddl struct dest1 { i32 key, string value, string hr, string ds}
- serialization.format 1
- serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-#### A masked pattern was here ####
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.dest1
- TotalFiles: 1
- GatherStats: true
- MultiFileSpray: false
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+#### A masked pattern was here ####
+ NumFilesPerFileSink: 1
+#### A masked pattern was here ####
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ bucket_count -1
+ columns key,value,hr,ds
+ columns.types int:string:string:string
+#### A masked pattern was here ####
+ name default.dest1
+ serialization.ddl struct dest1 { i32 key, string value, string hr, string ds}
+ serialization.format 1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+#### A masked pattern was here ####
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: default.dest1
+ TotalFiles: 1
+ GatherStats: true
+ MultiFileSpray: false
Filter Operator
isSamplingPred: false
predicate:
@@ -104,8 +93,8 @@ STAGE PLANS:
type: boolean
Select Operator
expressions:
- expr: key
- type: string
+ expr: UDFToInteger(key)
+ type: int
expr: value
type: string
expr: hr
@@ -113,41 +102,30 @@ STAGE PLANS:
expr: ds
type: string
outputColumnNames: _col0, _col1, _col2, _col3
- Select Operator
- expressions:
- expr: UDFToInteger(_col0)
- type: int
- expr: _col1
- type: string
- expr: _col2
- type: string
- expr: _col3
- type: string
- outputColumnNames: _col0, _col1, _col2, _col3
- File Output Operator
- compressed: false
- GlobalTableId: 2
-#### A masked pattern was here ####
- NumFilesPerFileSink: 1
-#### A masked pattern was here ####
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- properties:
- bucket_count -1
- columns key,value,hr,ds
- columns.types int:string:string:string
-#### A masked pattern was here ####
- name default.dest2
- serialization.ddl struct dest2 { i32 key, string value, string hr, string ds}
- serialization.format 1
- serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
-#### A masked pattern was here ####
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.dest2
- TotalFiles: 1
- GatherStats: true
- MultiFileSpray: false
+ File Output Operator
+ compressed: false
+ GlobalTableId: 2
+#### A masked pattern was here ####
+ NumFilesPerFileSink: 1
+#### A masked pattern was here ####
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ bucket_count -1
+ columns key,value,hr,ds
+ columns.types int:string:string:string
+#### A masked pattern was here ####
+ name default.dest2
+ serialization.ddl struct dest2 { i32 key, string value, string hr, string ds}
+ serialization.format 1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+#### A masked pattern was here ####
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: default.dest2
+ TotalFiles: 1
+ GatherStats: true
+ MultiFileSpray: false
Needs Tagging: false
Path -> Alias:
#### A masked pattern was here ####
Modified: hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input_testsequencefile.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input_testsequencefile.q.out?rev=1451954&r1=1451953&r2=1451954&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input_testsequencefile.q.out (original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientpositive/input_testsequencefile.q.out Sat Mar 2 22:37:59 2013
@@ -33,26 +33,19 @@ STAGE PLANS:
alias: src
Select Operator
expressions:
- expr: key
- type: string
+ expr: UDFToInteger(key)
+ type: int
expr: value
type: string
outputColumnNames: _col0, _col1
- Select Operator
- expressions:
- expr: UDFToInteger(_col0)
- type: int
- expr: _col1
- type: string
- outputColumnNames: _col0, _col1
- File Output Operator
- compressed: false
- GlobalTableId: 1
- table:
- input format: org.apache.hadoop.mapred.SequenceFileInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.dest4_sequencefile
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ table:
+ input format: org.apache.hadoop.mapred.SequenceFileInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: default.dest4_sequencefile
Stage: Stage-7
Conditional Operator
Modified: hive/branches/ptf-windowing/ql/src/test/results/clientpositive/join1.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientpositive/join1.q.out?rev=1451954&r1=1451953&r2=1451954&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientpositive/join1.q.out (original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientpositive/join1.q.out Sat Mar 2 22:37:59 2013
@@ -64,26 +64,19 @@ STAGE PLANS:
outputColumnNames: _col0, _col5
Select Operator
expressions:
- expr: _col0
- type: string
+ expr: UDFToInteger(_col0)
+ type: int
expr: _col5
type: string
outputColumnNames: _col0, _col1
- Select Operator
- expressions:
- expr: UDFToInteger(_col0)
- type: int
- expr: _col1
- type: string
- outputColumnNames: _col0, _col1
- File Output Operator
- compressed: false
- GlobalTableId: 1
- 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
- name: default.dest_j1
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ 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
+ name: default.dest_j1
Stage: Stage-0
Move Operator
Modified: hive/branches/ptf-windowing/ql/src/test/results/clientpositive/join12.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientpositive/join12.q.out?rev=1451954&r1=1451953&r2=1451954&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientpositive/join12.q.out (original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientpositive/join12.q.out Sat Mar 2 22:37:59 2013
@@ -36,7 +36,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: ((key < 100.0) and (key < 80.0))
+ expr: ((key < 80.0) and (key < 100.0))
type: boolean
Select Operator
expressions:
@@ -86,7 +86,7 @@ STAGE PLANS:
alias: src
Filter Operator
predicate:
- expr: ((key < 80.0) and (key < 100.0))
+ expr: ((key < 100.0) and (key < 80.0))
type: boolean
Select Operator
expressions:
Modified: hive/branches/ptf-windowing/ql/src/test/results/clientpositive/join14_hadoop20.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientpositive/join14_hadoop20.q.out?rev=1451954&r1=1451953&r2=1451954&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientpositive/join14_hadoop20.q.out (original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientpositive/join14_hadoop20.q.out Sat Mar 2 22:37:59 2013
@@ -76,26 +76,19 @@ STAGE PLANS:
outputColumnNames: _col0, _col5
Select Operator
expressions:
- expr: _col0
- type: string
+ expr: UDFToInteger(_col0)
+ type: int
expr: _col5
type: string
outputColumnNames: _col0, _col1
- Select Operator
- expressions:
- expr: UDFToInteger(_col0)
- type: int
- expr: _col1
- type: string
- outputColumnNames: _col0, _col1
- File Output Operator
- compressed: false
- GlobalTableId: 1
- 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
- name: default.dest1
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ 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
+ name: default.dest1
Stage: Stage-0
Move Operator
Modified: hive/branches/ptf-windowing/ql/src/test/results/clientpositive/join17.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientpositive/join17.q.out?rev=1451954&r1=1451953&r2=1451954&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientpositive/join17.q.out (original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientpositive/join17.q.out Sat Mar 2 22:37:59 2013
@@ -116,50 +116,39 @@ STAGE PLANS:
outputColumnNames: _col0, _col1, _col4, _col5
Select Operator
expressions:
- expr: _col0
- type: string
+ expr: UDFToInteger(_col0)
+ type: int
expr: _col1
type: string
- expr: _col4
- type: string
+ expr: UDFToInteger(_col4)
+ type: int
expr: _col5
type: string
outputColumnNames: _col0, _col1, _col2, _col3
- Select Operator
- expressions:
- expr: UDFToInteger(_col0)
- type: int
- expr: _col1
- type: string
- expr: UDFToInteger(_col2)
- type: int
- expr: _col3
- type: string
- outputColumnNames: _col0, _col1, _col2, _col3
- File Output Operator
- compressed: false
- GlobalTableId: 1
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
#### A masked pattern was here ####
- NumFilesPerFileSink: 1
+ NumFilesPerFileSink: 1
#### A masked pattern was here ####
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- properties:
- bucket_count -1
- columns key1,value1,key2,value2
- columns.types int:string:int:string
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ bucket_count -1
+ columns key1,value1,key2,value2
+ columns.types int:string:int:string
#### A masked pattern was here ####
- name default.dest1
- serialization.ddl struct dest1 { i32 key1, string value1, i32 key2, string value2}
- serialization.format 1
- serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name default.dest1
+ serialization.ddl struct dest1 { i32 key1, string value1, i32 key2, string value2}
+ serialization.format 1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
#### A masked pattern was here ####
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: default.dest1
- TotalFiles: 1
- GatherStats: true
- MultiFileSpray: false
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: default.dest1
+ TotalFiles: 1
+ GatherStats: true
+ MultiFileSpray: false
Truncated Path -> Alias:
/src [src2, src1]
Modified: hive/branches/ptf-windowing/ql/src/test/results/clientpositive/join2.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientpositive/join2.q.out?rev=1451954&r1=1451953&r2=1451954&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientpositive/join2.q.out (original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientpositive/join2.q.out Sat Mar 2 22:37:59 2013
@@ -112,26 +112,19 @@ STAGE PLANS:
outputColumnNames: _col4, _col9
Select Operator
expressions:
- expr: _col4
- type: string
+ expr: UDFToInteger(_col4)
+ type: int
expr: _col9
type: string
outputColumnNames: _col0, _col1
- Select Operator
- expressions:
- expr: UDFToInteger(_col0)
- type: int
- expr: _col1
- type: string
- outputColumnNames: _col0, _col1
- File Output Operator
- compressed: false
- GlobalTableId: 1
- 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
- name: default.dest_j2
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ 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
+ name: default.dest_j2
Stage: Stage-0
Move Operator
Modified: hive/branches/ptf-windowing/ql/src/test/results/clientpositive/join20.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientpositive/join20.q.out?rev=1451954&r1=1451953&r2=1451954&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientpositive/join20.q.out (original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientpositive/join20.q.out Sat Mar 2 22:37:59 2013
@@ -744,7 +744,7 @@ STAGE PLANS:
alias: src1
Filter Operator
predicate:
- expr: ((key < 10.0) and (key < 15.0))
+ expr: ((key < 15.0) and (key < 10.0))
type: boolean
Reduce Output Operator
key expressions:
@@ -765,7 +765,7 @@ STAGE PLANS:
alias: src2
Filter Operator
predicate:
- expr: ((key < 15.0) and (key < 10.0))
+ expr: ((key < 10.0) and (key < 15.0))
type: boolean
Reduce Output Operator
key expressions:
Modified: hive/branches/ptf-windowing/ql/src/test/results/clientpositive/join22.q.out
URL: http://svn.apache.org/viewvc/hive/branches/ptf-windowing/ql/src/test/results/clientpositive/join22.q.out?rev=1451954&r1=1451953&r2=1451954&view=diff
==============================================================================
--- hive/branches/ptf-windowing/ql/src/test/results/clientpositive/join22.q.out (original)
+++ hive/branches/ptf-windowing/ql/src/test/results/clientpositive/join22.q.out Sat Mar 2 22:37:59 2013
@@ -109,18 +109,13 @@ STAGE PLANS:
expressions:
expr: _col7
type: string
- outputColumnNames: _col3
- Select Operator
- expressions:
- expr: _col3
- type: string
- outputColumnNames: _col0
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ outputColumnNames: _col0
+ File Output Operator
+ compressed: false
+ GlobalTableId: 0
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
Stage: Stage-0
Fetch Operator