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)
