[jira] [Created] (SPARK-2448) Table name is not getting applied to their attributes after "registerAsTable"

[Jerry Lam (JIRA)]

Jerry Lam created SPARK-2448:
--------------------------------

             Summary: Table name is not getting applied to their attributes 
after "registerAsTable"
                 Key: SPARK-2448
                 URL: https://issues.apache.org/jira/browse/SPARK-2448
             Project: Spark
          Issue Type: Bug
          Components: SQL
    Affects Versions: 1.0.0
            Reporter: Jerry Lam


The following sample code will fail:
{code}
val hiveContext = new org.apache.spark.sql.hive.HiveContext(sc)
import hiveContext._
hql("USE test")
hql("select id from m").registerAsTable("m")
hql("select s.id from m join s on (s.id=m.id)").collect().foreach(println)
{code}

The exception:
{noformat}
org.apache.spark.SparkException: Job aborted due to stage failure: Task 0.0:736 
failed 4 times, most recent failure: Exception failure in TID 167 on host 
node05: org.apache.spark.sql.catalyst.errors.package$TreeNodeException: No 
function to evaluate expression. type: UnresolvedAttribute, tree: 'm.id
        
org.apache.spark.sql.catalyst.analysis.UnresolvedAttribute.eval(unresolved.scala:59)
        
org.apache.spark.sql.catalyst.expressions.Equals.eval(predicates.scala:151)
        
org.apache.spark.sql.execution.Filter$$anonfun$2$$anonfun$apply$1.apply(basicOperators.scala:52)
        
org.apache.spark.sql.execution.Filter$$anonfun$2$$anonfun$apply$1.apply(basicOperators.scala:52)
        scala.collection.Iterator$$anon$14.hasNext(Iterator.scala:390)
        scala.collection.Iterator$$anon$11.hasNext(Iterator.scala:327)
        scala.collection.Iterator$$anon$11.hasNext(Iterator.scala:327)
        scala.collection.Iterator$$anon$11.hasNext(Iterator.scala:327)
        scala.collection.Iterator$class.foreach(Iterator.scala:727)
        scala.collection.AbstractIterator.foreach(Iterator.scala:1157)
        scala.collection.generic.Growable$class.$plus$plus$eq(Growable.scala:48)
        
scala.collection.mutable.ArrayBuffer.$plus$plus$eq(ArrayBuffer.scala:103)
        scala.collection.mutable.ArrayBuffer.$plus$plus$eq(ArrayBuffer.scala:47)
        scala.collection.TraversableOnce$class.to(TraversableOnce.scala:273)
        scala.collection.AbstractIterator.to(Iterator.scala:1157)
        
scala.collection.TraversableOnce$class.toBuffer(TraversableOnce.scala:265)
        scala.collection.AbstractIterator.toBuffer(Iterator.scala:1157)
        
scala.collection.TraversableOnce$class.toArray(TraversableOnce.scala:252)
        scala.collection.AbstractIterator.toArray(Iterator.scala:1157)
        org.apache.spark.rdd.RDD$$anonfun$15.apply(RDD.scala:717)
        org.apache.spark.rdd.RDD$$anonfun$15.apply(RDD.scala:717)
        
org.apache.spark.SparkContext$$anonfun$runJob$4.apply(SparkContext.scala:1080)
        
org.apache.spark.SparkContext$$anonfun$runJob$4.apply(SparkContext.scala:1080)
        org.apache.spark.scheduler.ResultTask.runTask(ResultTask.scala:111)
        org.apache.spark.scheduler.Task.run(Task.scala:51)
        org.apache.spark.executor.Executor$TaskRunner.run(Executor.scala:187)
        
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
        
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
        java.lang.Thread.run(Thread.java:662)
{noformat}

The query execution plan:
{noformat}
== Logical Plan ==
Project ['s.id]
 Join Inner, Some((id#106 = 'm.id))
  Project [id#96 AS id#62]
   MetastoreRelation test, m, None
  MetastoreRelation test, s, Some(s)

== Optimized Logical Plan ==
Project ['s.id]
 Join Inner, Some((id#106 = 'm.id))
  Project []
   MetastoreRelation test, m, None
  Project [id#106]
   MetastoreRelation test, s, Some(s)

== Physical Plan ==
Project ['s.id]
 Filter (id#106:0 = 'm.id)
  CartesianProduct
   HiveTableScan [], (MetastoreRelation test, m, None), None
   HiveTableScan [id#106], (MetastoreRelation test, s, Some(s)), None
{noformat}



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