You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Zoltan Haindrich (JIRA)" <ji...@apache.org> on 2017/12/05 17:40:00 UTC
[jira] [Created] (HIVE-18225) disaggreement in results;
vector_decimal_mapjoin.q
Zoltan Haindrich created HIVE-18225:
---------------------------------------
Summary: disaggreement in results; vector_decimal_mapjoin.q
Key: HIVE-18225
URL: https://issues.apache.org/jira/browse/HIVE-18225
Project: Hive
Issue Type: Bug
Reporter: Zoltan Haindrich
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 :D
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.
{code}
$ 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
{code}
I think the TestClidriver based one can be "changed" to the other result; by setting {{hive.stats.column.autogather=true}}.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)