You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Sahil Takiar (JIRA)" <ji...@apache.org> on 2017/10/02 21:30:00 UTC
[jira] [Comment Edited] (HIVE-17662) Update PerfDriver to use
latest TPC-DS version of queries
[ 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)