You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by zs...@apache.org on 2009/06/24 06:05:05 UTC
svn commit: r787898 [4/19] - in /hadoop/hive/trunk: ./ conf/
ql/src/java/org/apache/hadoop/hive/ql/ppd/
ql/src/test/results/clientpositive/ ql/src/test/results/compiler/plan/
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join7.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join7.q.out?rev=787898&r1=787897&r2=787898&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join7.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join7.q.out Wed Jun 24 04:05:02 2009
@@ -34,76 +34,88 @@
predicate:
expr: ((UDFToDouble(key) > UDFToDouble(10)) and (UDFToDouble(key) < UDFToDouble(20)))
type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- expr: value
- type: string
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: _col0
- type: string
- tag: 0
- value expressions:
- expr: _col0
- type: string
- expr: _col1
- type: string
+ Filter Operator
+ predicate:
+ expr: ((UDFToDouble(key) > UDFToDouble(10)) and (UDFToDouble(key) < UDFToDouble(20)))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ tag: 0
+ value expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
c:b:src2
Filter Operator
predicate:
expr: ((UDFToDouble(key) > UDFToDouble(15)) and (UDFToDouble(key) < UDFToDouble(25)))
type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- expr: value
- type: string
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: _col0
- type: string
- tag: 1
- value expressions:
- expr: _col0
- type: string
- expr: _col1
- type: string
+ Filter Operator
+ predicate:
+ expr: ((UDFToDouble(key) > UDFToDouble(15)) and (UDFToDouble(key) < UDFToDouble(25)))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ tag: 1
+ value expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
c:c:src3
Filter Operator
predicate:
expr: ((UDFToDouble(key) > UDFToDouble(20)) and (UDFToDouble(key) < UDFToDouble(25)))
type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- expr: value
- type: string
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: _col0
- type: string
- tag: 2
- value expressions:
- expr: _col0
- type: string
- expr: _col1
- type: string
+ Filter Operator
+ predicate:
+ expr: ((UDFToDouble(key) > UDFToDouble(20)) and (UDFToDouble(key) < UDFToDouble(25)))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ tag: 2
+ value expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
Reduce Operator Tree:
Join Operator
condition map:
@@ -197,7 +209,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/220580216/10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/2080427053/10000
11 val_11 NULL NULL NULL NULL
12 val_12 NULL NULL NULL NULL
12 val_12 NULL NULL NULL NULL
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join8.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join8.q.out?rev=787898&r1=787897&r2=787898&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join8.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join8.q.out Wed Jun 24 04:05:02 2009
@@ -29,51 +29,59 @@
predicate:
expr: ((UDFToDouble(key) > UDFToDouble(10)) and (UDFToDouble(key) < UDFToDouble(20)))
type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- expr: value
- type: string
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: _col0
- type: string
- tag: 0
- value expressions:
- expr: _col0
+ Filter Operator
+ predicate:
+ expr: ((UDFToDouble(key) > UDFToDouble(10)) and (UDFToDouble(key) < UDFToDouble(20)))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: key
type: string
- expr: _col1
+ expr: value
type: string
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ tag: 0
+ value expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
c:b:src2
Filter Operator
predicate:
expr: ((UDFToDouble(key) > UDFToDouble(15)) and (UDFToDouble(key) < UDFToDouble(25)))
type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- expr: value
- type: string
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: _col0
- type: string
- tag: 1
- value expressions:
- expr: _col0
+ Filter Operator
+ predicate:
+ expr: ((UDFToDouble(key) > UDFToDouble(15)) and (UDFToDouble(key) < UDFToDouble(25)))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: key
type: string
- expr: _col1
+ expr: value
type: string
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: _col0
+ type: string
+ tag: 1
+ value expressions:
+ expr: _col0
+ type: string
+ expr: _col1
+ type: string
Reduce Operator Tree:
Join Operator
condition map:
@@ -152,7 +160,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1351311232/10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1672797204/10000
11 val_11 NULL NULL
12 val_12 NULL NULL
12 val_12 NULL NULL
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/join9.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/join9.q.out?rev=787898&r1=787897&r2=787898&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/join9.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/join9.q.out Wed Jun 24 04:05:02 2009
@@ -29,30 +29,34 @@
expr: value
type: string
src1
- Reduce Output Operator
- key expressions:
- expr: key
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: key
- type: string
- tag: 0
- value expressions:
- expr: key
- type: string
- expr: value
- type: string
- expr: ds
- type: string
- expr: hr
- type: string
+ Filter Operator
+ predicate:
+ expr: ((ds = '2008-04-08') and (hr = '12'))
+ type: boolean
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: key
+ type: string
+ tag: 0
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ expr: ds
+ type: string
+ expr: hr
+ type: string
Needs Tagging: true
Path -> Alias:
- file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/src
- file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/src
+ file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Path -> Partition:
- file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/src
+ file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/src
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -67,10 +71,10 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/src
+ location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/src
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: src
- file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Partition
partition values:
ds 2008-04-08
@@ -89,7 +93,7 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
Reduce Operator Tree:
@@ -118,7 +122,7 @@
File Output Operator
compressed: false
GlobalTableId: 1
- directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/2045025830/10000
+ directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1604556353/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -132,7 +136,7 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/dest1
+ location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
@@ -140,7 +144,7 @@
Move Operator
tables:
replace: true
- source: file:/data/users/njain/hive4/hive4/build/ql/tmp/2045025830/10000
+ source: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1604556353/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -154,10 +158,10 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/dest1
+ location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
- tmp directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/2045025830/10001
+ tmp directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1604556353/10001
query: FROM srcpart src1 JOIN src src2 ON (src1.key = src2.key)
@@ -167,7 +171,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/253334300/10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/794663470/10000
0 val_0
0 val_0
0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/no_hooks.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/no_hooks.q.out?rev=787898&r1=787897&r2=787898&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/no_hooks.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/no_hooks.q.out Wed Jun 24 04:05:02 2009
@@ -11,23 +11,31 @@
Map Reduce
Alias -> Map Operator Tree:
src2
- Reduce Output Operator
- sort order:
- tag: 1
- value expressions:
- expr: key
- type: string
- expr: value
- type: string
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) < UDFToDouble(10))
+ type: boolean
+ Reduce Output Operator
+ sort order:
+ tag: 1
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
src1
- Reduce Output Operator
- sort order:
- tag: 0
- value expressions:
- expr: key
- type: string
- expr: value
- type: string
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) < UDFToDouble(10))
+ type: boolean
+ Reduce Output Operator
+ sort order:
+ tag: 0
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
Reduce Operator Tree:
Join Operator
condition map:
@@ -60,7 +68,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1772065220/10002
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/926752707/10002
Reduce Output Operator
key expressions:
expr: _col0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/noalias_subq1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/noalias_subq1.q.out?rev=787898&r1=787897&r2=787898&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/noalias_subq1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/noalias_subq1.q.out Wed Jun 24 04:05:02 2009
@@ -12,26 +12,30 @@
Map Reduce
Alias -> Map Operator Tree:
x:src
- Select Operator
- expressions:
- expr: value
- type: string
- expr: key
- type: string
- Filter Operator
- predicate:
- expr: (UDFToDouble(_col1) < UDFToDouble(100))
- type: boolean
- Select Operator
- expressions:
- expr: _col0
- type: string
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) < UDFToDouble(100))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: value
+ type: string
+ expr: key
+ type: string
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(_col1) < UDFToDouble(100))
+ type: boolean
+ Select Operator
+ expressions:
+ expr: _col0
+ type: string
+ 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
@@ -40,7 +44,7 @@
query: SELECT c1 FROM (select value as c1, key as c2 from src) x where c2 < 100
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1484515504/10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1322275245/10000
val_86
val_27
val_98
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias1.q.out?rev=787898&r1=787897&r2=787898&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias1.q.out Wed Jun 24 04:05:02 2009
@@ -18,29 +18,33 @@
predicate:
expr: (UDFToDouble(key) < UDFToDouble(100))
type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- Group By Operator
- aggregations:
- expr: count(1)
- keys:
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) < UDFToDouble(100))
+ type: boolean
+ Select Operator
+ expressions:
expr: key
type: string
- mode: hash
- Reduce Output Operator
- key expressions:
- expr: _col0
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ keys:
+ expr: key
type: string
- sort order: +
- Map-reduce partition columns:
- expr: _col0
- type: string
- tag: -1
- value expressions:
- expr: _col1
- type: bigint
+ mode: hash
+ 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
Reduce Operator Tree:
Group By Operator
aggregations:
@@ -91,7 +95,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1874640355/10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/839206894/10000
1234 0 3.0
1234 10 1.0
1234 11 1.0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias2.q.out?rev=787898&r1=787897&r2=787898&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/notable_alias2.q.out Wed Jun 24 04:05:02 2009
@@ -18,29 +18,33 @@
predicate:
expr: (UDFToDouble(key) < UDFToDouble(100))
type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- Group By Operator
- aggregations:
- expr: count(1)
- keys:
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) < UDFToDouble(100))
+ type: boolean
+ Select Operator
+ expressions:
expr: key
type: string
- mode: hash
- Reduce Output Operator
- key expressions:
- expr: _col0
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ keys:
+ expr: key
type: string
- sort order: +
- Map-reduce partition columns:
- expr: _col0
- type: string
- tag: -1
- value expressions:
- expr: _col1
- type: bigint
+ mode: hash
+ 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
Reduce Operator Tree:
Group By Operator
aggregations:
@@ -91,7 +95,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1499013571/10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1248005657/10000
1234 0 3.0
1234 10 1.0
1234 11 1.0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup.q.out?rev=787898&r1=787897&r2=787898&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup.q.out Wed Jun 24 04:05:02 2009
@@ -16,17 +16,21 @@
predicate:
expr: (UDFToDouble(key) > UDFToDouble(9999))
type: boolean
- Select Operator
- Group By Operator
- aggregations:
- expr: count(1)
- mode: hash
- Reduce Output Operator
- sort order:
- tag: -1
- value expressions:
- expr: _col0
- type: bigint
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) > UDFToDouble(9999))
+ type: boolean
+ Select Operator
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ mode: hash
+ Reduce Output Operator
+ sort order:
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: bigint
Reduce Operator Tree:
Group By Operator
aggregations:
@@ -50,7 +54,7 @@
query: select count(1) from src x where x.key > 9999
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/147597218/10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/956604429/10000
0
query: explain
select count(1) from src x where x.key > 9999
@@ -70,17 +74,21 @@
predicate:
expr: (UDFToDouble(key) > UDFToDouble(9999))
type: boolean
- Select Operator
- Group By Operator
- aggregations:
- expr: count(1)
- mode: hash
- Reduce Output Operator
- sort order:
- tag: -1
- value expressions:
- expr: _col0
- type: bigint
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) > UDFToDouble(9999))
+ type: boolean
+ Select Operator
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ mode: hash
+ Reduce Output Operator
+ sort order:
+ tag: -1
+ value expressions:
+ expr: _col0
+ type: bigint
Reduce Operator Tree:
Group By Operator
aggregations:
@@ -104,7 +112,7 @@
query: select count(1) from src x where x.key > 9999
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/533131483/10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/354015080/10000
0
query: explain
select count(1) from src x where x.key > 9999
@@ -125,13 +133,17 @@
predicate:
expr: (UDFToDouble(key) > UDFToDouble(9999))
type: boolean
- Select Operator
- Reduce Output Operator
- sort order:
- Map-reduce partition columns:
- expr: rand()
- type: double
- tag: -1
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) > UDFToDouble(9999))
+ type: boolean
+ Select Operator
+ Reduce Output Operator
+ sort order:
+ Map-reduce partition columns:
+ expr: rand()
+ type: double
+ tag: -1
Reduce Operator Tree:
Group By Operator
aggregations:
@@ -148,7 +160,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1010806267/10002
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/200770525/10002
Reduce Output Operator
sort order:
tag: -1
@@ -178,7 +190,7 @@
query: select count(1) from src x where x.key > 9999
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1089737871/10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1979407901/10000
0
query: explain
select count(1) from src x where x.key > 9999
@@ -198,10 +210,14 @@
predicate:
expr: (UDFToDouble(key) > UDFToDouble(9999))
type: boolean
- Select Operator
- Reduce Output Operator
- sort order:
- tag: -1
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) > UDFToDouble(9999))
+ type: boolean
+ Select Operator
+ Reduce Output Operator
+ sort order:
+ tag: -1
Reduce Operator Tree:
Group By Operator
aggregations:
@@ -225,5 +241,5 @@
query: select count(1) from src x where x.key > 9999
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1646500951/10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/126794078/10000
0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup2.q.out?rev=787898&r1=787897&r2=787898&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup2.q.out Wed Jun 24 04:05:02 2009
@@ -17,29 +17,33 @@
predicate:
expr: (UDFToDouble(key) > UDFToDouble(9999))
type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- Group By Operator
- aggregations:
- expr: count(1)
- keys:
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) > UDFToDouble(9999))
+ type: boolean
+ Select Operator
+ expressions:
expr: key
type: string
- mode: hash
- Reduce Output Operator
- key expressions:
- expr: _col0
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ keys:
+ expr: key
type: string
- sort order: +
- Map-reduce partition columns:
- expr: rand()
- type: double
- tag: -1
- value expressions:
- expr: _col1
- type: bigint
+ mode: hash
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: rand()
+ type: double
+ tag: -1
+ value expressions:
+ expr: _col1
+ type: bigint
Reduce Operator Tree:
Group By Operator
aggregations:
@@ -59,7 +63,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/903786028/10002
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1813446506/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -100,7 +104,7 @@
query: select x.key, count(1) from src x where x.key > 9999 group by x.key
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1972021465/10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1274223349/10000
query: explain
select x.key, count(1) from src x where x.key > 9999 group by x.key
ABSTRACT SYNTAX TREE:
@@ -119,29 +123,33 @@
predicate:
expr: (UDFToDouble(key) > UDFToDouble(9999))
type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- Group By Operator
- aggregations:
- expr: count(1)
- keys:
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) > UDFToDouble(9999))
+ type: boolean
+ Select Operator
+ expressions:
expr: key
type: string
- mode: hash
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: _col0
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ keys:
+ expr: key
type: string
- tag: -1
- value expressions:
- expr: _col1
- type: bigint
+ mode: hash
+ 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
Reduce Operator Tree:
Group By Operator
aggregations:
@@ -170,7 +178,7 @@
query: select x.key, count(1) from src x where x.key > 9999 group by x.key
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/2003513478/10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/2031150875/10000
query: explain
select x.key, count(1) from src x where x.key > 9999 group by x.key
ABSTRACT SYNTAX TREE:
@@ -190,19 +198,23 @@
predicate:
expr: (UDFToDouble(key) > UDFToDouble(9999))
type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- Reduce Output Operator
- key expressions:
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) > UDFToDouble(9999))
+ type: boolean
+ Select Operator
+ expressions:
expr: key
type: string
- sort order: +
- Map-reduce partition columns:
- expr: rand()
- type: double
- tag: -1
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: rand()
+ type: double
+ tag: -1
Reduce Operator Tree:
Group By Operator
aggregations:
@@ -222,7 +234,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/955037671/10002
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1094899532/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -263,7 +275,7 @@
query: select x.key, count(1) from src x where x.key > 9999 group by x.key
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1033844732/10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/2019724226/10000
query: explain
select x.key, count(1) from src x where x.key > 9999 group by x.key
ABSTRACT SYNTAX TREE:
@@ -282,19 +294,23 @@
predicate:
expr: (UDFToDouble(key) > UDFToDouble(9999))
type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- Reduce Output Operator
- key expressions:
- expr: key
- type: string
- sort order: +
- Map-reduce partition columns:
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) > UDFToDouble(9999))
+ type: boolean
+ Select Operator
+ expressions:
expr: key
type: string
- tag: -1
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: key
+ type: string
+ tag: -1
Reduce Operator Tree:
Group By Operator
aggregations:
@@ -323,4 +339,4 @@
query: select x.key, count(1) from src x where x.key > 9999 group by x.key
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1589261457/10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/629412428/10000
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup4.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup4.q.out?rev=787898&r1=787897&r2=787898&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup4.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/nullgroup4.q.out Wed Jun 24 04:05:02 2009
@@ -17,32 +17,36 @@
predicate:
expr: (UDFToDouble(key) = UDFToDouble(9999))
type: boolean
- Select Operator
- expressions:
- expr: value
- type: string
- Group By Operator
- aggregations:
- expr: count(1)
- expr: count(DISTINCT value)
- keys:
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) = UDFToDouble(9999))
+ type: boolean
+ Select Operator
+ expressions:
expr: value
type: string
- mode: hash
- Reduce Output Operator
- key expressions:
- expr: _col0
- type: string
- sort order: +
- Map-reduce partition columns:
- expr: _col0
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ expr: count(DISTINCT value)
+ keys:
+ expr: value
type: string
- tag: -1
- value expressions:
- expr: _col1
- type: bigint
- expr: _col2
- type: bigint
+ mode: hash
+ 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
+ expr: _col2
+ type: bigint
Reduce Operator Tree:
Group By Operator
aggregations:
@@ -60,7 +64,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1897268457/10002
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/797179428/10002
Reduce Output Operator
sort order:
tag: -1
@@ -95,7 +99,7 @@
query: select count(1), count(distinct x.value) from src x where x.key = 9999
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1722609002/10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/176192106/10000
0 0
query: explain
select count(1), count(distinct x.value) from src x where x.key = 9999
@@ -115,29 +119,33 @@
predicate:
expr: (UDFToDouble(key) = UDFToDouble(9999))
type: boolean
- Select Operator
- expressions:
- expr: value
- type: string
- Group By Operator
- aggregations:
- expr: count(1)
- expr: count(DISTINCT value)
- keys:
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) = UDFToDouble(9999))
+ type: boolean
+ Select Operator
+ expressions:
expr: value
type: string
- mode: hash
- Reduce Output Operator
- key expressions:
- expr: _col0
+ Group By Operator
+ aggregations:
+ expr: count(1)
+ expr: count(DISTINCT value)
+ keys:
+ expr: value
type: string
- sort order: +
- tag: -1
- value expressions:
- expr: _col1
- type: bigint
- expr: _col2
- type: bigint
+ mode: hash
+ Reduce Output Operator
+ key expressions:
+ expr: _col0
+ type: string
+ sort order: +
+ tag: -1
+ value expressions:
+ expr: _col1
+ type: bigint
+ expr: _col2
+ type: bigint
Reduce Operator Tree:
Group By Operator
aggregations:
@@ -164,7 +172,7 @@
query: select count(1), count(distinct x.value) from src x where x.key = 9999
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/767488780/10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1240165665/10000
0 0
query: explain
select count(1), count(distinct x.value) from src x where x.key = 9999
@@ -185,19 +193,23 @@
predicate:
expr: (UDFToDouble(key) = UDFToDouble(9999))
type: boolean
- Select Operator
- expressions:
- expr: value
- type: string
- Reduce Output Operator
- key expressions:
- expr: value
- type: string
- sort order: +
- Map-reduce partition columns:
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) = UDFToDouble(9999))
+ type: boolean
+ Select Operator
+ expressions:
expr: value
type: string
- tag: -1
+ Reduce Output Operator
+ key expressions:
+ expr: value
+ type: string
+ sort order: +
+ Map-reduce partition columns:
+ expr: value
+ type: string
+ tag: -1
Reduce Operator Tree:
Group By Operator
aggregations:
@@ -215,7 +227,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/366816975/10002
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/123668648/10002
Reduce Output Operator
sort order:
tag: -1
@@ -250,7 +262,7 @@
query: select count(1), count(distinct x.value) from src x where x.key = 9999
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/449391495/10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/2060544994/10000
0 0
query: explain
select count(1), count(distinct x.value) from src x where x.key = 9999
@@ -270,16 +282,20 @@
predicate:
expr: (UDFToDouble(key) = UDFToDouble(9999))
type: boolean
- Select Operator
- expressions:
- expr: value
- type: string
- Reduce Output Operator
- key expressions:
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) = UDFToDouble(9999))
+ type: boolean
+ Select Operator
+ expressions:
expr: value
type: string
- sort order: +
- tag: -1
+ Reduce Output Operator
+ key expressions:
+ expr: value
+ type: string
+ sort order: +
+ tag: -1
Reduce Operator Tree:
Group By Operator
aggregations:
@@ -306,5 +322,5 @@
query: select count(1), count(distinct x.value) from src x where x.key = 9999
Input: default/src
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1178763568/10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/131032386/10000
0 0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/quote1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/quote1.q.out?rev=787898&r1=787897&r2=787898&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/quote1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/quote1.q.out Wed Jun 24 04:05:02 2009
@@ -19,26 +19,30 @@
predicate:
expr: ((UDFToDouble(key) >= UDFToDouble(200)) and (UDFToDouble(key) < UDFToDouble(300)))
type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- expr: value
- type: string
+ Filter Operator
+ predicate:
+ expr: ((UDFToDouble(key) >= UDFToDouble(200)) and (UDFToDouble(key) < UDFToDouble(300)))
+ type: boolean
Select Operator
expressions:
- expr: UDFToInteger(_col0)
- type: int
- expr: _col1
+ expr: key
type: string
- 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: dest1
+ expr: value
+ type: string
+ Select Operator
+ expressions:
+ expr: UDFToInteger(_col0)
+ type: int
+ expr: _col1
+ type: string
+ 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: dest1
Stage: Stage-4
Conditional Operator
@@ -46,10 +50,10 @@
Move Operator
files:
hdfs directory: true
- destination: file:/data/users/njain/hive4/hive4/build/ql/tmp/427744862/10000
+ destination: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/657063000/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1826844590/10002
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/547720568/10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -103,20 +107,24 @@
predicate:
expr: (table = '2008-04-08')
type: boolean
- Select Operator
- expressions:
- expr: location
- type: int
- expr: type
- type: string
- expr: table
- type: string
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ Filter Operator
+ predicate:
+ expr: (table = '2008-04-08')
+ type: boolean
+ Select Operator
+ expressions:
+ expr: location
+ type: int
+ expr: type
+ type: string
+ expr: table
+ type: string
+ 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
@@ -129,7 +137,7 @@
Output: default/dest1/table=2008-04-08
query: SELECT `int`.`location`, `int`.`type`, `int`.`table` FROM dest1 `int` WHERE `int`.`table` = '2008-04-08'
Input: default/dest1/table=2008-04-08
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/1598405104/10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1782208476/10000
238 val_238 2008-04-08
255 val_255 2008-04-08
278 val_278 2008-04-08
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/regex_col.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/regex_col.q.out?rev=787898&r1=787897&r2=787898&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/regex_col.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/regex_col.q.out Wed Jun 24 04:05:02 2009
@@ -213,32 +213,36 @@
predicate:
expr: (UDFToDouble(key) = UDFToDouble(103))
type: boolean
- Reduce Output Operator
- key expressions:
- expr: key
- type: string
- expr: hr
- type: string
- expr: ds
- type: string
- sort order: +++
- Map-reduce partition columns:
- expr: key
- type: string
- expr: hr
- type: string
- expr: ds
- type: string
- tag: 0
- value expressions:
- expr: key
- type: string
- expr: value
- type: string
- expr: ds
- type: string
- expr: hr
- type: string
+ Filter Operator
+ predicate:
+ expr: (UDFToDouble(key) = UDFToDouble(103))
+ type: boolean
+ Reduce Output Operator
+ key expressions:
+ expr: key
+ type: string
+ expr: hr
+ type: string
+ expr: ds
+ type: string
+ sort order: +++
+ Map-reduce partition columns:
+ expr: key
+ type: string
+ expr: hr
+ type: string
+ expr: ds
+ type: string
+ tag: 0
+ value expressions:
+ expr: key
+ type: string
+ expr: value
+ type: string
+ expr: ds
+ type: string
+ expr: hr
+ type: string
Reduce Operator Tree:
Join Operator
condition map:
@@ -263,7 +267,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/633491426/10002
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/805719823/10002
Reduce Output Operator
key expressions:
expr: _col0
@@ -298,7 +302,7 @@
Input: default/srcpart/ds=2008-04-08/hr=12
Input: default/srcpart/ds=2008-04-09/hr=11
Input: default/srcpart/ds=2008-04-09/hr=12
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/277502116/10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1129854195/10000
2008-04-08 11
2008-04-08 11
2008-04-08 11
@@ -462,7 +466,7 @@
Input: default/srcpart/ds=2008-04-08/hr=12
Input: default/srcpart/ds=2008-04-09/hr=11
Input: default/srcpart/ds=2008-04-09/hr=12
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/1512364739/10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1035513263/10000
0 val_0
0 val_0
0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/sample3.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/sample3.q.out?rev=787898&r1=787897&r2=787898&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/sample3.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/sample3.q.out Wed Jun 24 04:05:02 2009
@@ -18,16 +18,20 @@
predicate:
expr: (((hash(key) & 2147483647) % 5) = 0)
type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- File Output Operator
- compressed: false
- GlobalTableId: 0
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ Filter Operator
+ predicate:
+ expr: (((hash(key) & 2147483647) % 5) = 0)
+ type: boolean
+ Select Operator
+ expressions:
+ expr: key
+ type: string
+ 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
@@ -37,7 +41,7 @@
query: SELECT s.key
FROM srcbucket TABLESAMPLE (BUCKET 1 OUT OF 5 on key) s SORT BY key
Input: default/srcbucket
-Output: file:/Users/char/Documents/workspace/Hive-460/build/ql/tmp/341548043/10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/2122674370/10000
100
100
100
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/sample5.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/sample5.q.out?rev=787898&r1=787897&r2=787898&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/sample5.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/sample5.q.out Wed Jun 24 04:05:02 2009
@@ -20,43 +20,47 @@
predicate:
expr: (((hash(key) & 2147483647) % 5) = 0)
type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- expr: value
- type: string
+ Filter Operator
+ predicate:
+ expr: (((hash(key) & 2147483647) % 5) = 0)
+ type: boolean
Select Operator
expressions:
- expr: UDFToInteger(_col0)
- type: int
- expr: _col1
+ expr: key
type: string
- File Output Operator
- compressed: false
- GlobalTableId: 1
- directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/1132718480/10002
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- properties:
- name dest1
- columns.types int:string
- serialization.ddl struct dest1 { i32 key, string value}
- serialization.format 1
- columns key,value
- bucket_count -1
- serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/dest1
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: dest1
+ expr: value
+ type: string
+ Select Operator
+ expressions:
+ expr: UDFToInteger(_col0)
+ type: int
+ expr: _col1
+ type: string
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/15105901/10002
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name dest1
+ columns.types int:string
+ serialization.ddl struct dest1 { i32 key, string value}
+ serialization.format 1
+ columns key,value
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest1
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: dest1
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/srcbucket
+ file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcbucket
Path -> Partition:
- file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/srcbucket
+ file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcbucket
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -72,7 +76,7 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/srcbucket
+ location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcbucket
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcbucket
@@ -82,11 +86,11 @@
Move Operator
files:
hdfs directory: true
- source: file:/data/users/njain/hive4/hive4/build/ql/tmp/1132718480/10002
- destination: file:/data/users/njain/hive4/hive4/build/ql/tmp/2080961285/10000
+ source: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/15105901/10002
+ destination: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/331098123/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1132718480/10002
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/15105901/10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -100,9 +104,9 @@
type: string
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1132718480/10002
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/15105901/10002
Path -> Partition:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1132718480/10002
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/15105901/10002
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -117,7 +121,7 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/dest1
+ location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
Reduce Operator Tree:
@@ -125,7 +129,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/2080961285/10000
+ directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/331098123/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -139,7 +143,7 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/dest1
+ location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
@@ -147,7 +151,7 @@
Move Operator
tables:
replace: true
- source: file:/data/users/njain/hive4/hive4/build/ql/tmp/2080961285/10000
+ source: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/331098123/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -161,10 +165,10 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/dest1
+ location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
- tmp directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/2080961285/10001
+ tmp directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/331098123/10001
query: INSERT OVERWRITE TABLE dest1 SELECT s.* -- here's another test
@@ -173,7 +177,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1 SORT BY key, value
Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/13389851/10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/685198063/10000
2 val_2
2 val_3
18 val_18
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/sample6.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/sample6.q.out?rev=787898&r1=787897&r2=787898&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/sample6.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/sample6.q.out Wed Jun 24 04:05:02 2009
@@ -20,43 +20,47 @@
predicate:
expr: (((hash(key) & 2147483647) % 4) = 0)
type: boolean
- Select Operator
- expressions:
- expr: key
- type: string
- expr: value
- type: string
+ Filter Operator
+ predicate:
+ expr: (((hash(key) & 2147483647) % 4) = 0)
+ type: boolean
Select Operator
expressions:
- expr: UDFToInteger(_col0)
- type: int
- expr: _col1
+ expr: key
type: string
- File Output Operator
- compressed: false
- GlobalTableId: 1
- directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/1050927778/10002
- table:
- input format: org.apache.hadoop.mapred.TextInputFormat
- output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- properties:
- name dest1
- columns.types int:string
- serialization.ddl struct dest1 { i32 key, string value}
- serialization.format 1
- columns key,value
- bucket_count -1
- serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- file.inputformat org.apache.hadoop.mapred.TextInputFormat
- file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/dest1
- serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
- name: dest1
+ expr: value
+ type: string
+ Select Operator
+ expressions:
+ expr: UDFToInteger(_col0)
+ type: int
+ expr: _col1
+ type: string
+ File Output Operator
+ compressed: false
+ GlobalTableId: 1
+ directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/557388751/10002
+ table:
+ input format: org.apache.hadoop.mapred.TextInputFormat
+ output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ properties:
+ name dest1
+ columns.types int:string
+ serialization.ddl struct dest1 { i32 key, string value}
+ serialization.format 1
+ columns key,value
+ bucket_count -1
+ serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ file.inputformat org.apache.hadoop.mapred.TextInputFormat
+ file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
+ location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest1
+ serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
+ name: dest1
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/srcbucket/kv1.txt
+ file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcbucket/kv1.txt
Path -> Partition:
- file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/srcbucket/kv1.txt
+ file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcbucket/kv1.txt
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -72,7 +76,7 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/srcbucket
+ location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/srcbucket
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcbucket
@@ -82,11 +86,11 @@
Move Operator
files:
hdfs directory: true
- source: file:/data/users/njain/hive4/hive4/build/ql/tmp/1050927778/10002
- destination: file:/data/users/njain/hive4/hive4/build/ql/tmp/1002911544/10000
+ source: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/557388751/10002
+ destination: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1329298090/10000
Map Reduce
Alias -> Map Operator Tree:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1050927778/10002
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/557388751/10002
Reduce Output Operator
sort order:
Map-reduce partition columns:
@@ -100,9 +104,9 @@
type: string
Needs Tagging: false
Path -> Alias:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1050927778/10002
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/557388751/10002
Path -> Partition:
- file:/data/users/njain/hive4/hive4/build/ql/tmp/1050927778/10002
+ file:/data/users/pchakka/workspace/oshive/build/ql/tmp/557388751/10002
Partition
input format: org.apache.hadoop.mapred.TextInputFormat
@@ -117,7 +121,7 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/dest1
+ location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
Reduce Operator Tree:
@@ -125,7 +129,7 @@
File Output Operator
compressed: false
GlobalTableId: 0
- directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/1002911544/10000
+ directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1329298090/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -139,7 +143,7 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/dest1
+ location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
@@ -147,7 +151,7 @@
Move Operator
tables:
replace: true
- source: file:/data/users/njain/hive4/hive4/build/ql/tmp/1002911544/10000
+ source: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1329298090/10000
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -161,10 +165,10 @@
serialization.lib org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
file.inputformat org.apache.hadoop.mapred.TextInputFormat
file.outputformat org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
- location file:/data/users/njain/hive4/hive4/build/ql/test/data/warehouse/dest1
+ location file:/data/users/pchakka/workspace/oshive/build/ql/test/data/warehouse/dest1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
- tmp directory: file:/data/users/njain/hive4/hive4/build/ql/tmp/1002911544/10001
+ tmp directory: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/1329298090/10001
query: INSERT OVERWRITE TABLE dest1 SELECT s.*
@@ -173,7 +177,7 @@
Output: default/dest1
query: SELECT dest1.* FROM dest1
Input: default/dest1
-Output: file:/data/users/njain/hive4/hive4/build/ql/tmp/753742949/10000
+Output: file:/data/users/pchakka/workspace/oshive/build/ql/tmp/569046726/10000
165 val_165
484 val_484
150 val_150