[jira] [Created] (LENS-454) Lens not joining a table_reference dimtable

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

Angad Singh created LENS-454:
--------------------------------

             Summary: Lens not joining a table_reference dimtable
                 Key: LENS-454
                 URL: https://issues.apache.org/jira/browse/LENS-454
             Project: Apache Lens
          Issue Type: Bug
          Components: cube
            Reporter: Angad Singh


Consider a dimension X with the following dim_attribute:

{noformat}
<dim_attribute name="lastKnownLocation" type="LONG" description="not available currently">
			<ref_spec>
				<table_references>
					<table_reference column="lastKnownLocation" table="user_latest_location" />
				</table_references>
			</ref_spec>
		</dim_attribute>
{noformat}

Now consider the query:

{noformat}
lens-shell>prepQuery prepare --query "cube select user_latest_location.locationId from user j"
0a2c2c16-836f-4cd0-a3e6-ab5f5b38bb31
lens-shell>prepQuery details --handle 0a2c2c16-836f-4cd0-a3e6-ab5f5b38bb31
User query:cube select user_latest_location.locationId from user j
Prepare handle:0a2c2c16-836f-4cd0-a3e6-ab5f5b38bb31
User:anonymous
Prepared at:Wed Mar 25 13:13:27 UTC 2015
Selected driver :org.apache.lens.driver.hive.HiveDriver
Driver query:SELECT ( user_latest_location . locationid ) FROM user.uh1_hdfs_dimtableA j WHERE ((((user_latest_location.dt = 'latest')) AND ((j.dt = 'latest'))
{noformat}

Lens is select a column from user_latest_location without joining it with dimtableA



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)