diff options
author | Kevin Yu <qyu@us.ibm.com> | 2017-01-05 19:00:39 -0800 |
---|---|---|
committer | gatorsmile <gatorsmile@gmail.com> | 2017-01-05 19:00:39 -0800 |
commit | bcc510b021391035abe6d07c5b82bb0f0be31167 (patch) | |
tree | 2ae421ca0e8b8f5a3bacec81b3eeec5b47e979cf /docs/ml-survival-regression.md | |
parent | dfc4c935ba99a4adab2bf39cf24fff1ee3011759 (diff) | |
download | spark-bcc510b021391035abe6d07c5b82bb0f0be31167.tar.gz spark-bcc510b021391035abe6d07c5b82bb0f0be31167.tar.bz2 spark-bcc510b021391035abe6d07c5b82bb0f0be31167.zip |
[SPARK-18871][SQL] New test cases for IN/NOT IN subquery
## What changes were proposed in this pull request?
This PR extends the existing IN/NOT IN subquery test cases coverage, adds more test cases to the IN subquery test suite.
Based on the discussion, we will create `subquery/in-subquery` sub structure under `sql/core/src/test/resources/sql-tests/inputs` directory.
This is the high level grouping for IN subquery:
`subquery/in-subquery/`
`subquery/in-subquery/simple-in.sql`
`subquery/in-subquery/in-group-by.sql (in parent side, subquery, and both)`
`subquery/in-subquery/not-in-group-by.sql`
`subquery/in-subquery/in-order-by.sql`
`subquery/in-subquery/in-limit.sql`
`subquery/in-subquery/in-having.sql`
`subquery/in-subquery/in-joins.sql`
`subquery/in-subquery/not-in-joins.sql`
`subquery/in-subquery/in-set-operations.sql`
`subquery/in-subquery/in-with-cte.sql`
`subquery/in-subquery/not-in-with-cte.sql`
subquery/in-subquery/in-multiple-columns.sql`
We will deliver it through multiple prs, this is the first pr for the IN subquery, it has
`subquery/in-subquery/simple-in.sql`
`subquery/in-subquery/in-group-by.sql (in parent side, subquery, and both)`
These are the results from running on DB2.
[Modified test file of in-group-by.sql used to run on DB2](https://github.com/apache/spark/files/683367/in-group-by.sql.db2.txt)
[Output of the run result on DB2](https://github.com/apache/spark/files/683362/in-group-by.sql.db2.out.txt)
[Modified test file of simple-in.sql used to run on DB2](https://github.com/apache/spark/files/683378/simple-in.sql.db2.txt)
[Output of the run result on DB2](https://github.com/apache/spark/files/683379/simple-in.sql.db2.out.txt)
## How was this patch tested?
This patch is adding tests.
Author: Kevin Yu <qyu@us.ibm.com>
Closes #16337 from kevinyu98/spark-18871.
Diffstat (limited to 'docs/ml-survival-regression.md')
0 files changed, 0 insertions, 0 deletions