hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sahil Takiar (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (HIVE-17662) Update PerfDriver to use latest TPC-DS version of queries
Date Mon, 02 Oct 2017 21:30:00 GMT

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

Sahil Takiar edited comment on HIVE-17662 at 10/2/17 9:29 PM:
--------------------------------------------------------------

query72 - latest TPC-DS spec uses sum instead of count for the aggregation, and some of the
filter conditions have been modified
query4 - change {{order by t_s_secyear.customer_preferred_cust_flag}} to {{order by t_s_secyear.customer_id
,t_s_secyear.customer_first_name, t_s_secyear.customer_last_name, t_s_secyear.customer_preferred_cust_flag}}
query11 - similar changes to query4 + a few others



was (Author: stakiar):
query72 - latest TPC-DS spec uses sum instead of count for the aggregation, and some of the
filter conditions have modified
query4 - change {{order by t_s_secyear.customer_preferred_cust_flag}} to {{order by t_s_secyear.customer_id
,t_s_secyear.customer_first_name, t_s_secyear.customer_last_name, t_s_secyear.customer_preferred_cust_flag}}
query11 - similar changes to query4 + a few others


> Update PerfDriver to use latest TPC-DS version of queries
> ---------------------------------------------------------
>
>                 Key: HIVE-17662
>                 URL: https://issues.apache.org/jira/browse/HIVE-17662
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Sahil Takiar
>            Assignee: Sahil Takiar
>
> {{query59}} contains {{tue_sales1/tue_sales1}} while the latest version of TPC-DS contains
{{tue_sales1/tue_sales2}}. The current version also doesn't make much sense since {{tue_sales1/tue_sales1}}
will always return 1.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message