GitHub user maropu opened a pull request:
https://github.com/apache/spark/pull/20343
[SPARK-23167][SQL] Add TPCDS queries v2.7 in TPCDSQuerySuite
## What changes were proposed in this pull request?
This pr added TPCDS v2.7 (latest) queries in `TPCDSQuerySuite` because the
current `TPCDSQuerySuite` tests older one (v1.4) and some queries are different
from v1.4 and v2.7. Since the original v2.7 queries have the syntaxes that
Spark cannot parse, I changed these queries in a following way:
- [date] + 14 days -> date + `INTERVAL` 14 days
- [column name] as "30 days" -> [column name] as \`30 days\`
- Fix some syntax errors, e.g., missing brackets
## How was this patch tested?
Added tests in `TPCDSQuerySuite`.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/maropu/spark TPCDSV2_7
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/spark/pull/20343.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #20343
----
commit 71e0e1ad2f6ee772103ef43d2270ed347bc497d0
Author: Takeshi Yamamuro <yamamuro@...>
Date: 2018-01-19T11:04:59Z
Update TPCD queries to v2.7.0
----
---
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
