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