Uploaded image for project: 'Apache Lens (Retired)'
  1. Apache Lens (Retired)
  2. LENS-454

Lens not joining a table_reference dimtable

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Won't Fix
    • None
    • None
    • cube
    • None

    Description

      Consider a dimension X with the following dim_attribute:

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

      Now consider the query:

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

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

      Attachments

        Issue Links

          is related to

          Improvement - An improvement or enhancement to an existing feature or task. LENS-99 Denormalization resolver should support chained columns as well

          • Major - Major loss of function.
          • Resolved

          Activity

            People

              Unassigned Unassigned
              angadsingh Angad Singh
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: