[
https://issues.apache.org/jira/browse/LENS-442?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Angad Singh resolved LENS-442.
------------------------------
Resolution: Not a Problem
> 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)
