Github user davies commented on a diff in the pull request:
https://github.com/apache/spark/pull/13188#discussion_r63969828
--- Diff:
sql/core/src/test/scala/org/apache/spark/sql/execution/datasources/parquet/tpcds/queries/q77.sql
---
@@ -0,0 +1,100 @@
+WITH ss AS
+(SELECT
+ s_store_sk,
+ sum(ss_ext_sales_price) AS sales,
+ sum(ss_net_profit) AS profit
+ FROM store_sales, date_dim, store
+ WHERE ss_sold_date_sk = d_date_sk
+ AND d_date BETWEEN cast('2000-08-03' AS DATE) AND
+ date_add(cast('2000-08-03' AS DATE), 30)
+ AND ss_store_sk = s_store_sk
+ GROUP BY s_store_sk),
+ sr AS
+ (SELECT
+ s_store_sk,
+ sum(sr_return_amt) AS returns,
+ sum(sr_net_loss) AS profit_loss
+ FROM store_returns, date_dim, store
+ WHERE sr_returned_date_sk = d_date_sk
+ AND d_date BETWEEN cast('2000-08-03' AS DATE) AND
+ date_add(cast('2000-08-03' AS DATE), 30)
+ AND sr_store_sk = s_store_sk
+ GROUP BY s_store_sk),
+ cs AS
+ (SELECT
+ cs_call_center_sk,
+ sum(cs_ext_sales_price) AS sales,
+ sum(cs_net_profit) AS profit
+ FROM catalog_sales, date_dim
+ WHERE cs_sold_date_sk = d_date_sk
+ AND d_date BETWEEN cast('2000-08-03' AS DATE) AND
+ date_add(cast('2000-08-03' AS DATE), 30)
+ GROUP BY cs_call_center_sk),
+ cr AS
+ (SELECT
+ sum(cr_return_amount) AS returns,
+ sum(cr_net_loss) AS profit_loss
+ FROM catalog_returns, date_dim
+ WHERE cr_returned_date_sk = d_date_sk
+ AND d_date BETWEEN cast('2000-08-03]' AS DATE) AND
+ date_add(cast('2000-08-03' AS DATE), 30)),
+ ws AS
+ (SELECT
+ wp_web_page_sk,
+ sum(ws_ext_sales_price) AS sales,
+ sum(ws_net_profit) AS profit
+ FROM web_sales, date_dim, web_page
+ WHERE ws_sold_date_sk = d_date_sk
+ AND d_date BETWEEN cast('2000-08-03' AS DATE) AND
+ date_add(cast('2000-08-03' AS DATE), 30)
--- End diff --
Could you change the `date_add` back to interval expression?
---
If your project is set up for it, you can reply to this email and have your
reply appear on GitHub as well. If your project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastruct...@apache.org or file a JIRA ticket
with INFRA.
---
---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org
For additional commands, e-mail: reviews-h...@spark.apache.org
