Yin Huai created SPARK-2474:
-------------------------------

             Summary: In some cases, the Analyzer failed to resolve a table 
registered in OverrideCatalog
                 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