You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@spark.apache.org by "Dongjoon Hyun (JIRA)" <ji...@apache.org> on 2016/08/10 05:13:20 UTC
[jira] [Comment Edited] (SPARK-6273) Got error when one table's
alias name is the same with other table's column name
[ https://issues.apache.org/jira/browse/SPARK-6273?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15414706#comment-15414706 ]
Dongjoon Hyun edited comment on SPARK-6273 at 8/10/16 5:12 AM:
---------------------------------------------------------------
It seems to be resolved in 1.3.x somewhere according to SPARK-5278. Spark 2.0 also does not have this issue like the following.
{code}
scala> spark.version
res0: String = 2.0.0
scala> spark.range(1).createOrReplaceTempView("t")
scala> spark.range(1).createOrReplaceTempView("s")
scala> sql("select * from t id, s").show
+---+---+
| id| id|
+---+---+
| 0| 0|
+---+---+
scala> sql("select id.id, s.id from t id, s").show
+---+---+
| id| id|
+---+---+
| 0| 0|
+---+---+
{code}
was (Author: dongjoon):
It seems to be resolved in 1.3 according to SPARK-5278. Spark 2.0 also does not have this issue like the following.
{code}
scala> spark.version
res0: String = 2.0.0
scala> spark.range(1).createOrReplaceTempView("t")
scala> spark.range(1).createOrReplaceTempView("s")
scala> sql("select * from t id, s").show
+---+---+
| id| id|
+---+---+
| 0| 0|
+---+---+
scala> sql("select id.id, s.id from t id, s").show
+---+---+
| id| id|
+---+---+
| 0| 0|
+---+---+
{code}
> Got error when one table's alias name is the same with other table's column name
> --------------------------------------------------------------------------------
>
> Key: SPARK-6273
> URL: https://issues.apache.org/jira/browse/SPARK-6273
> Project: Spark
> Issue Type: Bug
> Components: SQL
> Affects Versions: 1.2.1, 1.3.1
> Reporter: Jeff
> Fix For: 2.0.0
>
>
> while one table's alias name is the same with other table's column name
> get the error Ambiguous references
> {code}
> Error: org.apache.spark.sql.catalyst.errors.package$TreeNodeException: Ambiguous references to salary.pay_date: (pay_date#34749,List()),(salary#34792,List(pay_date)), tree:
> 'Filter (((('salary.pay_date = 'time_by_day.the_date) && ('time_by_day.the_year = 1997.0)) && ('salary.employee_id = 'employee.employee_id)) && ('employee.store_id = 'store.store_id))
> Join Inner, None
> Join Inner, None
> Join Inner, None
> MetastoreRelation yxqtest, time_by_day, Some(time_by_day)
> MetastoreRelation yxqtest, salary, Some(salary)
> MetastoreRelation yxqtest, store, Some(store)
> MetastoreRelation yxqtest, employee, Some(employee) (state=,code=0)
> Error: org.apache.spark.sql.catalyst.errors.package$TreeNodeException: Ambiguous references to salary.pay_date: (pay_date#34749,List()),(salary#34792,List(pay_date)), tree:
> 'Filter (((('salary.pay_date = 'time_by_day.the_date) && ('time_by_day.the_year = 1997.0)) && ('salary.employee_id = 'employee.employee_id)) && ('employee.store_id = 'store.store_id))
> Join Inner, None
> Join Inner, None
> Join Inner, None
> MetastoreRelation yxqtest, time_by_day, Some(time_by_day)
> MetastoreRelation yxqtest, salary, Some(salary)
> MetastoreRelation yxqtest, store, Some(store)
> MetastoreRelation yxqtest, employee, Some(employee) (state=,code=0)
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org