[SPARK-13698] Fix Analysis Exceptions when Using Backticks in Generate

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.0.0
• Component/s: SQL
• Assignee: Dilip Biswal
• Reporter: Dilip Biswal
• Created: 05/Mar/16 09:49
• Updated: 19/Apr/16 00:00
• Resolved: 19/Apr/16 00:00

Description

Analysis exception occurs while running the following query.

SELECT ints FROM nestedArray LATERAL VIEW explode(a.b) `a` AS `ints`

Failed to analyze query: org.apache.spark.sql.AnalysisException: cannot resolve '`ints`' given input columns: [a, `ints`]; line 1 pos 7
'Project ['ints]
+- Generate explode(a#0.b), true, false, Some(a), [`ints`#8]
   +- SubqueryAlias nestedarray
      +- LocalRelation [a#0], [[[[1,2,3]]]]

Issue Links

• blocks: SPARK-12719 SQL generation support for generators (including UDTF)
• links to: [Github] Pull Request #11538 (dilipbiswal)