[GitHub] spark pull request #20343: [SPARK-23167][SQL] Add TPCDS queries v2.7 in TPCD...

[gatorsmile]

Github user gatorsmile commented on a diff in the pull request:

    https://github.com/apache/spark/pull/20343#discussion_r163021292
  
    --- Diff: sql/core/src/test/resources/tpcds-v2.7.0/q11.sql ---
    @@ -0,0 +1,78 @@
    +with year_total as (
    + select c_customer_id customer_id
    +       ,c_first_name customer_first_name
    +       ,c_last_name customer_last_name
    +       ,c_preferred_cust_flag customer_preferred_cust_flag
    +       ,c_birth_country customer_birth_country
    +       ,c_login customer_login
    +       ,c_email_address customer_email_address
    +       ,d_year dyear
    +       ,sum(ss_ext_list_price-ss_ext_discount_amt) year_total
    +       ,'s' sale_type
    + from customer
    +     ,store_sales
    +     ,date_dim
    + where c_customer_sk = ss_customer_sk
    +   and ss_sold_date_sk = d_date_sk
    + group by c_customer_id
    +         ,c_first_name
    +         ,c_last_name
    +         ,c_preferred_cust_flag 
    +         ,c_birth_country
    +         ,c_login
    +         ,c_email_address
    +         ,d_year 
    + union all
    + select c_customer_id customer_id
    +       ,c_first_name customer_first_name
    +       ,c_last_name customer_last_name
    +       ,c_preferred_cust_flag customer_preferred_cust_flag
    +       ,c_birth_country customer_birth_country
    +       ,c_login customer_login
    +       ,c_email_address customer_email_address
    +       ,d_year dyear
    +       ,sum(ws_ext_list_price-ws_ext_discount_amt) year_total
    +       ,'w' sale_type
    + from customer
    +     ,web_sales
    +     ,date_dim
    + where c_customer_sk = ws_bill_customer_sk
    +   and ws_sold_date_sk = d_date_sk
    + group by c_customer_id
    +         ,c_first_name
    +         ,c_last_name
    +         ,c_preferred_cust_flag 
    +         ,c_birth_country
    +         ,c_login
    +         ,c_email_address
    +         ,d_year
    +         )
    +  select  
    +                  t_s_secyear.customer_id
    +                 ,t_s_secyear.customer_first_name
    +                 ,t_s_secyear.customer_last_name
    +                 ,t_s_secyear.customer_email_address
    --- End diff --
    
    ![screen shot 2018-01-22 at 10 12 44 
am](https://user-images.githubusercontent.com/11567269/35236633-d6b31c5a-ff5c-11e7-9ee8-40191a5a136e.png)



---

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org
For additional commands, e-mail: reviews-h...@spark.apache.org