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)
