hadoop-hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From pras...@apache.org
Subject svn commit: r771990 [8/8] - in /hadoop/hive/trunk: ./ common/src/java/org/apache/hadoop/hive/conf/ conf/ data/conf/ hwi/ jdbc/ ql/src/java/org/apache/hadoop/hive/ql/ ql/src/java/org/apache/hadoop/hive/ql/optimizer/ ql/src/java/org/apache/hadoop/hive/ql...
Date Tue, 05 May 2009 22:17:50 GMT
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union3.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union3.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union3.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union3.q.out Tue May  5 22:17:36
2009
@@ -1,3 +1,20 @@
+query: explain
+SELECT *
+FROM (
+  SELECT 1 AS id
+  FROM (SELECT * FROM src LIMIT 1) s1
+  CLUSTER BY id
+  UNION ALL
+  SELECT 2 AS id
+  FROM (SELECT * FROM src LIMIT 1) s1
+  CLUSTER BY id
+  UNION ALL
+  SELECT 3 AS id
+  FROM (SELECT * FROM src LIMIT 1) s2
+  UNION ALL
+  SELECT 4 AS id
+  FROM (SELECT * FROM src LIMIT 1) s2
+) a
 ABSTRACT SYNTAX TREE:
   (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_UNION (TOK_UNION (TOK_UNION (TOK_QUERY (TOK_FROM
(TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR
TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_LIMIT 1))) s1)) (TOK_INSERT (TOK_DESTINATION
(TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR 1 id)) (TOK_CLUSTERBY (TOK_TABLE_OR_COL id))))
(TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION
(TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_LIMIT 1))) s1)) (TOK_INSERT
(TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR 2 id)) (TOK_CLUSTERBY (TOK_TABLE_OR_COL
id))))) (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT
(TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_LIMIT
1))) s2)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR 3
id))))) (TOK_QUERY (T
 OK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION
(TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_LIMIT 1))) s2)) (TOK_INSERT
(TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR 4 id))))) a)) (TOK_INSERT
(TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF))))
 
@@ -52,7 +69,7 @@
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        /data/users/zshao/tools/416-trunk-apache-hive/build/ql/tmp/281579407/349315994.10002

+        /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/101291857/595083252.10002

           Union
             Select Operator
               expressions:
@@ -64,7 +81,7 @@
                 table:
                     input format: org.apache.hadoop.mapred.TextInputFormat
                     output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-        /data/users/zshao/tools/416-trunk-apache-hive/build/ql/tmp/281579407/349315994.10003

+        /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/101291857/595083252.10003

           Union
             Select Operator
               expressions:
@@ -76,7 +93,7 @@
                 table:
                     input format: org.apache.hadoop.mapred.TextInputFormat
                     output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-        /data/users/zshao/tools/416-trunk-apache-hive/build/ql/tmp/281579407/349315994.10005

+        /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/101291857/595083252.10005

           Union
             Select Operator
               expressions:
@@ -88,7 +105,7 @@
                 table:
                     input format: org.apache.hadoop.mapred.TextInputFormat
                     output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
-        /data/users/zshao/tools/416-trunk-apache-hive/build/ql/tmp/281579407/349315994.10007

+        /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/101291857/595083252.10007

           Union
             Select Operator
               expressions:
@@ -172,7 +189,7 @@
   Stage: Stage-5
     Map Reduce
       Alias -> Map Operator Tree:
-        /data/users/zshao/tools/416-trunk-apache-hive/build/ql/tmp/281579407/349315994.10004

+        /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/101291857/595083252.10004

           Reduce Output Operator
             key expressions:
                   expr: 0
@@ -232,7 +249,7 @@
   Stage: Stage-7
     Map Reduce
       Alias -> Map Operator Tree:
-        /data/users/zshao/tools/416-trunk-apache-hive/build/ql/tmp/281579407/349315994.10006

+        /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/101291857/595083252.10006

           Reduce Output Operator
             key expressions:
                   expr: 0
@@ -260,6 +277,30 @@
       limit: -1
 
 
