diff options
| author | Dilip Biswal <dbiswal@us.ibm.com> | 2017-02-09 00:31:51 -0500 |
|---|---|---|
| committer | gatorsmile <gatorsmile@gmail.com> | 2017-02-09 00:31:51 -0500 |
| commit | 64cae22f7cbba793e32d2c8ccb4b7981208070fd (patch) | |
| tree | bd8a05aba986655c6cb23c20106b396e65c0c12b /sql/hive/src/test/scala/org/apache | |
| parent | c618ccdbe9ac103dfa3182346e2a14a1e7fca91a (diff) | |
| download | spark-64cae22f7cbba793e32d2c8ccb4b7981208070fd.tar.gz spark-64cae22f7cbba793e32d2c8ccb4b7981208070fd.tar.bz2 spark-64cae22f7cbba793e32d2c8ccb4b7981208070fd.zip | |
[SPARK-18872][SQL][TESTS] New test cases for EXISTS subquery (Aggregate, Having, Orderby, Limit)
## What changes were proposed in this pull request?
This PR adds the second set of tests for EXISTS subquery.
File name | Brief description
------------------------| -----------------
exists-aggregate.sql |Tests aggregate expressions in outer query and EXISTS subquery.
exists-having.sql|Tests HAVING clause in subquery.
exists-orderby-limit.sql|Tests EXISTS subquery support with ORDER BY and LIMIT clauses.
DB2 results are attached here as reference :
[exists-aggregate-db2.txt](https://github.com/apache/spark/files/743287/exists-aggregate-db2.txt)
[exists-having-db2.txt](https://github.com/apache/spark/files/743286/exists-having-db2.txt)
[exists-orderby-limit-db2.txt](https://github.com/apache/spark/files/743288/exists-orderby-limit-db2.txt)
## How the patch was tested.
The test result is compared with the result run from another SQL engine (in this case is IBM DB2). If the result are equivalent, we assume the result is correct.
Author: Dilip Biswal <dbiswal@us.ibm.com>
Closes #16760 from dilipbiswal/exists-pr2.
Diffstat (limited to 'sql/hive/src/test/scala/org/apache')
0 files changed, 0 insertions, 0 deletions