Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 15C85200CF7 for ; Tue, 19 Sep 2017 21:19:45 +0200 (CEST) Received: by cust-asf.ponee.io (Postfix) id 143D01609DD; Tue, 19 Sep 2017 19:19:45 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 31F8E1609BF for ; Tue, 19 Sep 2017 21:19:44 +0200 (CEST) Received: (qmail 63762 invoked by uid 500); 19 Sep 2017 19:19:43 -0000 Mailing-List: contact reviews-help@impala.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Delivered-To: mailing list reviews@impala.incubator.apache.org Received: (qmail 63751 invoked by uid 99); 19 Sep 2017 19:19:43 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd2-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 19 Sep 2017 19:19:43 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd2-us-west.apache.org (ASF Mail Server at spamd2-us-west.apache.org) with ESMTP id AB1511A0ACC for ; Tue, 19 Sep 2017 19:19:42 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd2-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 0.363 X-Spam-Level: X-Spam-Status: No, score=0.363 tagged_above=-999 required=6.31 tests=[RDNS_DYNAMIC=0.363, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd2-us-west.apache.org [10.40.0.9]) (amavisd-new, port 10024) with ESMTP id xNIavf9iAE5M for ; Tue, 19 Sep 2017 19:19:40 +0000 (UTC) Received: from ip-10-146-233-104.ec2.internal (ec2-75-101-130-251.compute-1.amazonaws.com [75.101.130.251]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id 129B45FAC9 for ; Tue, 19 Sep 2017 19:19:39 +0000 (UTC) Received: from localhost (localhost [127.0.0.1]) by ip-10-146-233-104.ec2.internal (8.14.4/8.14.4) with ESMTP id v8JJJcaI003476; Tue, 19 Sep 2017 19:19:38 GMT Date: Tue, 19 Sep 2017 19:19:38 +0000 From: "Tim Wood (Code Review)" To: Marcel Kornacker , impala-cr@cloudera.com, reviews@impala.incubator.apache.org Message-ID: Reply-To: twood@cloudera.com X-Gerrit-MessageType: newchange Subject: =?UTF-8?Q?=5BImpala-ASF-CR=5D_IMPALA-5376=3A_Implement_all_TPCDS_test_cases_or_alternates_for_Impala=2E=0A?= X-Gerrit-Change-Id: I6e284888600a7a69d1f23fcb7dac21cbb13b7d66 X-Gerrit-ChangeURL: X-Gerrit-Commit: 1f01573107808eb41740d1ab7d450ee7f6db660c MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Content-Disposition: inline User-Agent: Gerrit/2.12.7 archived-at: Tue, 19 Sep 2017 19:19:45 -0000 Tim Wood has uploaded a new change for review. http://gerrit.cloudera.org:8080/8102 Change subject: IMPALA-5376: Implement all TPCDS test cases or alternates for Impala. ...................................................................... IMPALA-5376: Implement all TPCDS test cases or alternates for Impala. Main source for TPCDS query and result definitions: https://github.com/gregrahn/tpcds-kit. TPC-DS v2.5.0 qualification queries from G. Rahn. Data set constructed in mini-cluster using incubator-impala/bin/buildall.sh -testdata.... Complete TPC-DS test suite runs with passes, skips and xfails, but no failures. Some TPC-DS test cases in this commit have been modified in sematically-neutral ways so as to pass on Impala; others are marked to skip or x-fail due to bugs. The tests/query_test/test_tpcds_queries.py driver file is authoritative for the active/skip/xfail status for each case and a brief reason. The following describes the current status as test-name / deviance from TPC-DS spec / changes made: --- tpcds-q22a.test / RESULT MISMATCH in LSD of AVG() values / Fixed AVG()s --- tpcds-q30.test / UNRECOGNIZED CHARACTER / MARKED XFAIL, CDH-59396. --- tpcds-q35a.test / RESULT MISMATCH / MARKED XFAIL, IMPALA-5950. --- tpcds-q36a.test / RESULT MISMATCH / MARKED XFAIL, IMPALA-4741 --- tpcds-q39.test / MULTIPLE RESULT SET not recognized by test framework / MARKED XFAIL. --- tpcds-q47.test / RESULT MISMATCH in LSD of DECIMAL values / ADDED ROUND(2) TO 8th COLUMN OF WITH TABLE, TAKE ACTUAL RESULT AS EXPECTED. --- tpcds-q49.test / RESULT MISMATCH in LSD of DECIMAL values / MARKED XFAIL, IMPALA-5945 --- tpcds-q57.test / RESULT MISMATCH, excess scale in DECIMAL values / FIXED, ADDED TRUNCATE(2) AROUND 6th COLUMN. --- tpcds-q58.test / RESULT MISMATCH in DECIMAL values / MARKED XFAIL. IMPALA-5946 --- tpcds-q59.test / RESULT MISMATCH, excess scale in DECIMAL values / FIXED, ADDED TRUNCATE(2) AROUND 4th-10th COLUMNS. --- tpcds-q61.test / RESULT MISMATCH in DECIMAL value / FIXED. CAST RESULT QUOTIENT TO DECIMAL(15, 4), TAKE ACTUAL RESULT AS EXPECTED --- tpcds-q63.test / RESULT MISMATCH, excess scale in DECIMAL values / ADDED CAST(DECIMAL(7, 2)) TO 3rd COLUMN --- tpcds-q64.test / RESULT MISMATCH / ADDED ORDER BY COLUMNS. --- tpcds-q66.test / RESULT MISMATCH / MARKED XFAIL, IMPALA-4741 --- tpcds-q77a.test / RESULT MISMATCH / FIXED. TAKE ACTUAL RESULT AS EXPECTED --- tpcds-q78.test / RESULT MISMATCH / FIXED. TAKE ACTUAL RESULT AS EXPECTED --- tpcds-q83.test / RESULT MISMATCH / MARKED XFAIL. IMPALA-5945. --- tpcds-q85.test / MISSING TABLE "reason" / MARKED XFAIL, CDH-59394 --- tpcds-q86a.test / RESULT MISMATCH / FIXED. TAKE ACTUAL RESULT AS EXPECTED --- tpcds-q89.test / RESULT MISMATCH, DECIMAL values flap / MARKED XFAIL. ADDED ROUND(2) TO 8th COLUMN, TAKE ACTUAL RESULTS AS EXPECTED, IMPALA-5956. --- tpcds-q90.test / RESULT MISMATCH / MARKED XFAIL, IMPALA-5945. --- tpcds-q93.test / MISSING TABLE "reason" / MARKED XFAIL, CDH-59394 --- tpcds-q98.test / RESULT MISMATCH / FIXED, ADDED ROUND() TO LAST COLUMN Change-Id: I6e284888600a7a69d1f23fcb7dac21cbb13b7d66 --- A testdata/workloads/tpcds/queries/tpcds-q10.test A testdata/workloads/tpcds/queries/tpcds-q10a.test A testdata/workloads/tpcds/queries/tpcds-q11.test A testdata/workloads/tpcds/queries/tpcds-q12.test A testdata/workloads/tpcds/queries/tpcds-q13.test A testdata/workloads/tpcds/queries/tpcds-q14.test A testdata/workloads/tpcds/queries/tpcds-q14a.test A testdata/workloads/tpcds/queries/tpcds-q15.test A testdata/workloads/tpcds/queries/tpcds-q16.test A testdata/workloads/tpcds/queries/tpcds-q17.test A testdata/workloads/tpcds/queries/tpcds-q18.test A testdata/workloads/tpcds/queries/tpcds-q18a.test A testdata/workloads/tpcds/queries/tpcds-q20.test A testdata/workloads/tpcds/queries/tpcds-q21.test A testdata/workloads/tpcds/queries/tpcds-q22.test A testdata/workloads/tpcds/queries/tpcds-q22a.test A testdata/workloads/tpcds/queries/tpcds-q23.test A testdata/workloads/tpcds/queries/tpcds-q24.test A testdata/workloads/tpcds/queries/tpcds-q25.test A testdata/workloads/tpcds/queries/tpcds-q26.test M testdata/workloads/tpcds/queries/tpcds-q27a.test A testdata/workloads/tpcds/queries/tpcds-q29.test A testdata/workloads/tpcds/queries/tpcds-q30.test A testdata/workloads/tpcds/queries/tpcds-q31.test A testdata/workloads/tpcds/queries/tpcds-q32.test A testdata/workloads/tpcds/queries/tpcds-q33.test A testdata/workloads/tpcds/queries/tpcds-q35.test A testdata/workloads/tpcds/queries/tpcds-q35a.test A testdata/workloads/tpcds/queries/tpcds-q36.test A testdata/workloads/tpcds/queries/tpcds-q36a.test A testdata/workloads/tpcds/queries/tpcds-q37.test A testdata/workloads/tpcds/queries/tpcds-q38.test A testdata/workloads/tpcds/queries/tpcds-q39.test A testdata/workloads/tpcds/queries/tpcds-q40.test A testdata/workloads/tpcds/queries/tpcds-q41.test A testdata/workloads/tpcds/queries/tpcds-q44.test A testdata/workloads/tpcds/queries/tpcds-q45.test M testdata/workloads/tpcds/queries/tpcds-q47.test A testdata/workloads/tpcds/queries/tpcds-q48.test A testdata/workloads/tpcds/queries/tpcds-q49.test A testdata/workloads/tpcds/queries/tpcds-q5.test A testdata/workloads/tpcds/queries/tpcds-q50.test A testdata/workloads/tpcds/queries/tpcds-q51.test A testdata/workloads/tpcds/queries/tpcds-q51a.test A testdata/workloads/tpcds/queries/tpcds-q54.test A testdata/workloads/tpcds/queries/tpcds-q56.test A testdata/workloads/tpcds/queries/tpcds-q57.test A testdata/workloads/tpcds/queries/tpcds-q58.test M testdata/workloads/tpcds/queries/tpcds-q59.test A testdata/workloads/tpcds/queries/tpcds-q5a.test A testdata/workloads/tpcds/queries/tpcds-q60.test M testdata/workloads/tpcds/queries/tpcds-q61.test A testdata/workloads/tpcds/queries/tpcds-q62.test M testdata/workloads/tpcds/queries/tpcds-q63.test A testdata/workloads/tpcds/queries/tpcds-q64.test A testdata/workloads/tpcds/queries/tpcds-q66.test A testdata/workloads/tpcds/queries/tpcds-q67.test A testdata/workloads/tpcds/queries/tpcds-q67a.test A testdata/workloads/tpcds/queries/tpcds-q69.test A testdata/workloads/tpcds/queries/tpcds-q70.test A testdata/workloads/tpcds/queries/tpcds-q70a.test A testdata/workloads/tpcds/queries/tpcds-q71.test A testdata/workloads/tpcds/queries/tpcds-q72.test A testdata/workloads/tpcds/queries/tpcds-q74.test A testdata/workloads/tpcds/queries/tpcds-q75.test A testdata/workloads/tpcds/queries/tpcds-q76.test A testdata/workloads/tpcds/queries/tpcds-q77.test A testdata/workloads/tpcds/queries/tpcds-q77a.test A testdata/workloads/tpcds/queries/tpcds-q78.test A testdata/workloads/tpcds/queries/tpcds-q80.test A testdata/workloads/tpcds/queries/tpcds-q80a.test A testdata/workloads/tpcds/queries/tpcds-q81.test A testdata/workloads/tpcds/queries/tpcds-q82.test A testdata/workloads/tpcds/queries/tpcds-q83.test A testdata/workloads/tpcds/queries/tpcds-q84.test A testdata/workloads/tpcds/queries/tpcds-q85.test A testdata/workloads/tpcds/queries/tpcds-q86.test A testdata/workloads/tpcds/queries/tpcds-q86a.test A testdata/workloads/tpcds/queries/tpcds-q87.test M testdata/workloads/tpcds/queries/tpcds-q89.test A testdata/workloads/tpcds/queries/tpcds-q9.test A testdata/workloads/tpcds/queries/tpcds-q90.test A testdata/workloads/tpcds/queries/tpcds-q91.test A testdata/workloads/tpcds/queries/tpcds-q92.test A testdata/workloads/tpcds/queries/tpcds-q93.test A testdata/workloads/tpcds/queries/tpcds-q94.test A testdata/workloads/tpcds/queries/tpcds-q95.test A testdata/workloads/tpcds/queries/tpcds-q97.test M testdata/workloads/tpcds/queries/tpcds-q98.test A testdata/workloads/tpcds/queries/tpcds-q99.test M tests/query_test/test_tpcds_queries.py 91 files changed, 12,746 insertions(+), 1,434 deletions(-) git pull ssh://gerrit.cloudera.org:29418/Impala-ASF refs/changes/02/8102/1 -- To view, visit http://gerrit.cloudera.org:8080/8102 To unsubscribe, visit http://gerrit.cloudera.org:8080/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I6e284888600a7a69d1f23fcb7dac21cbb13b7d66 Gerrit-PatchSet: 1 Gerrit-Project: Impala-ASF Gerrit-Branch: master Gerrit-Owner: Tim Wood