+query: DROP TABLE union_out
+query: CREATE TABLE union_out (id int)
+query: insert overwrite table union_out 
+SELECT *
+FROM (
+  SELECT 1 AS id
+  FROM (SELECT * FROM src LIMIT 1) s1
+  CLUSTER BY id
+  UNION ALL
+  SELECT 2 AS id
+  FROM (SELECT * FROM src LIMIT 1) s1
+  CLUSTER BY id
+  UNION ALL
+  SELECT 3 AS id
+  FROM (SELECT * FROM src LIMIT 1) s2
+  UNION ALL
+  SELECT 4 AS id
+  FROM (SELECT * FROM src LIMIT 1) s2
+) a
+Input: default/src
+Output: default/union_out
+query: select * from union_out cluster by id
+Input: default/union_out
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/203301579/334457117.10000
 1
 2
 3

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union4.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union4.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union4.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union4.q.out Tue May  5 22:17:36
2009
@@ -1,3 +1,10 @@
+query: drop table tmptable
+query: create table tmptable(key string, value int)
+query: explain 
+insert overwrite table tmptable
+  select unionsrc.key, unionsrc.value FROM (select 'tst1' as key, count(1) as value from
src s1
+                                        UNION  ALL  
+                                            select 'tst2' as key, count(1) as value from
src s2) unionsrc
 ABSTRACT SYNTAX TREE:
   (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_UNION (TOK_QUERY (TOK_FROM (TOK_TABREF src s1))
(TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR 'tst1' key)
(TOK_SELEXPR (TOK_FUNCTION count 1) value)))) (TOK_QUERY (TOK_FROM (TOK_TABREF src s2)) (TOK_INSERT
(TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR 'tst2' key) (TOK_SELEXPR
(TOK_FUNCTION count 1) value))))) unionsrc)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB tmptable))
(TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL unionsrc) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL
unionsrc) value)))))
 
@@ -47,7 +54,7 @@
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        /data/users/zshao/tools/416-trunk-apache-hive/build/ql/tmp/821364331/229014134.10001

+        /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/371236334/463237113.10002

           Union
             Select Operator
               expressions:
@@ -69,7 +76,7 @@
                       output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                       serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                       name: tmptable
-        /data/users/zshao/tools/416-trunk-apache-hive/build/ql/tmp/821364331/229014134.10002

+        /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/371236334/463237113.10003

           Union
             Select Operator
               expressions:
@@ -137,5 +144,15 @@
                   name: binary_table
 
 
+query: insert overwrite table tmptable
+select unionsrc.key, unionsrc.value FROM (select 'tst1' as key, count(1) as value from src
s1
+                                        UNION  ALL  
+                                          select 'tst2' as key, count(1) as value from src
s2) unionsrc
+Input: default/src
+Output: default/tmptable
+query: select * from tmptable x sort by x.key
+Input: default/tmptable
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/100441451/111422539.10000
 tst1	500
 tst2	500
+query: drop table tmptable

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union5.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union5.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union5.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union5.q.out Tue May  5 22:17:36
2009
@@ -1,3 +1,7 @@
+query: explain 
+  select unionsrc.key, count(1) FROM (select 'tst1' as key, count(1) as value from src s1
+                                    UNION  ALL  
+                                      select 'tst2' as key, count(1) as value from src s2)
unionsrc group by unionsrc.key
 ABSTRACT SYNTAX TREE:
   (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_UNION (TOK_QUERY (TOK_FROM (TOK_TABREF src s1))
(TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR 'tst1' key)
(TOK_SELEXPR (TOK_FUNCTION count 1) value)))) (TOK_QUERY (TOK_FROM (TOK_TABREF src s2)) (TOK_INSERT
(TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR 'tst2' key) (TOK_SELEXPR
(TOK_FUNCTION count 1) value))))) unionsrc)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE))
(TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL unionsrc) key)) (TOK_SELEXPR (TOK_FUNCTION count
1))) (TOK_GROUPBY (. (TOK_TABLE_OR_COL unionsrc) key))))
 
@@ -46,7 +50,7 @@
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        /data/users/zshao/tools/416-trunk-apache-hive/build/ql/tmp/1122480073/45739411.10002

+        /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/1649113926/399998151.10002

           Union
             Group By Operator
               aggregations:
@@ -67,7 +71,7 @@
                 value expressions:
                       expr: 1
                       type: bigint
-        /data/users/zshao/tools/416-trunk-apache-hive/build/ql/tmp/1122480073/45739411.10003

+        /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/1649113926/399998151.10003

           Union
             Group By Operator
               aggregations:
@@ -148,5 +152,10 @@
       limit: -1
 
 
+query: select unionsrc.key, count(1) FROM (select 'tst1' as key, count(1) as value from src
s1
+                                  UNION  ALL  
+                                    select 'tst2' as key, count(1) as value from src s2)
unionsrc group by unionsrc.key
+Input: default/src
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/1203907479/249233034.10000
 tst1	1
 tst2	1

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union6.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union6.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union6.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union6.q.out Tue May  5 22:17:36
2009
@@ -1,3 +1,10 @@
+query: drop table tmptable
+query: create table tmptable(key string, value string)
+query: explain 
+insert overwrite table tmptable
+  select unionsrc.key, unionsrc.value FROM (select 'tst1' as key, cast(count(1) as string)
as value from src s1
+                                        UNION  ALL  
+                                            select s2.key as key, s2.value as value from
src1 s2) unionsrc
 ABSTRACT SYNTAX TREE:
   (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_UNION (TOK_QUERY (TOK_FROM (TOK_TABREF src s1))
(TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR 'tst1' key)
(TOK_SELEXPR (TOK_FUNCTION TOK_STRING (TOK_FUNCTION count 1)) value)))) (TOK_QUERY (TOK_FROM
(TOK_TABREF src1 s2)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR
(. (TOK_TABLE_OR_COL s2) key) key) (TOK_SELEXPR (. (TOK_TABLE_OR_COL s2) value) value)))))
unionsrc)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB tmptable)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL
unionsrc) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL unionsrc) value)))))
 
