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