[jira] [Created] (LENS-582) in lens query fact table update period weekly throws error if start and end date is not sunday

["Biru Kumar (JIRA)" <ji...@apache.org>]

Biru Kumar created LENS-582:
-------------------------------

             Summary: in lens query fact table update period weekly throws error if start and end date is not sunday
                 Key: LENS-582
                 URL: https://issues.apache.org/jira/browse/LENS-582
             Project: Apache Lens
          Issue Type: Bug
          Components: build
            Reporter: Biru Kumar
            Assignee: Amareshwari Sriramadasu


Lens query

{noformat}
lens-shell>query execute cube select  avg(servedImpressions) from user_activity where time_range_in(dt, '2015-01-19', '2015-01-21')
Launching query failed cause: Driver :org.apache.lens.driver.hive.HiveDriver Cause :No candidate fact table available to answer the query, because {"brief":"No fact update periods for given range","details":{"user_attributestore_er_fact_supply_site_burn,user_attributestore_er_fact_demandcategory_click,user_attributestore_er_fact_supplycategory_visits,user_attributestore_er_fact_supply_site_impressions_rendered,user_attributestore_er_fact_adgroup_click,user_attributestore_er_fact_adgroup_impression_time_install,user_attributestore_er_fact_app_impression_time_install,user_attributestore_er_fact_supply_site_impressions_served,user_attributestore_er_fact_adgroup_burn,hive_fact_user_curation_good_traffic,user_attributestore_er_fact_app_visits,user_attributestore_er_fact_app_click,user_attributestore_er_fact_supply_site_click,user_attributestore_er_fact_adgroup_impressions_rendered":[{"cause":"COLUMN_NOT_FOUND","missingColumns":["servedimpressions"]}],"user_attributestore_er_fact_adgroup_view":[{"cause":"NO_FACT_UPDATE_PERIODS_FOR_GIVEN_RANGE"}]}}
{noformat}

but the fact table user_attributestore_er_fact_adgroup_view has the coloumn servedImpressions there. Below is the definition

{noformat}
lens-shell>describe fact user_attributestore_er_fact_adgroup_view

columns :
column :
   name : userid  type : string
   name : timestamp  type : timestamp
   name : adgroupguid  type : string
   name : servedimpressions  type : bigint


properties :
property :
   name : cube.table.user_attributestore_er_fact_adgroup_view.weight  value : 0.1
   name : cube.table.type  value : FACT
   name : cube.fact.user_attributestore_er_fact_adgroup_view.uh1_hdfs.updateperiods  value : WEEKLY
   name : cube.fact.is.aggregated  value : false
   name : cube.fact.user_attributestore_er_fact_adgroup_view.cubename  value : user_activity
   name : transient_lastDdlTime  value : 1431973737
   name : cube.fact.user_attributestore_er_fact_adgroup_view.storages  value : uh1_hdfs


storageTables :
storageTable :
   updatePeriods :   updatePeriod :  WEEKLY
    storageName : uh1_hdfs  tableDesc :   partCols :   column :
   name : dt  type : string  comment : Date partition field
    tableParameters :   property :
   name : cube.storagetable.partition.timeline.cache.WEEKLY.dt.latest  value : 2015-W08     name : conf.attributestore.schema  value : \granularity\:\weekly_dailycumulative\\erinfo\:\source\:null\erid\:\8589934594\\entityType\:\ADGROUP\\entityAlias\:\adGroupGuid\\relationshipType\:\VIEW\\fields\:\alias\:\servedImpressions\\name\:\count\\type\:\LONG\
\stores\:\viewvisit\
     name : cube.storagetable.partition.timeline.cache.present  value : true     name : EXTERNAL  value : TRUE     name : cube.storagetable.time.partcols  value : dt     name : cube.storagetable.partition.timeline.cache.WEEKLY.dt.first  value : 2015-W07     name : transient_lastDdlTime  value : 1432301397     name : cube.storagetable.partition.timeline.cache.WEEKLY.dt.holes.size  value : 0     name : conf.debugmode  value : true     name : cube.storagetable.partition.timeline.cache.WEEKLY.dt.storage.class  value : org.apache.lens.cube.metadata.timeline.EndsAndHolesPartitionTimeline
    serdeParameters :   property :
   name : serialization.format  value : 1
    timePartCols :  dt
  external : true  tableLocation : hdfs://data-lens-userqa-cdh4.3.0300-null.raghavendra.ev1.inmobi.com:8020/user/hive/warehouse/user.db/uh1_hdfs_user_attributestore_er_fact_adgroup_view  inputFormat : com.inmobi.user.analytics.storage.inputformat.UserAttributeThriftInputFormat  outputFormat : org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat  serdeClassName : com.inmobi.user.analytics.storage.serde.UserAttributeThriftSerde  storageHandlerName :   numBuckets : 0  compressed : false


name : user_attributestore_er_fact_adgroup_view
cubeName : user_activity
weight : 0.1
{noformat} 


however below query runs successfully because start and end date mentioned below are sunday.

{noformat}
lens-shell>query execute cube select avg(servedImpressions) from user_activity where time_range_in(dt, '2015-02-08', '2015-03-01')
_c0
2.7083333333333335
1 rows process in (20) seconds.
{noformat}



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