[jira] [Created] (TAJO-491) TPC-H Q1~22 Test on Tajo 0.8 CDH branch

["Seungun Choe (JIRA)" <ji...@apache.org>]

Seungun Choe created TAJO-491:
---------------------------------

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


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



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)