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/02/05 06:10:34 UTC
[jira] [Commented] (LENS-272) Error Message for missing partition
should list all the partitions missing
[ 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)