[jira] [Created] (SPARK-24077) Why spark SQL not support `CREATE TEMPORARY FUNCTION IF NOT EXISTS`?

["Benedict Jin (JIRA)" <ji...@apache.org>]

Benedict Jin created SPARK-24077:
------------------------------------

             Summary: Why spark SQL not support `CREATE TEMPORARY FUNCTION IF NOT EXISTS`?
                 Key: SPARK-24077
                 URL: https://issues.apache.org/jira/browse/SPARK-24077
             Project: Spark
          Issue Type: Question
          Components: SQL
    Affects Versions: 2.3.0
            Reporter: Benedict Jin
             Fix For: 3.0.0


Why spark SQL not support `CREATE TEMPORARY FUNCTION IF NOT EXISTS`?

 

scala> org.apache.spark.sql.SparkSession.builder().enableHiveSupport.getOrCreate.sql("CREATE TEMPORARY FUNCTION IF NOT EXISTS yuzhouwan as 'org.apache.spark.sql.hive.udf.YuZhouWan'")

org.apache.spark.sql.catalyst.parser.ParseException:
mismatched input 'NOT' expecting \{'.', 'AS'}(line 1, pos 29)

== SQL ==
 CREATE TEMPORARY FUNCTION IF NOT EXISTS yuzhouwan as 'org.apache.spark.sql.hive.udf.YuZhouWan'
 -----------------------------^^^
 at org.apache.spark.sql.catalyst.parser.ParseException.withCommand(ParseDriver.scala:197)
 at org.apache.spark.sql.catalyst.parser.AbstractSqlParser.parse(ParseDriver.scala:99)
 at org.apache.spark.sql.execution.SparkSqlParser.parse(SparkSqlParser.scala:45)
 at org.apache.spark.sql.catalyst.parser.AbstractSqlParser.parsePlan(ParseDriver.scala:53)
 at org.apache.spark.sql.SparkSession.sql(SparkSession.scala:592)
 ... 48 elided



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org