You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by pr...@apache.org on 2009/05/06 00:17:50 UTC
svn commit: r771990 [3/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...
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8_map_skew.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8_map_skew.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8_map_skew.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8_map_skew.q.out Tue May 5 22:17:36 2009
@@ -1,3 +1,9 @@
+query: CREATE TABLE DEST1(key INT, value STRING) STORED AS TEXTFILE
+query: CREATE TABLE DEST2(key INT, value STRING) STORED AS TEXTFILE
+query: EXPLAIN
+FROM SRC
+INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key
+INSERT OVERWRITE TABLE DEST2 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF SRC)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB DEST1)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL SRC) key)) (TOK_SELEXPR (TOK_FUNCTIONDI COUNT (TOK_FUNCTION SUBSTR (. (TOK_TABLE_OR_COL SRC) value) 5)))) (TOK_GROUPBY (. (TOK_TABLE_OR_COL SRC) key))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB DEST2)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL SRC) key)) (TOK_SELEXPR (TOK_FUNCTIONDI COUNT (TOK_FUNCTION SUBSTR (. (TOK_TABLE_OR_COL SRC) value) 5)))) (TOK_GROUPBY (. (TOK_TABLE_OR_COL SRC) key))))
@@ -74,7 +80,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/zshao/tools/416-trunk-apache-hive/build/ql/tmp/144805361/525191903.10002
+ /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/274046296/767130723.10004
Reduce Output Operator
key expressions:
expr: 0
@@ -135,7 +141,7 @@
Stage: Stage-3
Map Reduce
Alias -> Map Operator Tree:
- /data/users/zshao/tools/416-trunk-apache-hive/build/ql/tmp/144805361/525191903.10003
+ /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/274046296/767130723.10005
Reduce Output Operator
key expressions:
expr: 0
@@ -171,7 +177,7 @@
Stage: Stage-4
Map Reduce
Alias -> Map Operator Tree:
- /data/users/zshao/tools/416-trunk-apache-hive/build/ql/tmp/144805361/525191903.10004
+ /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/274046296/767130723.10006
Reduce Output Operator
key expressions:
expr: 0
@@ -214,6 +220,15 @@
name: dest2
+query: FROM SRC
+INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key
+INSERT OVERWRITE TABLE DEST2 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key
+Input: default/src
+Output: default/dest1
+Output: default/dest2
+query: SELECT DEST1.* FROM DEST1
+Input: default/dest1
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/589113181/576499023.10000
0 1
10 1
100 1
@@ -523,6 +538,9 @@
96 1
97 1
98 1
+query: SELECT DEST2.* FROM DEST2
+Input: default/dest2
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/989060991/1124156593.10000
0 1
10 1
100 1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8_noskew.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8_noskew.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8_noskew.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby8_noskew.q.out Tue May 5 22:17:36 2009
@@ -1,3 +1,9 @@
+query: CREATE TABLE DEST1(key INT, value STRING) STORED AS TEXTFILE
+query: CREATE TABLE DEST2(key INT, value STRING) STORED AS TEXTFILE
+query: EXPLAIN
+FROM SRC
+INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key
+INSERT OVERWRITE TABLE DEST2 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF SRC)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB DEST1)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL SRC) key)) (TOK_SELEXPR (TOK_FUNCTIONDI COUNT (TOK_FUNCTION SUBSTR (. (TOK_TABLE_OR_COL SRC) value) 5)))) (TOK_GROUPBY (. (TOK_TABLE_OR_COL SRC) key))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB DEST2)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL SRC) key)) (TOK_SELEXPR (TOK_FUNCTIONDI COUNT (TOK_FUNCTION SUBSTR (. (TOK_TABLE_OR_COL SRC) value) 5)))) (TOK_GROUPBY (. (TOK_TABLE_OR_COL SRC) key))))
@@ -78,7 +84,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/zshao/tools/416-trunk-apache-hive/build/ql/tmp/1800149890/170127499.10002
+ /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/280831989/373656.10004
Reduce Output Operator
key expressions:
expr: key
@@ -120,6 +126,15 @@
name: dest2
+query: FROM SRC
+INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key
+INSERT OVERWRITE TABLE DEST2 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key
+Input: default/src
+Output: default/dest1
+Output: default/dest2
+query: SELECT DEST1.* FROM DEST1
+Input: default/dest1
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/14233066/985088079.10000
0 1
10 1
100 1
@@ -429,6 +444,9 @@
96 1
97 1
98 1
+query: SELECT DEST2.* FROM DEST2
+Input: default/dest2
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/1779608708/316437586.10000
0 1
10 1
100 1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby9.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby9.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby9.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby9.q.out Tue May 5 22:17:36 2009
@@ -1,3 +1,11 @@
+query: drop table DEST1
+query: drop table DEST2
+query: CREATE TABLE DEST1(key INT, value STRING) STORED AS TEXTFILE
+query: CREATE TABLE DEST2(key INT, val1 STRING, val2 STRING) STORED AS TEXTFILE
+query: EXPLAIN
+FROM SRC
+INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key
+INSERT OVERWRITE TABLE DEST2 SELECT SRC.key, SRC.value, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key, SRC.value
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF SRC)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB DEST1)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL SRC) key)) (TOK_SELEXPR (TOK_FUNCTIONDI COUNT (TOK_FUNCTION SUBSTR (. (TOK_TABLE_OR_COL SRC) value) 5)))) (TOK_GROUPBY (. (TOK_TABLE_OR_COL SRC) key))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB DEST2)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL SRC) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL SRC) value)) (TOK_SELEXPR (TOK_FUNCTIONDI COUNT (TOK_FUNCTION SUBSTR (. (TOK_TABLE_OR_COL SRC) value) 5)))) (TOK_GROUPBY (. (TOK_TABLE_OR_COL SRC) key) (. (TOK_TABLE_OR_COL SRC) value))))
@@ -101,7 +109,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/zshao/tools/416-trunk-apache-hive/build/ql/tmp/1510455594/320201292.10002
+ /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/31497839/593540242.10004
Reduce Output Operator
key expressions:
expr: 0
@@ -156,6 +164,15 @@
name: dest2
+query: FROM SRC
+INSERT OVERWRITE TABLE DEST1 SELECT SRC.key, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key
+INSERT OVERWRITE TABLE DEST2 SELECT SRC.key, SRC.value, COUNT(DISTINCT SUBSTR(SRC.value,5)) GROUP BY SRC.key, SRC.value
+Input: default/src
+Output: default/dest1
+Output: default/dest2
+query: SELECT DEST1.* FROM DEST1
+Input: default/dest1
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/152745787/1102138791.10000
0 1
10 1
100 1
@@ -465,6 +482,9 @@
96 1
97 1
98 1
+query: SELECT DEST2.* FROM DEST2
+Input: default/dest2
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/1433096776/86175165.10000
0 val_0 1
10 val_10 1
100 val_100 1
@@ -774,3 +794,5 @@
96 val_96 1
97 val_97 1
98 val_98 1
+query: drop table DEST1
+query: drop table DEST2
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby_bigdata.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby_bigdata.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby_bigdata.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/groupby_bigdata.q.out Tue May 5 22:17:36 2009
@@ -1 +1,5 @@
+query: select count(distinct subq.key) from
+(FROM src MAP src.key USING 'python ../data/scripts/dumpdata_script.py' AS key WHERE src.key = 10) subq
+Input: default/src
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/56403262/669115083.10000
1000022
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/implicit_cast1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/implicit_cast1.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/implicit_cast1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/implicit_cast1.q.out Tue May 5 22:17:36 2009
@@ -1,3 +1,8 @@
+query: CREATE TABLE implicit_test1(a BIGINT, b STRING) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe' WITH SERDEPROPERTIES('serialization.format'= 'org.apache.hadoop.hive.serde2.thrift.TCTLSeparatedProtocol') STORED AS TEXTFILE
+query: EXPLAIN
+SELECT implicit_test1.*
+FROM implicit_test1
+WHERE implicit_test1.a <> 0
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF implicit_test1)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF implicit_test1))) (TOK_WHERE (<> (. (TOK_TABLE_OR_COL implicit_test1) a) 0))))
@@ -32,3 +37,9 @@
limit: -1
+query: SELECT implicit_test1.*
+FROM implicit_test1
+WHERE implicit_test1.a <> 0
+Input: default/implicit_test1
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/253022585/673360259.10000
+query: DROP TABLE implicit_test1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input.q.out Tue May 5 22:17:36 2009
@@ -1,3 +1,5 @@
+query: EXPLAIN
+SELECT x.* FROM SRC x
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF SRC x)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF x)))))
@@ -10,6 +12,9 @@
limit: -1
+query: SELECT x.* FROM SRC x
+Input: default/src
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/75849450/132865701.10000
238 val_238
86 val_86
311 val_311
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input0.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input0.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input0.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input0.q.out Tue May 5 22:17:36 2009
@@ -1,3 +1,5 @@
+query: EXPLAIN
+SELECT * FROM src
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF))))
@@ -10,6 +12,9 @@
limit: -1
+query: SELECT * FROM src
+Input: default/src
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/47962917/505914661.10000
238 val_238
86 val_86
311 val_311
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input1.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input1.q.out Tue May 5 22:17:36 2009
@@ -1,3 +1,6 @@
+query: CREATE TABLE TEST1(A INT, B DOUBLE) STORED AS TEXTFILE
+query: EXPLAIN
+DESCRIBE TEST1
ABSTRACT SYNTAX TREE:
(TOK_DESCTABLE (TOK_TABTYPE TEST1))
@@ -16,5 +19,7 @@
limit: -1
+query: DESCRIBE TEST1
a int
b double
+query: DROP TABLE TEST1
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input10.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input10.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input10.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input10.q.out Tue May 5 22:17:36 2009
@@ -1,3 +1,6 @@
+query: CREATE TABLE TEST10(key INT, value STRING) PARTITIONED BY(ds STRING, hr STRING) STORED AS TEXTFILE
+query: EXPLAIN
+DESCRIBE TEST10
ABSTRACT SYNTAX TREE:
(TOK_DESCTABLE (TOK_TABTYPE TEST10))
@@ -16,7 +19,9 @@
limit: -1
+query: DESCRIBE TEST10
key int
value string
ds string
hr string
+query: DROP TABLE TEST10
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input11.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input11.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input11.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input11.q.out Tue May 5 22:17:36 2009
@@ -1,3 +1,7 @@
+query: CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE
+query: EXPLAIN
+FROM src
+INSERT OVERWRITE TABLE dest1 SELECT src.key, src.value WHERE src.key < 100
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL src) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL src) value))) (TOK_WHERE (< (. (TOK_TABLE_OR_COL src) key) 100))))
@@ -46,6 +50,13 @@
name: dest1
+query: FROM src
+INSERT OVERWRITE TABLE dest1 SELECT src.key, src.value WHERE src.key < 100
+Input: default/src
+Output: default/dest1
+query: SELECT dest1.* FROM dest1
+Input: default/dest1
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/204335901/94270263.10000
86 val_86
27 val_27
98 val_98
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input11_limit.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input11_limit.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input11_limit.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input11_limit.q.out Tue May 5 22:17:36 2009
@@ -1,3 +1,7 @@
+query: CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE
+query: EXPLAIN
+FROM src
+INSERT OVERWRITE TABLE dest1 SELECT src.key, src.value WHERE src.key < 100 LIMIT 10
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL src) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL src) value))) (TOK_WHERE (< (. (TOK_TABLE_OR_COL src) key) 100)) (TOK_LIMIT 10)))
@@ -58,6 +62,13 @@
name: dest1
+query: FROM src
+INSERT OVERWRITE TABLE dest1 SELECT src.key, src.value WHERE src.key < 100 LIMIT 10
+Input: default/src
+Output: default/dest1
+query: SELECT dest1.* FROM dest1
+Input: default/dest1
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/76746890/763200943.10000
86 val_86
27 val_27
98 val_98
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input12.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input12.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input12.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input12.q.out Tue May 5 22:17:36 2009
@@ -1,3 +1,11 @@
+query: CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE
+query: CREATE TABLE dest2(key INT, value STRING) STORED AS TEXTFILE
+query: CREATE TABLE dest3(key INT) PARTITIONED BY(ds STRING, hr STRING) STORED AS TEXTFILE
+query: EXPLAIN
+FROM src
+INSERT OVERWRITE TABLE dest1 SELECT src.* WHERE src.key < 100
+INSERT OVERWRITE TABLE dest2 SELECT src.key, src.value WHERE src.key >= 100 and src.key < 200
+INSERT OVERWRITE TABLE dest3 PARTITION(ds='2008-04-08', hr='12') SELECT src.key WHERE src.key >= 200
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF src))) (TOK_WHERE (< (. (TOK_TABLE_OR_COL src) key) 100))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest2)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL src) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL src) value))) (TOK_WHERE (and (>= (. (TOK_TABLE_OR_COL src) key) 100) (< (. (TOK_TABLE_OR_COL src) key) 200)))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest3 (TOK_PARTSPEC (TOK_PARTVAL ds '2008-04-08') (TOK_PARTVAL hr '12')))) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL src) key))) (TOK_WHERE (>= (. (TOK_TABLE_OR_COL src) key) 200))))
@@ -105,6 +113,17 @@
name: dest3
+query: FROM src
+INSERT OVERWRITE TABLE dest1 SELECT src.* WHERE src.key < 100
+INSERT OVERWRITE TABLE dest2 SELECT src.key, src.value WHERE src.key >= 100 and src.key < 200
+INSERT OVERWRITE TABLE dest3 PARTITION(ds='2008-04-08', hr='12') SELECT src.key WHERE src.key >= 200
+Input: default/src
+Output: default/dest1
+Output: default/dest2
+Output: default/dest3/ds=2008-04-08/hr=12
+query: SELECT dest1.* FROM dest1
+Input: default/dest1
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/1596690660/1217911700.10000
86 val_86
27 val_27
98 val_98
@@ -189,6 +208,9 @@
37 val_37
90 val_90
97 val_97
+query: SELECT dest2.* FROM dest2
+Input: default/dest2
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/28573739/190647993.10000
165 val_165
193 val_193
150 val_150
@@ -294,6 +316,9 @@
194 val_194
126 val_126
169 val_169
+query: SELECT dest3.* FROM dest3
+Input: default/dest3/ds=2008-04-08/hr=12
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/135776438/188412986.10000
238 2008-04-08 12
311 2008-04-08 12
409 2008-04-08 12
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input13.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input13.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input13.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input13.q.out Tue May 5 22:17:36 2009
@@ -1,3 +1,12 @@
+query: CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE
+query: CREATE TABLE dest2(key INT, value STRING) STORED AS TEXTFILE
+query: CREATE TABLE dest3(key INT) PARTITIONED BY(ds STRING, hr STRING) STORED AS TEXTFILE
+query: EXPLAIN
+FROM src
+INSERT OVERWRITE TABLE dest1 SELECT src.* WHERE src.key < 100
+INSERT OVERWRITE TABLE dest2 SELECT src.key, src.value WHERE src.key >= 100 and src.key < 200
+INSERT OVERWRITE TABLE dest3 PARTITION(ds='2008-04-08', hr='12') SELECT src.key WHERE src.key >= 200 and src.key < 300
+INSERT OVERWRITE DIRECTORY '../build/ql/test/data/warehouse/dest4.out' SELECT src.value WHERE src.key >= 300
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF src))) (TOK_WHERE (< (. (TOK_TABLE_OR_COL src) key) 100))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest2)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL src) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL src) value))) (TOK_WHERE (and (>= (. (TOK_TABLE_OR_COL src) key) 100) (< (. (TOK_TABLE_OR_COL src) key) 200)))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest3 (TOK_PARTSPEC (TOK_PARTVAL ds '2008-04-08') (TOK_PARTVAL hr '12')))) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL src) key))) (TOK_WHERE (and (>= (. (TOK_TABLE_OR_COL src) key) 200) (< (. (TOK_TABLE_OR_COL src) key) 300)))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR '../build/ql/test/data/warehouse/dest4.out')) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL src) value))) (TOK_WHERE (>= (. (TOK_TABLE_OR_COL src) key) 300))))
@@ -122,6 +131,19 @@
name: dest3
+query: FROM src
+INSERT OVERWRITE TABLE dest1 SELECT src.* WHERE src.key < 100
+INSERT OVERWRITE TABLE dest2 SELECT src.key, src.value WHERE src.key >= 100 and src.key < 200
+INSERT OVERWRITE TABLE dest3 PARTITION(ds='2008-04-08', hr='12') SELECT src.key WHERE src.key >= 200 and src.key < 300
+INSERT OVERWRITE DIRECTORY '../build/ql/test/data/warehouse/dest4.out' SELECT src.value WHERE src.key >= 300
+Input: default/src
+Output: default/dest1
+Output: default/dest2
+Output: default/dest3/ds=2008-04-08/hr=12
+Output: ../build/ql/test/data/warehouse/dest4.out
+query: SELECT dest1.* FROM dest1
+Input: default/dest1
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/101162710/400931609.10000
86 val_86
27 val_27
98 val_98
@@ -206,6 +228,9 @@
37 val_37
90 val_90
97 val_97
+query: SELECT dest2.* FROM dest2
+Input: default/dest2
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/276246666/1730128617.10000
165 val_165
193 val_193
150 val_150
@@ -311,6 +336,9 @@
194 val_194
126 val_126
169 val_169
+query: SELECT dest3.* FROM dest3
+Input: default/dest3/ds=2008-04-08/hr=12
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/267290504/751561735.10000
238 2008-04-08 12
255 2008-04-08 12
278 2008-04-08 12
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input14.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input14.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input14.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input14.q.out Tue May 5 22:17:36 2009
@@ -1,3 +1,12 @@
+query: CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE
+query: EXPLAIN
+FROM (
+ FROM src
+ SELECT TRANSFORM(src.key, src.value)
+ USING '/bin/cat' AS (tkey, tvalue)
+ CLUSTER BY tkey
+) tmap
+INSERT OVERWRITE TABLE dest1 SELECT tmap.tkey, tmap.tvalue WHERE tmap.tkey < 100
ABSTRACT SYNTAX TREE:
(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_TRANSFORM (TOK_EXPLIST (. (TOK_TABLE_OR_COL src) key) (. (TOK_TABLE_OR_COL src) value)) '/bin/cat' (TOK_ALIASLIST tkey tvalue)))) (TOK_CLUSTERBY (TOK_TABLE_OR_COL tkey)))) tmap)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL tmap) tkey)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL tmap) tvalue))) (TOK_WHERE (< (. (TOK_TABLE_OR_COL tmap) tkey) 100))))
@@ -73,6 +82,18 @@
name: dest1
+query: FROM (
+ FROM src
+ SELECT TRANSFORM(src.key, src.value)
+ USING '/bin/cat' AS (tkey, tvalue)
+ CLUSTER BY tkey
+) tmap
+INSERT OVERWRITE TABLE dest1 SELECT tmap.tkey, tmap.tvalue WHERE tmap.tkey < 100
+Input: default/src
+Output: default/dest1
+query: SELECT dest1.* FROM dest1
+Input: default/dest1
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/815600455/1462527055.10000
0 val_0
0 val_0
0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input14_limit.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input14_limit.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input14_limit.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input14_limit.q.out Tue May 5 22:17:36 2009
@@ -1,3 +1,12 @@
+query: CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE
+query: EXPLAIN
+FROM (
+ FROM src
+ SELECT TRANSFORM(src.key, src.value)
+ USING '/bin/cat' AS (tkey, tvalue)
+ CLUSTER BY tkey LIMIT 20
+) tmap
+INSERT OVERWRITE TABLE dest1 SELECT tmap.tkey, tmap.tvalue WHERE tmap.tkey < 100
ABSTRACT SYNTAX TREE:
(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_TRANSFORM (TOK_EXPLIST (. (TOK_TABLE_OR_COL src) key) (. (TOK_TABLE_OR_COL src) value)) '/bin/cat' (TOK_ALIASLIST tkey tvalue)))) (TOK_CLUSTERBY (TOK_TABLE_OR_COL tkey)) (TOK_LIMIT 20))) tmap)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL tmap) tkey)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL tmap) tvalue))) (TOK_WHERE (< (. (TOK_TABLE_OR_COL tmap) tkey) 100))))
@@ -50,7 +59,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/zshao/tools/416-trunk-apache-hive/build/ql/tmp/1749790982/29069662.10001
+ /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/760042759/650000990.10002
Reduce Output Operator
key expressions:
expr: 0
@@ -104,6 +113,18 @@
name: dest1
+query: FROM (
+ FROM src
+ SELECT TRANSFORM(src.key, src.value)
+ USING '/bin/cat' AS (tkey, tvalue)
+ CLUSTER BY tkey LIMIT 20
+) tmap
+INSERT OVERWRITE TABLE dest1 SELECT tmap.tkey, tmap.tvalue WHERE tmap.tkey < 100
+Input: default/src
+Output: default/dest1
+query: SELECT dest1.* FROM dest1
+Input: default/dest1
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/27339988/227404504.10000
0 val_0
0 val_0
0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input15.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input15.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input15.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input15.q.out Tue May 5 22:17:36 2009
@@ -1,3 +1,5 @@
+query: EXPLAIN
+CREATE TABLE TEST15(key INT, value STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' STORED AS TEXTFILE
ABSTRACT SYNTAX TREE:
(TOK_CREATETABLE TEST15 (TOK_TABCOLLIST (TOK_TABCOL key TOK_INT) (TOK_TABCOL value TOK_STRING)) (TOK_TABLEROWFORMAT (TOK_TABLEROWFORMATFIELD '\t')) TOK_TBLTEXTFILE)
@@ -18,5 +20,8 @@
isExternal: false
+query: CREATE TABLE TEST15(key INT, value STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t' STORED AS TEXTFILE
+query: DESCRIBE TEST15
key int
value string
+query: DROP TABLE TEST15
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input16.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input16.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input16.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input16.q.out Tue May 5 22:17:36 2009
@@ -1,3 +1,9 @@
+query: DROP TABLE INPUT16
+query: CREATE TABLE INPUT16(KEY STRING, VALUE STRING) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.TestSerDe' STORED AS TEXTFILE
+query: LOAD DATA LOCAL INPATH '../data/files/kv1_cb.txt' INTO TABLE INPUT16
+query: SELECT INPUT16.VALUE, INPUT16.KEY FROM INPUT16
+Input: default/input16
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/62593409/1607071713.10000
val_238 238
val_86 86
val_311 311
@@ -498,3 +504,4 @@
val_400 400
val_200 200
val_97 97
+query: DROP TABLE INPUT16
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input16_cc.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input16_cc.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input16_cc.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input16_cc.q.out Tue May 5 22:17:36 2009
@@ -1,3 +1,9 @@
+query: DROP TABLE INPUT16_CC
+query: CREATE TABLE INPUT16_CC(KEY STRING, VALUE STRING) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.TestSerDe' with serdeproperties ('testserde.default.serialization.format'='\003', 'dummy.prop.not.used'='dummyy.val') STORED AS TEXTFILE
+query: LOAD DATA LOCAL INPATH '../data/files/kv1_cc.txt' INTO TABLE INPUT16_CC
+query: SELECT INPUT16_CC.VALUE, INPUT16_CC.KEY FROM INPUT16_CC
+Input: default/input16_cc
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/505022158/998217510.10000
val_238 238
val_86 86
val_311 311
@@ -498,3 +504,4 @@
val_400 400
val_200 200
val_97 97
+query: DROP TABLE INPUT16_CC
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input17.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input17.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input17.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input17.q.out Tue May 5 22:17:36 2009
@@ -1,3 +1,12 @@
+query: CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE
+query: EXPLAIN
+FROM (
+ FROM src_thrift
+ SELECT TRANSFORM(src_thrift.aint + src_thrift.lint[0], src_thrift.lintstring[0])
+ USING '/bin/cat' AS (tkey, tvalue)
+ CLUSTER BY tkey
+) tmap
+INSERT OVERWRITE TABLE dest1 SELECT tmap.tkey, tmap.tvalue
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src_thrift)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TRANSFORM (TOK_EXPLIST (+ (. (TOK_TABLE_OR_COL src_thrift) aint) ([ (. (TOK_TABLE_OR_COL src_thrift) lint) 0)) ([ (. (TOK_TABLE_OR_COL src_thrift) lintstring) 0)) '/bin/cat' (TOK_ALIASLIST tkey tvalue)))) (TOK_CLUSTERBY (TOK_TABLE_OR_COL tkey)))) tmap)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL tmap) tkey)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL tmap) tvalue)))))
@@ -77,6 +86,18 @@
name: dest1
+query: FROM (
+ FROM src_thrift
+ SELECT TRANSFORM(src_thrift.aint + src_thrift.lint[0], src_thrift.lintstring[0])
+ USING '/bin/cat' AS (tkey, tvalue)
+ CLUSTER BY tkey
+) tmap
+INSERT OVERWRITE TABLE dest1 SELECT tmap.tkey, tmap.tvalue
+Input: default/src_thrift
+Output: default/dest1
+query: SELECT dest1.* FROM dest1
+Input: default/dest1
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/10910343/1742990479.10000
NULL {"myint":null,"mystring":null}
-1461153966 {"myint":49,"mystring":"343"}
-1952710705 {"myint":25,"mystring":"125"}
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input18.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input18.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input18.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input18.q.out Tue May 5 22:17:36 2009
@@ -1,3 +1,12 @@
+query: CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE
+query: EXPLAIN
+FROM (
+ FROM src
+ SELECT TRANSFORM(src.key, src.value, 1+2, 3+4)
+ USING '/bin/cat'
+ CLUSTER BY key
+) tmap
+INSERT OVERWRITE TABLE dest1 SELECT tmap.key, regexp_replace(tmap.value,'\t','+') WHERE tmap.key < 100
ABSTRACT SYNTAX TREE:
(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_TRANSFORM (TOK_EXPLIST (. (TOK_TABLE_OR_COL src) key) (. (TOK_TABLE_OR_COL src) value) (+ 1 2) (+ 3 4)) '/bin/cat'))) (TOK_CLUSTERBY (TOK_TABLE_OR_COL key)))) tmap)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL tmap) key)) (TOK_SELEXPR (TOK_FUNCTION regexp_replace (. (TOK_TABLE_OR_COL tmap) value) '\t' '+'))) (TOK_WHERE (< (. (TOK_TABLE_OR_COL tmap) key) 100))))
@@ -77,6 +86,18 @@
name: dest1
+query: FROM (
+ FROM src
+ SELECT TRANSFORM(src.key, src.value, 1+2, 3+4)
+ USING '/bin/cat'
+ CLUSTER BY key
+) tmap
+INSERT OVERWRITE TABLE dest1 SELECT tmap.key, regexp_replace(tmap.value,'\t','+') WHERE tmap.key < 100
+Input: default/src
+Output: default/dest1
+query: SELECT dest1.* FROM dest1
+Input: default/dest1
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/543730859/7367833.10000
0 val_0+3+7
0 val_0+3+7
0 val_0+3+7
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input19.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input19.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input19.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input19.q.out Tue May 5 22:17:36 2009
@@ -1 +1,8 @@
+query: drop table apachelog
+query: create table apachelog(ipaddress STRING,identd STRING,user STRING,finishtime STRING,requestline string,returncode INT,size INT) ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.dynamic_type.DynamicSerDe' WITH SERDEPROPERTIES ( 'serialization.format'= 'org.apache.hadoop.hive.serde2.thrift.TCTLSeparatedProtocol', 'quote.delim'= '("|\\[|\\])', 'field.delim'=' ', 'serialization.null.format'='-' ) STORED AS TEXTFILE
+query: LOAD DATA LOCAL INPATH '../data/files/apache.access.log' INTO TABLE apachelog
+query: SELECT a.* FROM apachelog a
+Input: default/apachelog
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/102182399/358987266.10000
127.0.0.1 NULL frank 10/Oct/2000:13:55:36 -0700 GET /apache_pb.gif HTTP/1.0 200 2326
+query: drop table apachelog
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input1_limit.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input1_limit.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input1_limit.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input1_limit.q.out Tue May 5 22:17:36 2009
@@ -1,3 +1,9 @@
+query: CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE
+query: CREATE TABLE dest2(key INT, value STRING) STORED AS TEXTFILE
+query: EXPLAIN
+FROM src
+INSERT OVERWRITE TABLE dest1 SELECT src.key, src.value WHERE src.key < 100 LIMIT 10
+INSERT OVERWRITE TABLE dest2 SELECT src.key, src.value WHERE src.key < 100 LIMIT 5
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL src) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL src) value))) (TOK_WHERE (< (. (TOK_TABLE_OR_COL src) key) 100)) (TOK_LIMIT 10)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest2)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL src) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL src) value))) (TOK_WHERE (< (. (TOK_TABLE_OR_COL src) key) 100)) (TOK_LIMIT 5)))
@@ -86,7 +92,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/zshao/tools/416-trunk-apache-hive/build/ql/tmp/271740607/7826613.10002
+ /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/1393171375/384835321.10004
Reduce Output Operator
sort order:
tag: -1
@@ -114,6 +120,15 @@
name: dest2
+query: FROM src
+INSERT OVERWRITE TABLE dest1 SELECT src.key, src.value WHERE src.key < 100 LIMIT 10
+INSERT OVERWRITE TABLE dest2 SELECT src.key, src.value WHERE src.key < 100 LIMIT 5
+Input: default/src
+Output: default/dest1
+Output: default/dest2
+query: SELECT dest1.* FROM dest1
+Input: default/dest1
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/516449067/362942478.10000
86 val_86
27 val_27
98 val_98
@@ -124,8 +139,13 @@
17 val_17
0 val_0
57 val_57
+query: SELECT dest2.* FROM dest2
+Input: default/dest2
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/202699438/194358324.10000
86 val_86
27 val_27
98 val_98
66 val_66
37 val_37
+query: DROP TABLE dest1
+query: DROP TABLE dest2
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input2.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input2.q.out Tue May 5 22:17:36 2009
@@ -1,8 +1,15 @@
+query: DROP TABLE TEST2a
+query: DROP TABLE TEST2b
+query: CREATE TABLE TEST2a(A INT, B DOUBLE) STORED AS TEXTFILE
+query: DESCRIBE TEST2a
a int
b double
+query: CREATE TABLE TEST2b(A ARRAY<INT>, B DOUBLE, C MAP<DOUBLE, INT>) STORED AS TEXTFILE
+query: DESCRIBE TEST2b
a array<int>
b double
c map<double,int>
+query: SHOW TABLES
src
src1
src_json
@@ -12,6 +19,8 @@
srcpart
test2a
test2b
+query: DROP TABLE TEST2a
+query: SHOW TABLES
src
src1
src_json
@@ -20,6 +29,9 @@
srcbucket
srcpart
test2b
+query: DROP TABLE TEST2b
+query: EXPLAIN
+SHOW TABLES
ABSTRACT SYNTAX TREE:
TOK_SHOWTABLES
@@ -37,3 +49,5 @@
limit: -1
+query: DROP TABLE TEST2a
+query: DROP TABLE TEST2b
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input20.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input20.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input20.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input20.q.out Tue May 5 22:17:36 2009
@@ -1,3 +1,16 @@
+query: CREATE TABLE dest1(key INT, value STRING) STORED AS TEXTFILE
+query: EXPLAIN
+FROM (
+ FROM src
+ MAP src.key, src.key
+ USING 'cat'
+ DISTRIBUTE BY key
+ SORT BY key, value
+) tmap
+INSERT OVERWRITE TABLE dest1
+REDUCE tmap.key, tmap.value
+USING '../data/scripts/input20_script'
+AS key, value
ABSTRACT SYNTAX TREE:
(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_TRANSFORM (TOK_EXPLIST (. (TOK_TABLE_OR_COL src) key) (. (TOK_TABLE_OR_COL src) key)) 'cat'))) (TOK_DISTRIBUTEBY (TOK_TABLE_OR_COL key)) (TOK_SORTBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL key)) (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL value))))) tmap)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (TOK_TRANSFORM (TOK_EXPLIST (. (TOK_TABLE_OR_COL tmap) key) (. (TOK_TABLE_OR_COL tmap) value)) '../data/scripts/input20_script' (TOK_ALIASLIST key value))))))
@@ -80,6 +93,22 @@
name: dest1
+query: FROM (
+ FROM src
+ MAP src.key, src.key
+ USING 'cat'
+ DISTRIBUTE BY key
+ SORT BY key, value
+) tmap
+INSERT OVERWRITE TABLE dest1
+REDUCE tmap.key, tmap.value
+USING '../data/scripts/input20_script'
+AS key, value
+Input: default/src
+Output: default/dest1
+query: SELECT * FROM dest1 SORT BY key, value
+Input: default/dest1
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/1477442306/994995165.10000
1 105_105
1 10_10
1 111_111
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input21.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input21.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input21.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input21.q.out Tue May 5 22:17:36 2009
@@ -1,3 +1,7 @@
+query: DROP TABLE src_null
+query: CREATE TABLE src_null(a STRING, b STRING, c STRING, d STRING) STORED AS TEXTFILE
+query: LOAD DATA LOCAL INPATH '../data/files/null.txt' INTO TABLE src_null
+query: EXPLAIN SELECT * FROM src_null DISTRIBUTE BY c SORT BY d
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF src_null)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_DISTRIBUTEBY (TOK_TABLE_OR_COL c)) (TOK_SORTBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL d)))))
@@ -52,6 +56,9 @@
limit: -1
+query: SELECT * FROM src_null DISTRIBUTE BY c SORT BY d
+Input: default/src_null
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/435874957/1843130221.10000
1.0 1 same 0
1.0 1 same 1
1.0 1 same 2
@@ -62,3 +69,4 @@
1.0 NULL same 7
1.0 1 same 8
1.0 1 same 9
+query: DROP TABLE src_null
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input22.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input22.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input22.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input22.q.out Tue May 5 22:17:36 2009
@@ -1,3 +1,10 @@
+query: CREATE TABLE INPUT4(KEY STRING, VALUE STRING) STORED AS TEXTFILE
+query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE INPUT4
+query: EXPLAIN
+SELECT a.KEY2
+FROM (SELECT INPUT4.*, INPUT4.KEY as KEY2
+ FROM INPUT4) a
+ORDER BY KEY2 LIMIT 10
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF INPUT4)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF INPUT4)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL INPUT4) KEY) KEY2)))) a)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL a) KEY2))) (TOK_ORDERBY (TOK_TABLE_OR_COL KEY2)) (TOK_LIMIT 10)))
@@ -46,6 +53,12 @@
limit: 10
+query: SELECT a.KEY2
+FROM (SELECT INPUT4.*, INPUT4.KEY as KEY2
+ FROM INPUT4) a
+ORDER BY KEY2 LIMIT 10
+Input: default/input4
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/28774646/180991662.10000
0
0
0
@@ -56,3 +69,4 @@
103
104
104
+query: DROP TABLE INPUT4
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input2_limit.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input2_limit.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input2_limit.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input2_limit.q.out Tue May 5 22:17:36 2009
@@ -1,3 +1,5 @@
+query: EXPLAIN
+SELECT x.* FROM SRC x WHERE x.key < 300 LIMIT 5
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF SRC x)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF x))) (TOK_WHERE (< (. (TOK_TABLE_OR_COL x) key) 300)) (TOK_LIMIT 5)))
@@ -33,6 +35,9 @@
limit: 5
+query: SELECT x.* FROM SRC x WHERE x.key < 300 LIMIT 5
+Input: default/src
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/472205870/117610052.10000
238 val_238
86 val_86
27 val_27
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input3.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input3.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input3.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input3.q.out Tue May 5 22:17:36 2009
@@ -1,8 +1,16 @@
+query: DROP TABLE TEST3a
+query: DROP TABLE TEST3b
+query: DROP TABLE TEST3c
+query: CREATE TABLE TEST3a(A INT, B DOUBLE) STORED AS TEXTFILE
+query: DESCRIBE TEST3a
a int
b double
+query: CREATE TABLE TEST3b(A ARRAY<INT>, B DOUBLE, C MAP<DOUBLE, INT>) STORED AS TEXTFILE
+query: DESCRIBE TEST3b
a array<int>
b double
c map<double,int>
+query: SHOW TABLES
src
src1
src_json
@@ -12,6 +20,8 @@
srcpart
test3a
test3b
+query: EXPLAIN
+ALTER TABLE TEST3b ADD COLUMNS (X DOUBLE)
ABSTRACT SYNTAX TREE:
(TOK_ALTERTABLE_ADDCOLS TEST3b (TOK_TABCOLLIST (TOK_TABCOL X TOK_DOUBLE)))
@@ -27,10 +37,14 @@
old name: TEST3b
+query: ALTER TABLE TEST3b ADD COLUMNS (X DOUBLE)
+query: DESCRIBE TEST3b
a array<int>
b double
c map<double,int>
x double
+query: EXPLAIN
+ALTER TABLE TEST3b RENAME TO TEST3c
ABSTRACT SYNTAX TREE:
(TOK_ALTERTABLE_RENAME TEST3b TEST3c)
@@ -46,10 +60,13 @@
old name: TEST3b
+query: ALTER TABLE TEST3b RENAME TO TEST3c
+query: DESCRIBE TEST3c
a array<int>
b double
c map<double,int>
x double
+query: SHOW TABLES
src
src1
src_json
@@ -59,6 +76,8 @@
srcpart
test3a
test3c
+query: EXPLAIN
+ALTER TABLE TEST3c REPLACE COLUMNS (R1 INT, R2 DOUBLE)
ABSTRACT SYNTAX TREE:
(TOK_ALTERTABLE_REPLACECOLS TEST3c (TOK_TABCOLLIST (TOK_TABCOL R1 TOK_INT) (TOK_TABCOL R2 TOK_DOUBLE)))
@@ -74,7 +93,12 @@
old name: TEST3c
+query: ALTER TABLE TEST3c REPLACE COLUMNS (R1 INT, R2 DOUBLE)
+query: DESCRIBE EXTENDED TEST3c
r1 int
r2 double
-Detailed Table Information Table(tableName:test3c,dbName:default,owner:rmurthy,createTime:1238030229,lastAccessTime:0,retention:0,sd:StorageDescriptor(cols:[FieldSchema(name:r1,type:int,comment:null), FieldSchema(name:r2,type:double,comment:null)],location:file:/mnt/vol/devrs005.snc1/rmurthy/hive/build/ql/test/data/warehouse/test3b,inputFormat:org.apache.hadoop.mapred.TextInputFormat,outputFormat:org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat,compressed:false,numBuckets:-1,serdeInfo:SerDeInfo(name:null,serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe,parameters:{serialization.format=1}),bucketCols:[],sortCols:[],parameters:{}),partitionKeys:[],parameters:{last_modified_by=rmurthy,last_modified_time=1238030229})
+Detailed Table Information Table(tableName:test3c,dbName:default,owner:athusoo,createTime:1241278187,lastAccessTime:0,retention:0,sd:StorageDescriptor(cols:[FieldSchema(name:r1,type:int,comment:null), FieldSchema(name:r2,type:double,comment:null)],location:file:/data/users/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/test3b,inputFormat:org.apache.hadoop.mapred.TextInputFormat,outputFormat:org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat,compressed:false,numBuckets:-1,serdeInfo:SerDeInfo(name:null,serializationLib:org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe,parameters:{serialization.format=1}),bucketCols:[],sortCols:[],parameters:{}),partitionKeys:[],parameters:{last_modified_by=athusoo,last_modified_time=1241278187})
+query: DROP TABLE TEST3a
+query: DROP TABLE TEST3b
+query: DROP TABLE TEST3c
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input3_limit.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input3_limit.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input3_limit.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input3_limit.q.out Tue May 5 22:17:36 2009
@@ -1,3 +1,11 @@
+query: DROP TABLE T1
+query: CREATE TABLE T1(key STRING, value STRING) STORED AS TEXTFILE
+query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE T1
+query: LOAD DATA LOCAL INPATH '../data/files/kv2.txt' INTO TABLE T1
+query: DROP TABLE T2
+query: CREATE TABLE T2(key STRING, value STRING)
+query: EXPLAIN
+INSERT OVERWRITE TABLE T2 SELECT * FROM (SELECT * FROM T1 DISTRIBUTE BY key SORT BY key, value) T LIMIT 20
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF T1)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_DISTRIBUTEBY (TOK_TABLE_OR_COL key)) (TOK_SORTBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL key)) (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL value))))) T)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB T2)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_LIMIT 20)))
@@ -53,7 +61,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/zshao/tools/416-trunk-apache-hive/build/ql/tmp/349137289/427658357.10001
+ /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/11453942/21576323.10002
Reduce Output Operator
sort order:
tag: -1
@@ -85,6 +93,12 @@
name: t2
+query: INSERT OVERWRITE TABLE T2 SELECT * FROM (SELECT * FROM T1 DISTRIBUTE BY key SORT BY key, value) T LIMIT 20
+Input: default/t1
+Output: default/t2
+query: SELECT * FROM T2 SORT BY key, value
+Input: default/t2
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/177136935/1888963.10000
0 val_0
0 val_0
0 val_0
@@ -105,3 +119,5 @@
104 val_104
104 val_105
104 val_105
+query: DROP TABLE T1
+query: DROP TABLE T2
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input4.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input4.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input4.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input4.q.out Tue May 5 22:17:36 2009
@@ -1,3 +1,6 @@
+query: CREATE TABLE INPUT4(KEY STRING, VALUE STRING) STORED AS TEXTFILE
+query: EXPLAIN
+LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE INPUT4
ABSTRACT SYNTAX TREE:
(TOK_LOAD '../data/files/kv1.txt' (TOK_TAB INPUT4) LOCAL)
@@ -8,8 +11,8 @@
STAGE PLANS:
Stage: Stage-0
Copy
- source: file:/Users/char/Documents/workspace/Hive/data/files/kv1.txt
- destination: file:/Users/char/Documents/workspace/Hive/ql/../build/ql/tmp/-813016988
+ source: file:/data/users/athusoo/commits/hive_trunk_ws8/data/files/kv1.txt
+ destination: file:/data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/1051715073
Stage: Stage-1
Move Operator
@@ -22,6 +25,10 @@
name: input4
+query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE INPUT4
+query: SELECT INPUT4.VALUE, INPUT4.KEY FROM INPUT4
+Input: default/input4
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/4047701/256327496.10000
val_238 238
val_86 86
val_311 311
@@ -522,3 +529,4 @@
val_400 400
val_200 200
val_97 97
+query: DROP TABLE INPUT4
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input4_cb_delim.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input4_cb_delim.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input4_cb_delim.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input4_cb_delim.q.out Tue May 5 22:17:36 2009
@@ -1,3 +1,8 @@
+query: CREATE TABLE INPUT4_CB(KEY STRING, VALUE STRING) ROW FORMAT DELIMITED FIELDS TERMINATED BY '\002' LINES TERMINATED BY '\012' STORED AS TEXTFILE
+query: LOAD DATA LOCAL INPATH '../data/files/kv1_cb.txt' INTO TABLE INPUT4_CB
+query: SELECT INPUT4_CB.VALUE, INPUT4_CB.KEY FROM INPUT4_CB
+Input: default/input4_cb
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/45272155/119966499.10000
val_238 238
val_86 86
val_311 311
@@ -498,3 +503,4 @@
val_400 400
val_200 200
val_97 97
+query: DROP TABLE INPUT4_CB
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input4_limit.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input4_limit.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input4_limit.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input4_limit.q.out Tue May 5 22:17:36 2009
@@ -1,3 +1,5 @@
+query: explain
+select * from src sort by key limit 10
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF src)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR TOK_ALLCOLREF)) (TOK_SORTBY (TOK_TABSORTCOLNAMEASC (TOK_TABLE_OR_COL key))) (TOK_LIMIT 10)))
@@ -42,7 +44,7 @@
Stage: Stage-2
Map Reduce
Alias -> Map Operator Tree:
- /data/users/zshao/tools/416-trunk-apache-hive/build/ql/tmp/532000507/301674559.10002
+ /data/users/athusoo/commits/hive_trunk_ws8/build/ql/tmp/299272091/500299840.10002
Reduce Output Operator
key expressions:
expr: 0
@@ -69,6 +71,9 @@
limit: 10
+query: select * from src sort by key limit 10
+Input: default/src
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/132764629/1854197962.10000
0 val_0
0 val_0
0 val_0
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input5.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input5.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input5.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input5.q.out Tue May 5 22:17:36 2009
@@ -1,3 +1,12 @@
+query: CREATE TABLE dest1(key STRING, value STRING) STORED AS TEXTFILE
+query: EXPLAIN
+FROM (
+ FROM src_thrift
+ SELECT TRANSFORM(src_thrift.lint, src_thrift.lintstring)
+ USING '/bin/cat' AS (tkey, tvalue)
+ CLUSTER BY tkey
+) tmap
+INSERT OVERWRITE TABLE dest1 SELECT tmap.tkey, tmap.tvalue
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_SUBQUERY (TOK_QUERY (TOK_FROM (TOK_TABREF src_thrift)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_TRANSFORM (TOK_EXPLIST (. (TOK_TABLE_OR_COL src_thrift) lint) (. (TOK_TABLE_OR_COL src_thrift) lintstring)) '/bin/cat' (TOK_ALIASLIST tkey tvalue)))) (TOK_CLUSTERBY (TOK_TABLE_OR_COL tkey)))) tmap)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL tmap) tkey)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL tmap) tvalue)))))
@@ -69,6 +78,18 @@
name: dest1
+query: FROM (
+ FROM src_thrift
+ SELECT TRANSFORM(src_thrift.lint, src_thrift.lintstring)
+ USING '/bin/cat' AS (tkey, tvalue)
+ CLUSTER BY tkey
+) tmap
+INSERT OVERWRITE TABLE dest1 SELECT tmap.tkey, tmap.tvalue
+Input: default/src_thrift
+Output: default/dest1
+query: SELECT dest1.* FROM dest1
+Input: default/dest1
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/248520134/578564891.10000
[0,0,0] [{"myint":0,"mystring":"0"}]
[1,2,3] [{"myint":1,"mystring":"1"}]
[2,4,6] [{"myint":4,"mystring":"8"}]
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input6.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input6.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input6.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input6.q.out Tue May 5 22:17:36 2009
@@ -1,3 +1,7 @@
+query: CREATE TABLE dest1(key STRING, value STRING) STORED AS TEXTFILE
+query: EXPLAIN
+FROM src1
+INSERT OVERWRITE TABLE dest1 SELECT src1.key, src1.value WHERE src1.key is null
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF src1)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL src1) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL src1) value))) (TOK_WHERE (TOK_FUNCTION TOK_ISNULL (. (TOK_TABLE_OR_COL src1) key)))))
@@ -40,3 +44,10 @@
name: dest1
+query: FROM src1
+INSERT OVERWRITE TABLE dest1 SELECT src1.key, src1.value WHERE src1.key is null
+Input: default/src1
+Output: default/dest1
+query: SELECT dest1.* FROM dest1
+Input: default/dest1
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/541854784/3032139.10000
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input7.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input7.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input7.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input7.q.out Tue May 5 22:17:36 2009
@@ -1,3 +1,7 @@
+query: CREATE TABLE dest1(c1 DOUBLE, c2 INT) STORED AS TEXTFILE
+query: EXPLAIN
+FROM src1
+INSERT OVERWRITE TABLE dest1 SELECT NULL, src1.key
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF src1)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR TOK_NULL) (TOK_SELEXPR (. (TOK_TABLE_OR_COL src1) key)))))
@@ -46,6 +50,13 @@
name: dest1
+query: FROM src1
+INSERT OVERWRITE TABLE dest1 SELECT NULL, src1.key
+Input: default/src1
+Output: default/dest1
+query: SELECT dest1.* FROM dest1
+Input: default/dest1
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/412916640/832757248.10000
NULL 238
NULL NULL
NULL 311
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input8.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input8.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input8.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input8.q.out Tue May 5 22:17:36 2009
@@ -1,3 +1,7 @@
+query: CREATE TABLE dest1(c1 STRING, c2 INT, c3 DOUBLE) STORED AS TEXTFILE
+query: EXPLAIN
+FROM src1
+INSERT OVERWRITE TABLE dest1 SELECT 4 + NULL, src1.key - NULL, NULL + NULL
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF src1)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (+ 4 TOK_NULL)) (TOK_SELEXPR (- (. (TOK_TABLE_OR_COL src1) key) TOK_NULL)) (TOK_SELEXPR (+ TOK_NULL TOK_NULL)))))
@@ -50,6 +54,13 @@
name: dest1
+query: FROM src1
+INSERT OVERWRITE TABLE dest1 SELECT 4 + NULL, src1.key - NULL, NULL + NULL
+Input: default/src1
+Output: default/dest1
+query: SELECT dest1.* FROM dest1
+Input: default/dest1
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/746725763/14447488.10000
NULL NULL NULL
NULL NULL NULL
NULL NULL NULL
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input9.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input9.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input9.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input9.q.out Tue May 5 22:17:36 2009
@@ -1,3 +1,7 @@
+query: CREATE TABLE dest1(value STRING, key INT) STORED AS TEXTFILE
+query: EXPLAIN
+FROM src1
+INSERT OVERWRITE TABLE dest1 SELECT NULL, src1.key where NULL = NULL
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF src1)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR TOK_NULL) (TOK_SELEXPR (. (TOK_TABLE_OR_COL src1) key))) (TOK_WHERE (= TOK_NULL TOK_NULL))))
@@ -50,3 +54,10 @@
name: dest1
+query: FROM src1
+INSERT OVERWRITE TABLE dest1 SELECT NULL, src1.key where NULL = NULL
+Input: default/src1
+Output: default/dest1
+query: SELECT dest1.* FROM dest1
+Input: default/dest1
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/170480320/543316931.10000
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_columnarserde.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_columnarserde.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_columnarserde.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_columnarserde.q.out Tue May 5 22:17:36 2009
@@ -1,3 +1,13 @@
+query: drop table input_columnarserde
+query: CREATE TABLE input_columnarserde(a array<int>, b array<string>, c map<string,string>, d int, e string)
+ROW FORMAT SERDE
+ 'org.apache.hadoop.hive.serde2.columnar.ColumnarSerDe'
+STORED AS
+ INPUTFORMAT 'org.apache.hadoop.hive.ql.io.RCFileInputFormat'
+ OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.RCFileOutputFormat'
+query: EXPLAIN
+FROM src_thrift
+INSERT OVERWRITE TABLE input_columnarserde SELECT src_thrift.lint, src_thrift.lstring, src_thrift.mstringstring, src_thrift.aint, src_thrift.astring DISTRIBUTE BY 1
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF src_thrift)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB input_columnarserde)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL src_thrift) lint)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL src_thrift) lstring)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL src_thrift) mstringstring)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL src_thrift) aint)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL src_thrift) astring))) (TOK_DISTRIBUTEBY 1)))
@@ -73,6 +83,13 @@
name: input_columnarserde
+query: FROM src_thrift
+INSERT OVERWRITE TABLE input_columnarserde SELECT src_thrift.lint, src_thrift.lstring, src_thrift.mstringstring, src_thrift.aint, src_thrift.astring DISTRIBUTE BY 1
+Input: default/src_thrift
+Output: default/input_columnarserde
+query: SELECT input_columnarserde.* FROM input_columnarserde DISTRIBUTE BY 1
+Input: default/input_columnarserde
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/156914955/60209819.10000
[0,0,0] ["0","0","0"] {"key_0":"value_0"} 1712634731 record_0
[1,2,3] ["10","100","1000"] {"key_1":"value_1"} 465985200 record_1
[2,4,6] ["20","200","2000"] {"key_2":"value_2"} -751827638 record_2
@@ -84,6 +101,9 @@
[8,16,24] ["80","800","8000"] {"key_8":"value_8"} 1638581578 record_8
[9,18,27] ["90","900","9000"] {"key_9":"value_9"} 336964413 record_9
null null {} 0 NULL
+query: SELECT input_columnarserde.a[0], input_columnarserde.b[0], input_columnarserde.c['key2'], input_columnarserde.d, input_columnarserde.e FROM input_columnarserde DISTRIBUTE BY 1
+Input: default/input_columnarserde
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/92131046/797096690.10000
0 0 NULL 1712634731 record_0
1 10 NULL 465985200 record_1
2 20 NULL -751827638 record_2
@@ -95,3 +115,4 @@
8 80 NULL 1638581578 record_8
9 90 NULL 336964413 record_9
NULL NULL NULL 0 NULL
+query: drop table input_columnarserde
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_dynamicserde.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_dynamicserde.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_dynamicserde.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_dynamicserde.q.out Tue May 5 22:17:36 2009
@@ -1,3 +1,13 @@
+query: CREATE TABLE dest1(a array<int>, b array<string>, c map<string,string>, d int, e string)
+ROW FORMAT DELIMITED
+FIELDS TERMINATED BY '1'
+COLLECTION ITEMS TERMINATED BY '2'
+MAP KEYS TERMINATED BY '3'
+LINES TERMINATED BY '10'
+STORED AS TEXTFILE
+query: EXPLAIN
+FROM src_thrift
+INSERT OVERWRITE TABLE dest1 SELECT src_thrift.lint, src_thrift.lstring, src_thrift.mstringstring, src_thrift.aint, src_thrift.astring
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF src_thrift)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL src_thrift) lint)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL src_thrift) lstring)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL src_thrift) mstringstring)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL src_thrift) aint)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL src_thrift) astring)))))
@@ -54,6 +64,13 @@
name: dest1
+query: FROM src_thrift
+INSERT OVERWRITE TABLE dest1 SELECT src_thrift.lint, src_thrift.lstring, src_thrift.mstringstring, src_thrift.aint, src_thrift.astring
+Input: default/src_thrift
+Output: default/dest1
+query: SELECT dest1.* FROM dest1
+Input: default/dest1
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/1346296798/44273868.10000
[0,0,0] ["0","0","0"] {"key_0":"value_0"} 1712634731 record_0
[1,2,3] ["10","100","1000"] {"key_1":"value_1"} 465985200 record_1
[2,4,6] ["20","200","2000"] {"key_2":"value_2"} -751827638 record_2
@@ -65,6 +82,9 @@
[8,16,24] ["80","800","8000"] {"key_8":"value_8"} 1638581578 record_8
[9,18,27] ["90","900","9000"] {"key_9":"value_9"} 336964413 record_9
null null null 0 NULL
+query: SELECT dest1.a[0], dest1.b[0], dest1.c['key2'], dest1.d, dest1.e FROM dest1
+Input: default/dest1
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/373980247/133405459.10000
0 0 NULL 1712634731 record_0
1 10 NULL 465985200 record_1
2 20 NULL -751827638 record_2
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_lazyserde.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_lazyserde.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_lazyserde.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_lazyserde.q.out Tue May 5 22:17:36 2009
@@ -1,3 +1,13 @@
+query: CREATE TABLE dest1(a array<int>, b array<string>, c map<string,string>, d int, e string)
+ROW FORMAT DELIMITED
+FIELDS TERMINATED BY '1'
+COLLECTION ITEMS TERMINATED BY '2'
+MAP KEYS TERMINATED BY '3'
+LINES TERMINATED BY '10'
+STORED AS TEXTFILE
+query: EXPLAIN
+FROM src_thrift
+INSERT OVERWRITE TABLE dest1 SELECT src_thrift.lint, src_thrift.lstring, src_thrift.mstringstring, src_thrift.aint, src_thrift.astring DISTRIBUTE BY 1
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF src_thrift)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL src_thrift) lint)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL src_thrift) lstring)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL src_thrift) mstringstring)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL src_thrift) aint)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL src_thrift) astring))) (TOK_DISTRIBUTEBY 1)))
@@ -73,6 +83,13 @@
name: dest1
+query: FROM src_thrift
+INSERT OVERWRITE TABLE dest1 SELECT src_thrift.lint, src_thrift.lstring, src_thrift.mstringstring, src_thrift.aint, src_thrift.astring DISTRIBUTE BY 1
+Input: default/src_thrift
+Output: default/dest1
+query: SELECT dest1.* FROM dest1 DISTRIBUTE BY 1
+Input: default/dest1
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/1171779134/134105295.10000
[0,0,0] ["0","0","0"] {"key_0":"value_0"} 1712634731 record_0
[1,2,3] ["10","100","1000"] {"key_1":"value_1"} 465985200 record_1
[2,4,6] ["20","200","2000"] {"key_2":"value_2"} -751827638 record_2
@@ -84,6 +101,9 @@
[8,16,24] ["80","800","8000"] {"key_8":"value_8"} 1638581578 record_8
[9,18,27] ["90","900","9000"] {"key_9":"value_9"} 336964413 record_9
null null null 0 NULL
+query: SELECT dest1.a[0], dest1.b[0], dest1.c['key2'], dest1.d, dest1.e FROM dest1 DISTRIBUTE BY 1
+Input: default/dest1
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/89505780/102961275.10000
0 0 NULL 1712634731 record_0
1 10 NULL 465985200 record_1
2 20 NULL -751827638 record_2
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_limit.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_limit.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_limit.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_limit.q.out Tue May 5 22:17:36 2009
@@ -1,3 +1,5 @@
+query: EXPLAIN
+SELECT x.* FROM SRC x LIMIT 20
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF SRC x)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF x))) (TOK_LIMIT 20)))
@@ -10,6 +12,9 @@
limit: 20
+query: SELECT x.* FROM SRC x LIMIT 20
+Input: default/src
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/97124224/82396056.10000
238 val_238
86 val_86
311 val_311
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part0.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part0.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part0.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part0.q.out Tue May 5 22:17:36 2009
@@ -1,3 +1,5 @@
+query: EXPLAIN
+SELECT x.* FROM SRCPART x WHERE x.ds = '2008-04-08'
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF SRCPART x)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF x))) (TOK_WHERE (= (. (TOK_TABLE_OR_COL x) ds) '2008-04-08'))))
@@ -10,6 +12,10 @@
limit: -1
+query: SELECT x.* FROM SRCPART x WHERE x.ds = '2008-04-08'
+Input: default/srcpart/ds=2008-04-08/hr=11
+Input: default/srcpart/ds=2008-04-08/hr=12
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/215109247/3430598.10000
238 val_238 2008-04-08 11
86 val_86 2008-04-08 11
311 val_311 2008-04-08 11
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part1.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part1.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part1.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part1.q.out Tue May 5 22:17:36 2009
@@ -1,3 +1,7 @@
+query: CREATE TABLE dest1(key INT, value STRING, hr STRING, ds STRING) STORED AS TEXTFILE
+query: EXPLAIN EXTENDED
+FROM srcpart
+INSERT OVERWRITE TABLE dest1 SELECT srcpart.key, srcpart.value, srcpart.hr, srcpart.ds WHERE srcpart.key < 100 and srcpart.ds = '2008-04-08' and srcpart.hr = '12'
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF srcpart)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL srcpart) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL srcpart) value)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL srcpart) hr)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL srcpart) ds))) (TOK_WHERE (and (and (< (. (TOK_TABLE_OR_COL srcpart) key) 100) (= (. (TOK_TABLE_OR_COL srcpart) ds) '2008-04-08')) (= (. (TOK_TABLE_OR_COL srcpart) hr) '12')))))
@@ -37,7 +41,7 @@
File Output Operator
compressed: false
GlobalTableId: 1
- directory: /data/users/zshao/tools/416-trunk-apache-hive/ql/../build/ql/tmp/1015869899/511155619.10000.insclause-0
+ directory: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/193974541/25724604.10000.insclause-0
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -51,14 +55,14 @@
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/zshao/tools/416-trunk-apache-hive/build/ql/test/data/warehouse/dest1
+ location file:/data/users/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/dest1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
Needs Tagging: false
Path -> Alias:
- file:/data/users/zshao/tools/416-trunk-apache-hive/build/ql/test/data/warehouse/srcpart/hr=12/ds=2008-04-08
+ file:/data/users/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Path -> Partition:
- file:/data/users/zshao/tools/416-trunk-apache-hive/build/ql/test/data/warehouse/srcpart/hr=12/ds=2008-04-08
+ file:/data/users/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Partition
partition values:
ds 2008-04-08
@@ -77,7 +81,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/zshao/tools/416-trunk-apache-hive/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
@@ -85,7 +89,7 @@
Move Operator
tables:
replace: true
- source: /data/users/zshao/tools/416-trunk-apache-hive/ql/../build/ql/tmp/1015869899/511155619.10000.insclause-0
+ source: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/193974541/25724604.10000.insclause-0
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -99,11 +103,19 @@
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/zshao/tools/416-trunk-apache-hive/build/ql/test/data/warehouse/dest1
+ location file:/data/users/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/dest1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
+ tmp directory: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/193974541/25724604.10001
+query: FROM srcpart
+INSERT OVERWRITE TABLE dest1 SELECT srcpart.key, srcpart.value, srcpart.hr, srcpart.ds WHERE srcpart.key < 100 and srcpart.ds = '2008-04-08' and srcpart.hr = '12'
+Input: default/srcpart/ds=2008-04-08/hr=12
+Output: default/dest1
+query: SELECT dest1.* FROM dest1
+Input: default/dest1
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/405215409/117459934.10000
86 val_86 12 2008-04-08
27 val_27 12 2008-04-08
98 val_98 12 2008-04-08
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part2.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part2.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part2.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part2.q.out Tue May 5 22:17:36 2009
@@ -1,3 +1,9 @@
+query: CREATE TABLE dest1(key INT, value STRING, hr STRING, ds STRING) STORED AS TEXTFILE
+query: CREATE TABLE dest2(key INT, value STRING, hr STRING, ds STRING) STORED AS TEXTFILE
+query: EXPLAIN EXTENDED
+FROM srcpart
+INSERT OVERWRITE TABLE dest1 SELECT srcpart.key, srcpart.value, srcpart.hr, srcpart.ds WHERE srcpart.key < 100 and srcpart.ds = '2008-04-08' and srcpart.hr = '12'
+INSERT OVERWRITE TABLE dest2 SELECT srcpart.key, srcpart.value, srcpart.hr, srcpart.ds WHERE srcpart.key < 100 and srcpart.ds = '2008-04-09' and srcpart.hr = '12'
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF srcpart)) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest1)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL srcpart) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL srcpart) value)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL srcpart) hr)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL srcpart) ds))) (TOK_WHERE (and (and (< (. (TOK_TABLE_OR_COL srcpart) key) 100) (= (. (TOK_TABLE_OR_COL srcpart) ds) '2008-04-08')) (= (. (TOK_TABLE_OR_COL srcpart) hr) '12')))) (TOK_INSERT (TOK_DESTINATION (TOK_TAB dest2)) (TOK_SELECT (TOK_SELEXPR (. (TOK_TABLE_OR_COL srcpart) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL srcpart) value)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL srcpart) hr)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL srcpart) ds))) (TOK_WHERE (and (and (< (. (TOK_TABLE_OR_COL srcpart) key) 100) (= (. (TOK_TABLE_OR_COL srcpart) ds) '2008-04-09')) (= (. (TOK_TABLE_OR_COL srcpart) hr) '12')))))
@@ -37,7 +43,7 @@
File Output Operator
compressed: false
GlobalTableId: 1
- directory: /data/users/zshao/tools/416-trunk-apache-hive/ql/../build/ql/tmp/587562230/341514108.10000.insclause-0
+ directory: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/207197850/1525735017.10000.insclause-0
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -51,7 +57,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/zshao/tools/416-trunk-apache-hive/build/ql/test/data/warehouse/dest1
+ location file:/data/users/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/dest1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
Filter Operator
@@ -81,7 +87,7 @@
File Output Operator
compressed: false
GlobalTableId: 2
- directory: /data/users/zshao/tools/416-trunk-apache-hive/ql/../build/ql/tmp/587562230/341514108.10001.insclause-1
+ directory: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/207197850/1525735017.10002.insclause-1
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -95,15 +101,15 @@
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/zshao/tools/416-trunk-apache-hive/build/ql/test/data/warehouse/dest2
+ location file:/data/users/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/dest2
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest2
Needs Tagging: false
Path -> Alias:
- file:/data/users/zshao/tools/416-trunk-apache-hive/build/ql/test/data/warehouse/srcpart/hr=12/ds=2008-04-08
- file:/data/users/zshao/tools/416-trunk-apache-hive/build/ql/test/data/warehouse/srcpart/hr=12/ds=2008-04-09
+ file:/data/users/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
+ file:/data/users/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12
Path -> Partition:
- file:/data/users/zshao/tools/416-trunk-apache-hive/build/ql/test/data/warehouse/srcpart/hr=12/ds=2008-04-08
+ file:/data/users/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/srcpart/ds=2008-04-08/hr=12
Partition
partition values:
ds 2008-04-08
@@ -122,10 +128,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/zshao/tools/416-trunk-apache-hive/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
- file:/data/users/zshao/tools/416-trunk-apache-hive/build/ql/test/data/warehouse/srcpart/hr=12/ds=2008-04-09
+ file:/data/users/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/srcpart/ds=2008-04-09/hr=12
Partition
partition values:
ds 2008-04-09
@@ -144,7 +150,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/zshao/tools/416-trunk-apache-hive/build/ql/test/data/warehouse/srcpart
+ location file:/data/users/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/srcpart
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: srcpart
@@ -152,7 +158,7 @@
Move Operator
tables:
replace: true
- source: /data/users/zshao/tools/416-trunk-apache-hive/ql/../build/ql/tmp/587562230/341514108.10000.insclause-0
+ source: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/207197850/1525735017.10000.insclause-0
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -166,11 +172,12 @@
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/zshao/tools/416-trunk-apache-hive/build/ql/test/data/warehouse/dest1
+ location file:/data/users/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/dest1
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest1
+ tmp directory: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/207197850/1525735017.10001
replace: true
- source: /data/users/zshao/tools/416-trunk-apache-hive/ql/../build/ql/tmp/587562230/341514108.10001.insclause-1
+ source: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/207197850/1525735017.10002.insclause-1
table:
input format: org.apache.hadoop.mapred.TextInputFormat
output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
@@ -184,11 +191,22 @@
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/zshao/tools/416-trunk-apache-hive/build/ql/test/data/warehouse/dest2
+ location file:/data/users/athusoo/commits/hive_trunk_ws8/build/ql/test/data/warehouse/dest2
serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
name: dest2
+ tmp directory: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/207197850/1525735017.10003
+query: FROM srcpart
+INSERT OVERWRITE TABLE dest1 SELECT srcpart.key, srcpart.value, srcpart.hr, srcpart.ds WHERE srcpart.key < 100 and srcpart.ds = '2008-04-08' and srcpart.hr = '12'
+INSERT OVERWRITE TABLE dest2 SELECT srcpart.key, srcpart.value, srcpart.hr, srcpart.ds WHERE srcpart.key < 100 and srcpart.ds = '2008-04-09' and srcpart.hr = '12'
+Input: default/srcpart/ds=2008-04-08/hr=12
+Input: default/srcpart/ds=2008-04-09/hr=12
+Output: default/dest1
+Output: default/dest2
+query: SELECT dest1.* FROM dest1
+Input: default/dest1
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/70176811/211325652.10000
86 val_86 12 2008-04-08
27 val_27 12 2008-04-08
98 val_98 12 2008-04-08
@@ -273,6 +291,9 @@
37 val_37 12 2008-04-08
90 val_90 12 2008-04-08
97 val_97 12 2008-04-08
+query: SELECT dest2.* FROM dest2
+Input: default/dest2
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/683955421/596380888.10000
86 val_86 12 2008-04-09
27 val_27 12 2008-04-09
98 val_98 12 2008-04-09
@@ -357,3 +378,4 @@
37 val_37 12 2008-04-09
90 val_90 12 2008-04-09
97 val_97 12 2008-04-09
+query: drop table dest2
Modified: hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part3.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part3.q.out?rev=771990&r1=771989&r2=771990&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part3.q.out (original)
+++ hadoop/hive/trunk/ql/src/test/results/clientpositive/input_part3.q.out Tue May 5 22:17:36 2009
@@ -1,3 +1,5 @@
+query: EXPLAIN
+SELECT x.* FROM SRCPART x WHERE x.ds = '2008-04-08' and x.hr = 11
ABSTRACT SYNTAX TREE:
(TOK_QUERY (TOK_FROM (TOK_TABREF SRCPART x)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_ALLCOLREF x))) (TOK_WHERE (and (= (. (TOK_TABLE_OR_COL x) ds) '2008-04-08') (= (. (TOK_TABLE_OR_COL x) hr) 11)))))
@@ -10,6 +12,9 @@
limit: -1
+query: SELECT x.* FROM SRCPART x WHERE x.ds = '2008-04-08' and x.hr = 11
+Input: default/srcpart/ds=2008-04-08/hr=11
+Output: /data/users/athusoo/commits/hive_trunk_ws8/ql/../build/ql/tmp/196507728/1475419403.10000
238 val_238 2008-04-08 11
86 val_86 2008-04-08 11
311 val_311 2008-04-08 11