@@ -47,7 +54,7 @@
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        /data/users/zshao/tools/416-trunk-apache-hive/build/ql/tmp/802711575/169350300.10001

+        /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/521174997/29191949.10002

           Union
             Select Operator
               expressions:
@@ -63,7 +70,7 @@
                     output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
                     serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
                     name: tmptable
-        /data/users/zshao/tools/416-trunk-apache-hive/build/ql/tmp/802711575/169350300.10002

+        /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/521174997/29191949.10003

           Union
             Select Operator
               expressions:
@@ -109,6 +116,16 @@
                     name: binary_table
 
 
+query: insert overwrite table tmptable
+select unionsrc.key, unionsrc.value FROM (select 'tst1' as key, cast(count(1) as string)
as value from src s1
+                                      UNION  ALL  
+                                          select s2.key as key, s2.value as value from src1
s2) unionsrc
+Input: default/src
+Input: default/src1
+Output: default/tmptable
+query: select * from tmptable x sort by x.key
+Input: default/tmptable
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/1147707423/406168765.10000
 	val_193
 	
 	
@@ -135,3 +152,4 @@
 66	val_66
 98	val_98
 tst1	500
+query: drop table tmptable

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union7.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union7.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union7.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union7.q.out Tue May  5 22:17:36
2009
@@ -1,3 +1,7 @@
+query: explain 
+  select unionsrc.key, count(1) FROM (select 'tst1' as key, cast(count(1) as string) as value
from src s1
+                                        UNION  ALL  
+                                            select s2.key as key, s2.value as value from
src1 s2) unionsrc group by unionsrc.key
 ABSTRACT SYNTAX TREE:
   (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_UNION (TOK_QUERY (TOK_FROM (TOK_TABREF src s1))
(TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR 'tst1' key)
(TOK_SELEXPR (TOK_FUNCTION TOK_STRING (TOK_FUNCTION count 1)) value)))) (TOK_QUERY (TOK_FROM
(TOK_TABREF src1 s2)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR
(. (TOK_TABLE_OR_COL s2) key) key) (TOK_SELEXPR (. (TOK_TABLE_OR_COL s2) value) value)))))
unionsrc)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (.
(TOK_TABLE_OR_COL unionsrc) key)) (TOK_SELEXPR (TOK_FUNCTION count 1))) (TOK_GROUPBY (. (TOK_TABLE_OR_COL
unionsrc) key))))
 
@@ -46,7 +50,7 @@
   Stage: Stage-2
     Map Reduce
       Alias -> Map Operator Tree:
-        /data/users/zshao/tools/416-trunk-apache-hive/build/ql/tmp/491802115/687421976.10002

+        /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/255905982/946698378.10002

           Union
             Group By Operator
               aggregations:
@@ -67,7 +71,7 @@
                 value expressions:
                       expr: 1
                       type: bigint
-        /data/users/zshao/tools/416-trunk-apache-hive/build/ql/tmp/491802115/687421976.10003

+        /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/255905982/946698378.10003

           Union
             Group By Operator
               aggregations:
@@ -132,6 +136,12 @@
       limit: -1
 
 
+query: select unionsrc.key, count(1) FROM (select 'tst1' as key, cast(count(1) as string)
as value from src s1
+                                      UNION  ALL  
+                                    select s2.key as key, s2.value as value from src1 s2)
unionsrc group by unionsrc.key
+Input: default/src
+Input: default/src1
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/584323767/101489285.10000
 	10
 128	1
 146	1

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union8.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union8.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union8.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union8.q.out Tue May  5 22:17:36
2009
@@ -1,3 +1,7 @@
+query: explain 
+  select unionsrc.key, unionsrc.value FROM (select s1.key as key, s1.value as value from
src s1 UNION  ALL  
+                                            select s2.key as key, s2.value as value from
src s2 UNION  ALL  
+                                            select s3.key as key, s3.value as value from
src s3) unionsrc
 ABSTRACT SYNTAX TREE:
   (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_UNION (TOK_UNION (TOK_QUERY (TOK_FROM (TOK_TABREF
src s1)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (.
(TOK_TABLE_OR_COL s1) key) key) (TOK_SELEXPR (. (TOK_TABLE_OR_COL s1) value) value)))) (TOK_QUERY
(TOK_FROM (TOK_TABREF src s2)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT
(TOK_SELEXPR (. (TOK_TABLE_OR_COL s2) key) key) (TOK_SELEXPR (. (TOK_TABLE_OR_COL s2) value)
value))))) (TOK_QUERY (TOK_FROM (TOK_TABREF src s3)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR
TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL s3) key) key) (TOK_SELEXPR (.
(TOK_TABLE_OR_COL s3) value) value))))) unionsrc)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE))
(TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL unionsrc) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL
unionsrc) value)))))
 
