[ 
https://issues.apache.org/jira/browse/SPARK-2474?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Yin Huai updated SPARK-2474:
----------------------------

    Summary: For a registered table in OverrideCatalog, the Analyzer failed to 
resolve references in the format of "tableName.fieldName"  (was: In some cases, 
the Analyzer failed to resolve a table registered in OverrideCatalog)

> For a registered table in OverrideCatalog, the Analyzer failed to resolve 
> references in the format of "tableName.fieldName"
> ---------------------------------------------------------------------------------------------------------------------------
>
>                 Key: SPARK-2474
>                 URL: https://issues.apache.org/jira/browse/SPARK-2474
>             Project: Spark
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 1.0.1
>            Reporter: Yin Huai
>
> To reproduce the error, execute the following code in hive/console...
> {code}
> val m = hql("select key from src")
> m.registerAsTable("m")
> hql("select m.key from m")
> {code}
> Then, you will see
> {code}
> org.apache.spark.sql.catalyst.errors.package$TreeNodeException: Unresolved 
> attributes: 'm.key, tree:
> Project ['m.key]
>  LowerCaseSchema 
>   Project [key#6]
>    LowerCaseSchema 
>     MetastoreRelation default, src, None
>       at 
> org.apache.spark.sql.catalyst.analysis.Analyzer$CheckResolution$$anonfun$apply$1.applyOrElse(Analyzer.scala:71)
>       at 
> org.apache.spark.sql.catalyst.analysis.Analyzer$CheckResolution$$anonfun$apply$1.applyOrElse(Analyzer.scala:69)
>       at 
> org.apache.spark.sql.catalyst.trees.TreeNode.transformDown(TreeNode.scala:165)
>       at 
> org.apache.spark.sql.catalyst.trees.TreeNode.transform(TreeNode.scala:156)
> ...
> {code}
> However, if you run
> {code}
> hql("select tmp.key from m tmp")
> {code}
> We are fine.
> {code}
> SchemaRDD[3] at RDD at SchemaRDD.scala:104
> == Query Plan ==
> HiveTableScan [key#8], (MetastoreRelation default, src, None), None
> {code}



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Reply via email to