Description
To reproduce the error, execute the following code in hive/console...
val m = hql("select key from src") m.registerAsTable("m") hql("select m.key from m")
Then, you will see
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) ...
However, if you run
hql("select tmp.key from m tmp")
We are fine.
SchemaRDD[3] at RDD at SchemaRDD.scala:104
== Query Plan ==
HiveTableScan [key#8], (MetastoreRelation default, src, None), None
Attachments
Issue Links
- is duplicated by
-
SPARK-2448 Table name is not getting applied to their attributes after "registerAsTable"
- Resolved
- links to