You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "ASF subversion and git services (JIRA)" <ji...@apache.org> on 2018/11/02 22:13:01 UTC
[jira] [Commented] (IMPALA-5956) Add TPC-DS q31 and q89 to test
suite
[ https://issues.apache.org/jira/browse/IMPALA-5956?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16673746#comment-16673746 ]
ASF subversion and git services commented on IMPALA-5956:
---------------------------------------------------------
Commit f876b320aae3ea657b1cd937a68b56e9b281a9f8 in impala's branch refs/heads/master from [~tarmstrong@cloudera.com]
[ https://git-wip-us.apache.org/repos/asf?p=impala.git;h=f876b32 ]
IMPALA-5946,IMPALA-5956: add TPC-DS q31,q59,q89
Q31: the substitution variables didn't match the TPC-DS spec.
After fixing this, the results match up to 4 digits of
rounding (there is some error introduced in intermediate
calculations).
Q59: the results match the reference results up to rounding.
Q89: the results match up to 5 digits of rounding.
I verified the matches by using a spreadsheet comparing reference
and actual results.
https://docs.google.com/spreadsheets/d/1MNEqkfYRRAd3xqY6m20tTHquqjtCThDaGdizzRAQ8co/edit?usp=sharing
*https://github.com/gregrahn/tpcds-kit/blob/master/specification/TPC-DS_v2.10.0.pdf
^https://github.com/gregrahn/tpcds-kit/tree/master/answer_sets
Change-Id: I49634e8f63066773c9c78dd5585a0ee69daf720a
Reviewed-on: http://gerrit.cloudera.org:8080/11845
Reviewed-by: Impala Public Jenkins <im...@cloudera.com>
Tested-by: Impala Public Jenkins <im...@cloudera.com>
> Add TPC-DS q31 and q89 to test suite
> ------------------------------------
>
> Key: IMPALA-5956
> URL: https://issues.apache.org/jira/browse/IMPALA-5956
> Project: IMPALA
> Issue Type: Bug
> Components: Infrastructure
> Reporter: Tim Wood
> Assignee: Tim Armstrong
> Priority: Major
> Labels: tpcds
> Fix For: Impala 3.2.0
>
> Attachments: q59-flap.out, q89-flap1.out, q89-flap2.out, ttq-243.out, ttq-256.out
>
>
> When run esp. as part of the TPC-DS suite, query #89 returns varying results in the LSD of a calculation. Using the output of the previous run as the expected result for the next run fails. This SELECT item is a ROUND() expression, so it's not clear why the result is not deterministic.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org