[
https://issues.apache.org/jira/browse/LENS-453?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Rajat Khandelwal updated LENS-453:
----------------------------------
Fix Version/s: 2.4
> dimtables of the same dimension not joining on common column
> ------------------------------------------------------------
>
> Key: LENS-453
> URL: https://issues.apache.org/jira/browse/LENS-453
> Project: Apache Lens
> Issue Type: Improvement
> Components: cube
> Reporter: Angad Singh
> Assignee: Rajat Khandelwal
> Fix For: 2.4
>
>
> Consider a dimension X with dim attributes:
> userid, age, gender
> 2 dimtables are supplying data to it:
> dimtableA - userid, age
> dimtableB - userid, gender
> currently lens throws the following error on this query:
> {noformat}lens-shell>query execute cube select userid,gender,age from user
> Launching query failed cause: Driver :org.apache.lens.driver.hive.HiveDriver
> Cause :No dimension table has the queried columns for user, columns: [age,
> userid, gender{noformat}
> instead of joining the dimtables, lens tries to find a dimtable with both the
> dim attributes. it should join them instead.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
