Github user HyukjinKwon commented on the issue:
https://github.com/apache/spark/pull/22307
The problem here sounds:
```
org.apache.hadoop.hive.ql.metadata.Table.getViewExpandedText()
```
is used to build the view which is ran again by SparkSQL parser. The Hive
API avove returns:
```
SELECT `d100.udf100`(`emp`.`name`) FROM `default`.`emp`
```
The root cause is that the code above ``` `d100.udf100` ``` is recognised
as a single identifier within Spark side. So, it seeks the function called
{{d100.udf100}} within the default database whereas Hive looks seeking the
function `udf100` under `d100`.
If Hive's behaviour is correct, we need a strong justification to fix
Spark's behaviour, or document the differences. If not, Hive should fix this.
---
---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscr...@spark.apache.org
For additional commands, e-mail: reviews-h...@spark.apache.org
