[
https://issues.apache.org/jira/browse/SPARK-6273?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sean Owen updated SPARK-6273:
-----------------------------
Component/s: SQL
Description:
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}
was:
while one table's alias name is the same with other table's column name
get the error Ambiguous references
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)
Summary: Got error when one table's alias name is the same with other
table's column name (was: Got error when do join)
(Make the title more descriptive and add a component)
> 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
> Reporter: Jeff
>
> 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-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
