Return-Path: X-Original-To: apmail-tajo-dev-archive@minotaur.apache.org Delivered-To: apmail-tajo-dev-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 2C3111054C for ; Fri, 10 Jan 2014 07:33:21 +0000 (UTC) Received: (qmail 72295 invoked by uid 500); 10 Jan 2014 07:33:20 -0000 Delivered-To: apmail-tajo-dev-archive@tajo.apache.org Received: (qmail 72265 invoked by uid 500); 10 Jan 2014 07:33:19 -0000 Mailing-List: contact dev-help@tajo.incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@tajo.incubator.apache.org Delivered-To: mailing list dev@tajo.incubator.apache.org Received: (qmail 72255 invoked by uid 99); 10 Jan 2014 07:33:19 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 10 Jan 2014 07:33:19 +0000 X-ASF-Spam-Status: No, hits=-2000.1 required=5.0 tests=ALL_TRUSTED,RP_MATCHES_RCVD X-Spam-Check-By: apache.org Received: from [140.211.11.3] (HELO mail.apache.org) (140.211.11.3) by apache.org (qpsmtpd/0.29) with SMTP; Fri, 10 Jan 2014 07:33:16 +0000 Received: (qmail 71765 invoked by uid 99); 10 Jan 2014 07:32:53 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 10 Jan 2014 07:32:53 +0000 Date: Fri, 10 Jan 2014 07:32:53 +0000 (UTC) From: "Seungun Choe (JIRA)" To: dev@tajo.incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (TAJO-491) TPC-H Q1~22 Test on Tajo 0.8 CDH branch MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/TAJO-491?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Seungun Choe updated TAJO-491: ------------------------------ Description: (was: ||Engine||Q1||Q2||Q3||Q4||Q5||Q6||Q7||Q8||Q9||Q10||Q11||Q12||Q13||Q14||Q15||Q16||Q17||Q18||Q19||Q20||Q21||Q22|| |Tajo|34.57|32.91|82.37|-|118.73|29.26|165.58|126.84|-|81.53|-|53.46|122.64|41.87|-|-|-|-|-|-||-||-| |Hive|133.56|256.54|241.55|205.29|441.04|100.08|860.97|441.78|919.10|341.02|161.06|160.14|170.11|128.14|190.33|514.01|373.41|411.39|214.21|386.70|932.00|200.02| |Impala|46.28|21.08|184.54|119.46|110.38|47.10|388.98|69.76|-|72.92|-|52.65|76.49|49.72|53.08|39.76|565.78|337.22|209.64|94.76|469.47|-| |Hive/Tajo|3.86|7.79|2.93|-|3.71|3.42|5.20|3.48|-|4.18|-|3.00|1.39|3.06|-|-|-|-|-|-|-|-| |Impala/Tajo|1.34|0.64|2.24|-|0.93|1.61|2.35|0.55|-|0.89|-|0.98|0.62|1.19|-|-|-|-|-|-|-|-| TPC-H Test results in that table. 5 and the query is executed once for each, and the calculated average. And, here is error messages about can't run queries. Also, Q7, Q8, Q13 queries results are not match Tajo and Hive, Impala. {code} q04 : org.apache.tajo.algebra.ExistsPredicate cannot be cast to org.apache.tajo.algebra.InPredicate q05 : Some targets cannot be evaluated in the query block "profit" q11 : java.lang.NullPointerException q15 : ERROR: no such a column name supplier_no q16: java.lang.NullPointerException q17: java.lang.NullPointerException q18: java.lang.NullPointerException q19: ERROR: syntax error at or near '(' LINE 7:0 ( q20: ERROR: syntax error at or near '(' LINE 21:20 and ps_availqty > ( q21: org.apache.tajo.algebra.ExistsPredicate cannot be cast to org.apache.tajo.algebra.InPredicate q22: ERROR: syntax error at or near '(' LINE 5:5 from ( {code} These queries which does not included page 'https://wiki.apache.org/tajo/TpchBenchmark' refer TPC-H documents. Tajo version : commit 95d4ea9c653b791a6e8e8e27ace6102b1a4acbf3(tajo-cdh) Hive : 0.10.0-cdh4.3.0 impala : impala v1.1.1 HDFS : 2.0.0-cdh4.3.0 My cluster Info (1 Master, 6 Workers (not use HA)) CPU : Intel(R) Xeon(R) CPU E5-2640 0 @ 2.50GHz Mem : 64GB HDD : 300GB OS Level, 3TB*6 Data Level) > TPC-H Q1~22 Test on Tajo 0.8 CDH branch > --------------------------------------- > > Key: TAJO-491 > URL: https://issues.apache.org/jira/browse/TAJO-491 > Project: Tajo > Issue Type: Test > Reporter: Seungun Choe > -- This message was sent by Atlassian JIRA (v6.1.5#6160)