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

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

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

Seungun Choe commented on TAJO-491:
-----------------------------------

Impala q9 was "out of memory" and q11, 22 does not support join without 'on' condition.

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