Github user wangyum commented on a diff in the pull request: https://github.com/apache/spark/pull/20067#discussion_r158647982 --- Diff: sql/core/src/test/scala/org/apache/spark/sql/SQLQuerySuite.scala --- @@ -2760,6 +2760,17 @@ class SQLQuerySuite extends QueryTest with SharedSQLContext { } } + test("SPARK-22894: DateTimeOperations should accept SQL like string type") { + val date = "2017-12-24" + val str = sql(s"SELECT CAST('$date' as STRING) + interval 2 months 2 seconds") --- End diff -- Hive doesn't accept string type: ``` hive> SELECT cast('2017-12-24' as date) + interval 2 day; 2017-12-26 00:00:00 hive> SELECT cast('2017-12-24' as timestamp) + interval 2 day; 2017-12-26 00:00:00 hive> SELECT cast('2017-12-24' as string) + interval 2 day; FAILED: SemanticException Line 0:-1 Wrong arguments '2': No matching method for class org.apache.hadoop.hive.ql.udf.generic.GenericUDFOPDTIPlus with (string, interval_day_time) hive> ```
--- --------------------------------------------------------------------- To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org For additional commands, e-mail: reviews-h...@spark.apache.org