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/01 16:05:01 UTC

[jira] [Commented] (IMPALA-5950) Q35a and Q48 test files don't match standard qualification queries

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

ASF subversion and git services commented on IMPALA-5950:
---------------------------------------------------------

Commit e3a702707cb60b4e127215b99ab4e6945cedcd1f in impala's branch refs/heads/master from [~tarmstrong@cloudera.com]
[ https://git-wip-us.apache.org/repos/asf?p=impala.git;h=e3a7027 ]

IMPALA-5950: fix TPC-DS Q35a and Q48 queries

The query text (for Q48) and substitution parameters didn't match the
TPC-DS standard for qualification queries. After fixing that, the
queries return the results expected by the TPC-DS standards.

Note that this may affect the performance of perf workloads running
tpcds-unmodified.

Change-Id: Ic7c737f68adf616738d6eb6e5a02593af25bcbaf
Reviewed-on: http://gerrit.cloudera.org:8080/11833
Reviewed-by: Impala Public Jenkins <im...@cloudera.com>
Tested-by: Impala Public Jenkins <im...@cloudera.com>


> Q35a and Q48 test files don't match standard qualification queries
> ------------------------------------------------------------------
>
>                 Key: IMPALA-5950
>                 URL: https://issues.apache.org/jira/browse/IMPALA-5950
>             Project: IMPALA
>          Issue Type: Bug
>          Components: Infrastructure
>    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