[
https://issues.apache.org/jira/browse/IMPALA-5946?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16673745#comment-16673745
]
ASF subversion and git services commented on IMPALA-5946:
---------------------------------------------------------
Commit f876b320aae3ea657b1cd937a68b56e9b281a9f8 in impala's branch
refs/heads/master from [[email protected]]
[ 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 <[email protected]>
Tested-by: Impala Public Jenkins <[email protected]>
> Add TPC-DS Q58 to functional tests
> ----------------------------------
>
> Key: IMPALA-5946
> URL: https://issues.apache.org/jira/browse/IMPALA-5946
> Project: IMPALA
> Issue Type: Test
> Components: Infrastructure
> Affects Versions: Impala 2.10.0
> Reporter: Tim Wood
> Assignee: Tim Armstrong
> Priority: Major
> Labels: TPCDS, decimal
> Fix For: Impala 3.2.0
>
> Attachments: ttq-212.out, ttq-214.out
>
>
> Because of our decimal_v2 rounding rules, the results lack some precision of
> the reference answers.
> Original description
> bq. See attached query (tpcds-q58.test) + outputs. ttq-212.out uses float
> constants in expressions, ttq-214.out uses integer constants. Both lose
> precision.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
