Author: hashutosh
Date: Sun Jun 2 23:54:12 2013
New Revision: 1488812
URL: http://svn.apache.org/r1488812
Log:
HIVE-4626 : join_vc.q is not deterministic (Navis via Ashutosh Chauhan)
Modified:
hive/trunk/ql/src/test/queries/clientpositive/join_vc.q
hive/trunk/ql/src/test/results/clientpositive/join_vc.q.out
Modified: hive/trunk/ql/src/test/queries/clientpositive/join_vc.q
URL:
http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/join_vc.q?rev=1488812&r1=1488811&r2=1488812&view=diff
==============================================================================
--- hive/trunk/ql/src/test/queries/clientpositive/join_vc.q (original)
+++ hive/trunk/ql/src/test/queries/clientpositive/join_vc.q Sun Jun 2 23:54:12
2013
@@ -1,5 +1,5 @@
-- see HIVE-4033 earlier a flag named hasVC was not initialized correctly in
MapOperator.java, resulting in NPE for following query. order by and limit in
the query is not relevant, problem would be evident even without those. They
are there to keep .q.out file small and sorted.
-explain select t3.BLOCK__OFFSET__INSIDE__FILE,t3.key,t3.value from src t1 join
src t2 on t1.key = t2.key join src t3 on t2.value = t3.value order by t3.value
limit 3;
+explain select t3.BLOCK__OFFSET__INSIDE__FILE,t3.key,t3.value from src t1 join
src t2 on t1.key = t2.key join src t3 on t2.value = t3.value order by
t3.BLOCK__OFFSET__INSIDE__FILE,t3.key,t3.value limit 3;
-select t3.BLOCK__OFFSET__INSIDE__FILE,t3.key,t3.value from src t1 join src t2
on t1.key = t2.key join src t3 on t2.value = t3.value order by t3.value limit 3;
+select t3.BLOCK__OFFSET__INSIDE__FILE,t3.key,t3.value from src t1 join src t2
on t1.key = t2.key join src t3 on t2.value = t3.value order by
t3.BLOCK__OFFSET__INSIDE__FILE,t3.key,t3.value limit 3;
Modified: hive/trunk/ql/src/test/results/clientpositive/join_vc.q.out
URL:
http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/join_vc.q.out?rev=1488812&r1=1488811&r2=1488812&view=diff
==============================================================================
--- hive/trunk/ql/src/test/results/clientpositive/join_vc.q.out (original)
+++ hive/trunk/ql/src/test/results/clientpositive/join_vc.q.out Sun Jun 2
23:54:12 2013
@@ -1,13 +1,13 @@
PREHOOK: query: -- see HIVE-4033 earlier a flag named hasVC was not
initialized correctly in MapOperator.java, resulting in NPE for following
query. order by and limit in the query is not relevant, problem would be
evident even without those. They are there to keep .q.out file small and sorted.
-explain select t3.BLOCK__OFFSET__INSIDE__FILE,t3.key,t3.value from src t1 join
src t2 on t1.key = t2.key join src t3 on t2.value = t3.value order by t3.value
limit 3
+explain select t3.BLOCK__OFFSET__INSIDE__FILE,t3.key,t3.value from src t1 join
src t2 on t1.key = t2.key join src t3 on t2.value = t3.value order by
t3.BLOCK__OFFSET__INSIDE__FILE,t3.key,t3.value limit 3
PREHOOK: type: QUERY
POSTHOOK: query: -- see HIVE-4033 earlier a flag named hasVC was not
initialized correctly in MapOperator.java, resulting in NPE for following
query. order by and limit in the query is not relevant, problem would be
evident even without those. They are there to keep .q.out file small and sorted.
-explain select t3.BLOCK__OFFSET__INSIDE__FILE,t3.key,t3.value from src t1 join
src t2 on t1.key = t2.key join src t3 on t2.value = t3.value order by t3.value
limit 3
+explain select t3.BLOCK__OFFSET__INSIDE__FILE,t3.key,t3.value from src t1 join
src t2 on t1.key = t2.key join src t3 on t2.value = t3.value order by
t3.BLOCK__OFFSET__INSIDE__FILE,t3.key,t3.value limit 3
POSTHOOK: type: QUERY
ABSTRACT SYNTAX TREE:
- (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_JOIN (TOK_TABREF (TOK_TABNAME src) t1)
(TOK_TABREF (TOK_TABNAME src) t2) (= (. (TOK_TABLE_OR_COL t1) key) (.
(TOK_TABLE_OR_COL t2) key))) (TOK_TABREF (TOK_TABNAME src) t3) (= (.
(TOK_TABLE_OR_COL t2) value) (. (TOK_TABLE_OR_COL t3) value)))) (TOK_INSERT
(TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (.
(TOK_TABLE_OR_COL t3) BLOCK__OFFSET__INSIDE__FILE)) (TOK_SELEXPR (.
(TOK_TABLE_OR_COL t3) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL t3) value)))
(TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL t3) value)))
(TOK_LIMIT 3)))
+ (TOK_QUERY (TOK_FROM (TOK_JOIN (TOK_JOIN (TOK_TABREF (TOK_TABNAME src) t1)
(TOK_TABREF (TOK_TABNAME src) t2) (= (. (TOK_TABLE_OR_COL t1) key) (.
(TOK_TABLE_OR_COL t2) key))) (TOK_TABREF (TOK_TABNAME src) t3) (= (.
(TOK_TABLE_OR_COL t2) value) (. (TOK_TABLE_OR_COL t3) value)))) (TOK_INSERT
(TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (.
(TOK_TABLE_OR_COL t3) BLOCK__OFFSET__INSIDE__FILE)) (TOK_SELEXPR (.
(TOK_TABLE_OR_COL t3) key)) (TOK_SELEXPR (. (TOK_TABLE_OR_COL t3) value)))
(TOK_ORDERBY (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL t3)
BLOCK__OFFSET__INSIDE__FILE)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL t3)
key)) (TOK_TABSORTCOLNAMEASC (. (TOK_TABLE_OR_COL t3) value))) (TOK_LIMIT 3)))
STAGE DEPENDENCIES:
Stage-3 is a root stage
@@ -125,9 +125,13 @@ STAGE PLANS:
#### A masked pattern was here ####
Reduce Output Operator
key expressions:
+ expr: _col0
+ type: bigint
+ expr: _col1
+ type: string
expr: _col2
type: string
- sort order: +
+ sort order: +++
tag: -1
value expressions:
expr: _col0
@@ -151,14 +155,14 @@ STAGE PLANS:
limit: 3
-PREHOOK: query: select t3.BLOCK__OFFSET__INSIDE__FILE,t3.key,t3.value from src
t1 join src t2 on t1.key = t2.key join src t3 on t2.value = t3.value order by
t3.value limit 3
+PREHOOK: query: select t3.BLOCK__OFFSET__INSIDE__FILE,t3.key,t3.value from src
t1 join src t2 on t1.key = t2.key join src t3 on t2.value = t3.value order by
t3.BLOCK__OFFSET__INSIDE__FILE,t3.key,t3.value limit 3
PREHOOK: type: QUERY
PREHOOK: Input: default@src
#### A masked pattern was here ####
-POSTHOOK: query: select t3.BLOCK__OFFSET__INSIDE__FILE,t3.key,t3.value from
src t1 join src t2 on t1.key = t2.key join src t3 on t2.value = t3.value order
by t3.value limit 3
+POSTHOOK: query: select t3.BLOCK__OFFSET__INSIDE__FILE,t3.key,t3.value from
src t1 join src t2 on t1.key = t2.key join src t3 on t2.value = t3.value order
by t3.BLOCK__OFFSET__INSIDE__FILE,t3.key,t3.value limit 3
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
-2088 0 val_0
-2632 0 val_0
-968 0 val_0
+0 238 val_238
+0 238 val_238
+0 238 val_238
