Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
-
None
Description
one of these out files have changed for me...and it turned out that it's not clear which output should be the expected; since we have different version recorded 
for the last query in vector_decimal_mapjoin.q ; spark and clidriver gives 1 result; in the meanwhile llap returns a whole bunch of results.
$ tail `find ql -name vector_decimal_mapjoin.q.out` ==> ql/src/test/results/clientpositive/vector_decimal_mapjoin.q.out <== PREHOOK: type: QUERY PREHOOK: Input: default@t1_small PREHOOK: Input: default@t2_small #### A masked pattern was here #### POSTHOOK: query: select t1_small.`dec`, t1_small.value_dec, t2_small.`dec`, t2_small.value_dec from t1_small join t2_small on (t1_small.`dec`=t2_small.`dec`) POSTHOOK: type: QUERY POSTHOOK: Input: default@t1_small POSTHOOK: Input: default@t2_small #### A masked pattern was here #### 89.00 15.09 89 15 ==> ql/src/test/results/clientpositive/llap/vector_decimal_mapjoin.q.out <== 9.00 48.96 9 34 9.00 48.96 9 38 9.00 48.96 9 41 9.00 48.96 9 42 9.00 48.96 9 45 9.00 48.96 9 48 9.00 48.96 9 49 9.00 48.96 9 5 9.00 48.96 9 7 9.00 48.96 9 7 ==> ql/src/test/results/clientpositive/spark/vector_decimal_mapjoin.q.out <== PREHOOK: type: QUERY PREHOOK: Input: default@t1_small PREHOOK: Input: default@t2_small #### A masked pattern was here #### POSTHOOK: query: select t1_small.`dec`, t1_small.value_dec, t2_small.`dec`, t2_small.value_dec from t1_small join t2_small on (t1_small.`dec`=t2_small.`dec`) POSTHOOK: type: QUERY POSTHOOK: Input: default@t1_small POSTHOOK: Input: default@t2_small #### A masked pattern was here #### 89.00 15.09 89 15
I think the TestClidriver based one can be "changed" to the other result; by setting hive.stats.column.autogather=true.