GitHub user gatorsmile opened a pull request:
https://github.com/apache/spark/pull/19713
[SPARK-22488] [SQL] Fix the view resolution issue in the SparkSession
internal table() API
## What changes were proposed in this pull request?
The current internal `table()` API of `SparkSession` bypasses the Analyzer
and directly calls `sessionState.catalog.lookupRelation` API. This skips the
view resolution logics in our Analyzer rule `ResolveRelations`. This internal
API is widely used by various DDL commands or the other internal APIs.
Users might get the strange error caused by view resolution when the
default database is different.
```
Table or view not found: t1; line 1 pos 14
org.apache.spark.sql.AnalysisException: Table or view not found: t1; line 1
pos 14
at
org.apache.spark.sql.catalyst.analysis.package$AnalysisErrorAt.failAnalysis(package.scala:42)
```
This PR is to fix it by enforcing it to use `ResolveRelations` to resolve
the table.
## How was this patch tested?
Added a test case and modified the existing test cases
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/gatorsmile/spark viewResolution
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/spark/pull/19713.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #19713
----
commit d87f33327b351cea493a065d144044cf2c1a069f
Author: gatorsmile <[email protected]>
Date: 2017-11-10T03:47:59Z
fix.
----
---
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
