You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lens.apache.org by "Amareshwari Sriramadasu (JIRA)" <ji...@apache.org> on 2015/03/25 13:46:53 UTC
[jira] [Commented] (LENS-442) Lens failing query with
"NO_PARTITIONS"
[ 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)