[SPARK-22488] The view resolution in the SparkSession internal table() API

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.1.2, 2.2.0
• Fix Version/s: 2.2.1, 2.3.0
• Component/s: SQL
• Target Version/s: 2.2.1, 2.3.0
• Assignee: Xiao Li
• Reporter: Xiao Li
• Created: 10/Nov/17 04:15
• Updated: 12/Nov/17 22:16
• Resolved: 11/Nov/17 17:25

Description

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)
```

Issue Links

• links to: [Github] Pull Request #19713 (gatorsmile)
• links to: [Github] Pull Request #19723 (gatorsmile)