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

["Amareshwari Sriramadasu (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/LENS-454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Amareshwari Sriramadasu resolved LENS-454.
------------------------------------------
    Resolution: Won't Fix

We are planning to drop table_references and only accept join chains in the cube/dimension definitions.

> 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)