diff options
author | wangzhenhua <wangzhenhua@huawei.com> | 2017-04-05 10:21:43 -0700 |
---|---|---|
committer | Xiao Li <gatorsmile@gmail.com> | 2017-04-05 10:21:43 -0700 |
commit | a2d8d767d933321426a4eb9df1583e017722d7d6 (patch) | |
tree | 479ed437d332eac54ede29bce8ff068846ee140d /sql/core/src/test | |
parent | 71c3c48159fe7eb4a46fc2a1b78b72088ccfa824 (diff) | |
download | spark-a2d8d767d933321426a4eb9df1583e017722d7d6.tar.gz spark-a2d8d767d933321426a4eb9df1583e017722d7d6.tar.bz2 spark-a2d8d767d933321426a4eb9df1583e017722d7d6.zip |
[SPARK-20223][SQL] Fix typo in tpcds q77.sql
## What changes were proposed in this pull request?
Fix typo in tpcds q77.sql
## How was this patch tested?
N/A
Author: wangzhenhua <wangzhenhua@huawei.com>
Closes #17538 from wzhfy/typoQ77.
Diffstat (limited to 'sql/core/src/test')
-rwxr-xr-x | sql/core/src/test/resources/tpcds/q77.sql | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/sql/core/src/test/resources/tpcds/q77.sql b/sql/core/src/test/resources/tpcds/q77.sql index 7830f96e76..a69df9fbcd 100755 --- a/sql/core/src/test/resources/tpcds/q77.sql +++ b/sql/core/src/test/resources/tpcds/q77.sql @@ -36,7 +36,7 @@ WITH ss AS 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 + AND d_date BETWEEN cast('2000-08-03' AS DATE) AND (cast('2000-08-03' AS DATE) + INTERVAL 30 days)), ws AS (SELECT |