Angad Singh created LENS-453:
--------------------------------
Summary: 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
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)
