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-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
