[
https://issues.apache.org/jira/browse/LENS-272?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14306647#comment-14306647
]
Amareshwari Sriramadasu commented on LENS-272:
----------------------------------------------
Filling non existing partitions is not enabled by default. When we set
lens.cube.query.add.nonexisting.partitions to true, only then it will look for
all non existing partitions and update that in the error message.
Here is the validation done :
{noformat}
lens-shell>query explain cube select measure2 from sample_cube where
time_range_in(dt, '2014-06-25-00', '2014-06-27-00')
Explain FAILED:No driver accepted the query, because Driver
:org.apache.lens.driver.jdbc.JDBCDriver Cause :No candidate fact table
available to answer the query, because {"brief":"No candidate storages for any
table","details":{"fact2,fact1,rawfact":[{"cause":"NO_CANDIDATE_STORAGES","storageCauses":{"local":{"cause":"UNSUPPORTED"}}}]}}
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":{"fact2,fact1,rawfact":[{"cause":"NO_FACT_UPDATE_PERIODS_FOR_GIVEN_RANGE"}]}}
lens-shell>set lens.cube.query.add.nonexisting.partitions=true
Set param succeeded
lens-shell>query explain cube select measure2 from sample_cube where
time_range_in(dt, '2014-06-25-00', '2014-06-27-00')
Explain FAILED:No driver accepted the query, because Driver
:org.apache.lens.driver.jdbc.JDBCDriver Cause :No candidate fact table
available to answer the query, because {"brief":"No candidate storages for any
table","details":{"fact2,fact1,rawfact":[{"cause":"NO_CANDIDATE_STORAGES","storageCauses":{"local":{"cause":"UNSUPPORTED"}}}]}}
Driver :org.apache.lens.driver.hive.HiveDriver Cause :No candidate fact table
available to answer the query, because {"brief":"Missing partitions for the
cube table: [[2014-06-26], [2014-06-25,
2014-06-26]]","details":{"fact2,fact1":[{"cause":"MISSING_PARTITIONS","missingPartitions":["2014-06-26"]}],"rawfact":[{"cause":"MISSING_PARTITIONS","missingPartitions":["2014-06-25","2014-06-26"]}]}}
{noformat}
> Error Message for missing partition should list all the partitions missing
> --------------------------------------------------------------------------
>
> Key: LENS-272
> URL: https://issues.apache.org/jira/browse/LENS-272
> Project: Apache Lens
> Issue Type: Bug
> Reporter: Arshad Matin
> Assignee: Amareshwari Sriramadasu
>
> Currently error message for missing partition is only saying
> "NO_FACT_UPDATE_PERIODS_FOR_GIVEN_RANGE". It should list all the missing
> partitions. Also "brief" message is wrong.
> {CODE}
> Explain FAILED:No driver accepted the query, because Driver
> :org.apache.lens.driver.hive.HiveDriver Cause :No candidate fact table
> available to answer the query, because {"brief":"Picked table Had more weight
> than
> minimum.","details":{"f1":{"cause":"COLUMN_NOT_FOUND","missingColumns":["c1"]},"f2":{"cause":"NO_FACT_UPDATE_PERIODS_FOR_GIVEN_RANGE"},"f3,f4":{"cause":"MORE_WEIGHT"}}}
> {CODE}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
