diff options
author | egraldlo <egraldlo@gmail.com> | 2014-06-02 18:02:57 -0700 |
---|---|---|
committer | Michael Armbrust <michael@databricks.com> | 2014-06-02 18:02:57 -0700 |
commit | ec8be274a7bc586bb5b025033cbfd73f9a4d7160 (patch) | |
tree | 3beaa68e8ea356d9b33f829a4b84f1da3bb01185 /sql/core | |
parent | d000ca98a80986ff5b13477547f1dcab7856ae63 (diff) | |
download | spark-ec8be274a7bc586bb5b025033cbfd73f9a4d7160.tar.gz spark-ec8be274a7bc586bb5b025033cbfd73f9a4d7160.tar.bz2 spark-ec8be274a7bc586bb5b025033cbfd73f9a4d7160.zip |
[SPARK-1995][SQL] system function upper and lower can be supported
I don't know whether it's time to implement system function about string operation in spark sql now.
Author: egraldlo <egraldlo@gmail.com>
Closes #936 from egraldlo/stringoperator and squashes the following commits:
3c6c60a [egraldlo] Add UPPER, LOWER, MAX and MIN into hive parser
ea76d0a [egraldlo] modify the formatting issues
b49f25e [egraldlo] modify the formatting issues
1f0bbb5 [egraldlo] system function upper and lower supported
13d3267 [egraldlo] system function upper and lower supported
Diffstat (limited to 'sql/core')
-rw-r--r-- | sql/core/src/test/scala/org/apache/spark/sql/SQLQuerySuite.scala | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/sql/core/src/test/scala/org/apache/spark/sql/SQLQuerySuite.scala b/sql/core/src/test/scala/org/apache/spark/sql/SQLQuerySuite.scala index 189dccd525..95860e6683 100644 --- a/sql/core/src/test/scala/org/apache/spark/sql/SQLQuerySuite.scala +++ b/sql/core/src/test/scala/org/apache/spark/sql/SQLQuerySuite.scala @@ -313,4 +313,27 @@ class SQLQuerySuite extends QueryTest { (3, "C"), (4, "D"))) } + + test("system function upper()") { + checkAnswer( + sql("SELECT n,UPPER(l) FROM lowerCaseData"), + Seq( + (1, "A"), + (2, "B"), + (3, "C"), + (4, "D"))) + } + + test("system function lower()") { + checkAnswer( + sql("SELECT N,LOWER(L) FROM upperCaseData"), + Seq( + (1, "a"), + (2, "b"), + (3, "c"), + (4, "d"), + (5, "e"), + (6, "f"))) + } + } |