@@ -75,6 +79,11 @@
       limit: -1
 
 
+query: select unionsrc.key, unionsrc.value FROM (select s1.key as key, s1.value as value
from src s1 UNION  ALL  
+                                          select s2.key as key, s2.value as value from src
s2 UNION  ALL  
+                                          select s3.key as key, s3.value as value from src
s3) unionsrc
+Input: default/src
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/158356330/11376793.10000
 238	val_238
 238	val_238
 238	val_238

Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/union9.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/union9.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/union9.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/union9.q.out Tue May  5 22:17:36
2009
@@ -1,3 +1,7 @@
+query: explain 
+  select count(1) FROM (select s1.key as key, s1.value as value from src s1 UNION  ALL  
+                        select s2.key as key, s2.value as value from src s2 UNION ALL
+                        select s3.key as key, s3.value as value from src s3) unionsrc
 ABSTRACT SYNTAX TREE:
   (TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_UNION (TOK_UNION (TOK_QUERY (TOK_FROM (TOK_TABREF
src s1)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (.
(TOK_TABLE_OR_COL s1) key) key) (TOK_SELEXPR (. (TOK_TABLE_OR_COL s1) value) value)))) (TOK_QUERY
(TOK_FROM (TOK_TABREF src s2)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT
(TOK_SELEXPR (. (TOK_TABLE_OR_COL s2) key) key) (TOK_SELEXPR (. (TOK_TABLE_OR_COL s2) value)
value))))) (TOK_QUERY (TOK_FROM (TOK_TABREF src s3)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR
TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL s3) key) key) (TOK_SELEXPR (.
(TOK_TABLE_OR_COL s3) value) value))))) unionsrc)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE))
(TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION count 1)))))
 
@@ -84,4 +88,9 @@
       limit: -1
 
 
+query: select count(1) FROM (select s1.key as key, s1.value as value from src s1 UNION  ALL
 
+                        select s2.key as key, s2.value as value from src s2 UNION ALL
+                        select s3.key as key, s3.value as value from src s3) unionsrc
+Input: default/src
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/371390513/112754866.10000
 1500

Modified: hadoop/hive/trunk/service/build.xml
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/service/build.xml?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/service/build.xml (original)
+++ hadoop/hive/trunk/service/build.xml Tue May  5 22:17:36 2009
@@ -30,6 +30,17 @@
 
   <import file="../build-common.xml"/>
 
+  <path id="test.classpath">
+    <pathelement location="${test.build.classes}" />
+    <pathelement location="" />
+    <pathelement location="${test.data.dir}/conf"/>
+    <pathelement location="${hive.conf.dir}"/>
+    <fileset dir="${test.src.data.dir}" includes="files/*.jar"/>
+    <fileset dir="${hive.root}" includes="testlibs/*.jar"/>
+    <pathelement location="${build.dir.hive}/ql/test/classes"/>
+    <path refid="classpath"/>
+  </path>
+
   <target name="thriftif">
     <echo>Executing thrift (which needs to be in your path) to build java metastore
APIs.... </echo>
     <exec executable="thrift"  failonerror="true" dir=".">

Modified: hadoop/hive/trunk/service/src/test/org/apache/hadoop/hive/service/TestHiveServer.java
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/service/src/test/org/apache/hadoop/hive/service/TestHiveServer.java?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/service/src/test/org/apache/hadoop/hive/service/TestHiveServer.java
(original)
+++ hadoop/hive/trunk/service/src/test/org/apache/hadoop/hive/service/TestHiveServer.java
Tue May  5 22:17:36 2009
@@ -35,7 +35,9 @@
     String dataFileDir = conf.get("test.data.files").replace('\\', '/').replace("c:", "");
     dataFilePath = new Path(dataFileDir, "kv1.txt");
     // See data/conf/hive-site.xml
-    standAloneServer = System.getProperty("test.service.standalone.server").equals("true");
+    String paramStr = System.getProperty("test.service.standalone.server");
+    if (paramStr != null && paramStr.equals("true"))
+      standAloneServer = true;
   }
 
   protected void setUp() throws Exception {



Mime
View raw message