[jira] [Commented] (IMPALA-5950) Impala's TPC-DS results for Q35a and Q48 in test environment don't match results from TPC-DS tools

["Tim Armstrong (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/IMPALA-5950?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16669440#comment-16669440 ] 

Tim Armstrong commented on IMPALA-5950:
---------------------------------------

For q35a, the results match the contents of my customer table in my dev env. I.e. if other systems are getting different results, it appears to be because the underlying data is different.

For q48, I ran the same query on Hive and got the same result, which also suggests the difference stems from the data rather than Impala.

> Impala's TPC-DS results for Q35a and Q48 in test environment don't match results from TPC-DS tools
> --------------------------------------------------------------------------------------------------
>
>                 Key: IMPALA-5950
>                 URL: https://issues.apache.org/jira/browse/IMPALA-5950
>             Project: IMPALA
>          Issue Type: Bug
>          Components: Backend
>    Affects Versions: Impala 2.10.0
>            Reporter: Tim Wood
>            Assignee: Tim Armstrong
>            Priority: Major
>         Attachments: pre-review-consoleText, profile-tpcds-q48-asf-impala-874a1158972.html, ttq-218.out, ttq-286.out
>
>
> Results of q35a (in ttq.218.out) disagree with same query run on Postgres, Vertica and Netezza.
> Results of q48 disagree with expected TPC-DS result data.  Q48 was passing for a long time, then this _intermittent_ failure began occurring at least by 10/5/2017, 16:17PT on Jenkins--see attached pre-review-consoleText.
> https://github.com/gregrahn/tpcds-kit/tree/master/answer_sets



--
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