[
https://issues.apache.org/jira/browse/LENS-442?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14379806#comment-14379806
]
Amareshwari Sriramadasu commented on LENS-442:
----------------------------------------------
Did the partition registration happen through lens server? If not, lens server
does not know about partition availability as the information would have been
cached. That is why restart would have helped.
> Lens failing query with "NO_PARTITIONS"
> ---------------------------------------
>
> Key: LENS-442
> URL: https://issues.apache.org/jira/browse/LENS-442
> Project: Apache Lens
> Issue Type: Bug
> Components: server
> Reporter: Angad Singh
>
> {noformat}
> lens-shell>dimtable list partitions hive_dimtable_uac_app uh1_hdfs
>
> nonTimePartitionSpec : null
> timePartitionSpec : null
> fullPartitionSpec :
> partSpecElement :
> key : dt value : 2015-01-02
>
> partitionParameters :
> property :
> name : numFiles value : 1
> name : transient_lastDdlTime value : 1427282033
> name : COLUMN_STATS_ACCURATE value : false
> name : totalSize value : 1092
> name : numRows value : -1
> name : rawDataSize value : -1
> name : cube.storagetable.partition.update.period value : DAILY
>
> serdeParameters :
> property :
> name : serialization.format value : 1
>
> factOrDimensionTableName : null
> name : user@uh1_hdfs_hive_dimtable_uac_app@dt=2015-01-02
> location : hdfs://server:8020/projects/data
> inputFormat : org.apache.hadoop.mapred.TextInputFormat
> outputFormat : org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
> serdeClassname : org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
> updatePeriod : DAILY
>
> nonTimePartitionSpec : null
> timePartitionSpec : null
> fullPartitionSpec :
> partSpecElement :
> key : dt value : latest
>
> partitionParameters :
> property :
> name : numFiles value : 1
> name : cube.storagetable.dt.latest.part.timestamp value : 2015-01-02
> name : transient_lastDdlTime value : 1427282033
> name : COLUMN_STATS_ACCURATE value : false
> name : totalSize value : 1092
> name : numRows value : -1
> name : rawDataSize value : -1
> name : cube.storagetable.partition.update.period value : DAILY
>
> serdeParameters :
> property :
> name : serialization.format value : 1
>
> factOrDimensionTableName : null
> name : user@uh1_hdfs_hive_dimtable_uac_app@dt=latest
> location : hdfs://server:8020/projects/data
> inputFormat : org.apache.hadoop.mapred.TextInputFormat
> outputFormat : org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
> serdeClassname : org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
> updatePeriod : DAILY
>
> lens-shell>dimtable list partitions hive_dimtable_uac_app
> Syntax error, please try in following format. dim list partitions <table>
> <storage> [partition values]
> lens-shell>query execute cube select apps_owned from user j
> Launching query failed cause: Driver :org.apache.lens.driver.hive.HiveDriver
> Cause :No candidate dimension table available for hive_dimension_uac_app to
> answer the query, because {"brief":"No candidate storages for any
> table","details":{"hive_dimtable_uac_app":[{"cause":"NO_CANDIDATE_STORAGES","storageCauses":{"uh1":{"cause":"NO_PARTITIONS"}}}]}}
> {noformat}
> Works after restarting lens server
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
