[jira] [Created] (LENS-453) dimtables of the same dimension not joining on common column

["Angad Singh (JIRA)" <ji...@apache.org>]

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)