lens-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rajat Khandelwal <rajatgupt...@gmail.com>
Subject Re: NoCandidateDimAvailableException
Date Thu, 15 Sep 2016 15:24:37 GMT
You have to add "mysql" in the list of supported storages in the driver
config file (jdbcdriver-site.xml).

On Thu, Sep 15, 2016 at 8:05 PM Pawan Malwal <pawan.malwal@huawei.com>
wrote:

> Hi Lens Developers,
>
>
>
> Here is an observation on Lens behavior. Can you please clarify ?
>
>
>
> I have configured jdbc/jdbc3 driver for MySQL and created the required
> entities in Lens cli. I see some ERROR  and
> “NoCandidateDimAvailableException” generated when I run a select query on
> dimension. Ideally lens should check all the drivers for expected entity
> and go for the driver which has required dimension registered to it. Not
> sure why does it log these ERRORS/ exceptions for other drivers hive/hive1
> ,  jdbc/jdbc1  and jdbc/jdbc2?
>
>
>
>
>
> 15 Sep 2016 14:20:28 [96204879-9158-4ef4-82d7-3c7b47474ee9] [estimate-3]
> ERROR org.apache.lens.cube.parse.CubeQueryContext - Query rewrite failed
> due to NO_CANDIDATE_DIM_AVAILABLE, Cause
> PruneCauses.BriefAndDetailedError(brief=No candidate storages for any
> table,
> details={employee_table=[CandidateTablePruneCause(cause=NO_CANDIDATE_STORAGES,
> storageCauses={mysql=CandidateTablePruneCause.SkipStorageCause(cause=UNSUPPORTED,
> updatePeriodRejectionCause=null, nonExistantPartCols=null)},
> missingPartitions=null, missingUpdatePeriods=null, missingColumns=null,
> missingExpressions=null, joinColumns=null,
> columnsMissingDefaultAggregate=null, unsupportedTimeDims=null,
> maxTimeCovered=null, invalidRanges=null)]})
>
> 15 Sep 2016 14:20:28 [96204879-9158-4ef4-82d7-3c7b47474ee9] [estimate-2]
> ERROR org.apache.lens.cube.parse.CubeQueryContext - Query rewrite failed
> due to NO_CANDIDATE_DIM_AVAILABLE, Cause
> PruneCauses.BriefAndDetailedError(brief=No candidate storages for any
> table,
> details={employee_table=[CandidateTablePruneCause(cause=NO_CANDIDATE_STORAGES,
> storageCauses={mysql=CandidateTablePruneCause.SkipStorageCause(cause=UNSUPPORTED,
> updatePeriodRejectionCause=null, nonExistantPartCols=null)},
> missingPartitions=null, missingUpdatePeriods=null, missingColumns=null,
> missingExpressions=null, joinColumns=null,
> columnsMissingDefaultAggregate=null, unsupportedTimeDims=null,
> maxTimeCovered=null, invalidRanges=null)]})
>
> 15 Sep 2016 14:20:28 [96204879-9158-4ef4-82d7-3c7b47474ee9] [estimate-4]
> ERROR org.apache.lens.cube.parse.CubeQueryContext - Query rewrite failed
> due to NO_CANDIDATE_DIM_AVAILABLE, Cause
> PruneCauses.BriefAndDetailedError(brief=No candidate storages for any
> table,
> details={employee_table=[CandidateTablePruneCause(cause=NO_CANDIDATE_STORAGES,
> storageCauses={mysql=CandidateTablePruneCause.SkipStorageCause(cause=UNSUPPORTED,
> updatePeriodRejectionCause=null, nonExistantPartCols=null)},
> missingPartitions=null, missingUpdatePeriods=null, missingColumns=null,
> missingExpressions=null, joinColumns=null,
> columnsMissingDefaultAggregate=null, unsupportedTimeDims=null,
> maxTimeCovered=null, invalidRanges=null)]})
>
> 15 Sep 2016 14:20:28 [96204879-9158-4ef4-82d7-3c7b47474ee9] [estimate-3]
> WARN  org.apache.lens.server.rewrite.RewriteUtil - Driver : jdbc/jdbc2
>  Skipped for the query rewriting due to
>
> org.apache.lens.cube.error.NoCandidateDimAvailableException:
> NO_CANDIDATE_DIM_AVAILABLE[No candidate storages for any table]
>
>         at
> org.apache.lens.cube.parse.CubeQueryContext.pickCandidateDimsToQuery(CubeQueryContext.java:820)
> ~[lens-cube-2.5.0-beta.jar:2.5.0-beta]
>
>         at
> org.apache.lens.cube.parse.CubeQueryContext.toHQL(CubeQueryContext.java:886)
> ~[lens-cube-2.5.0-beta.jar:2.5.0-beta]
>
>         at
> org.apache.lens.server.rewrite.RewriteUtil$DriverRewriterRunnable.run(RewriteUtil.java:391)
> ~[classes/:na]
>
>         at
> org.apache.lens.server.query.QueryExecutionServiceImpl$RewriteEstimateRunnable.run(QueryExecutionServiceImpl.java:1416)
> [classes/:na]
>
>         at
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
> [na:1.8.0_40]
>
>         at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> [na:1.8.0_40]
>
>         at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> [na:1.8.0_40]
>
>         at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> [na:1.8.0_40]
>
>         at java.lang.Thread.run(Thread.java:745) [na:1.8.0_40]
>
> 15 Sep 2016 14:20:28 [96204879-9158-4ef4-82d7-3c7b47474ee9] [estimate-2]
> WARN  org.apache.lens.server.rewrite.RewriteUtil - Driver : hive/hive1
> Skipped for the query rewriting due to
>
> org.apache.lens.cube.error.NoCandidateDimAvailableException:
> NO_CANDIDATE_DIM_AVAILABLE[No candidate storages for any table]
>
>         at
> org.apache.lens.cube.parse.CubeQueryContext.pickCandidateDimsToQuery(CubeQueryContext.java:820)
> ~[lens-cube-2.5.0-beta.jar:2.5.0-beta]
>
>         at
> org.apache.lens.cube.parse.CubeQueryContext.toHQL(CubeQueryContext.java:886)
> ~[lens-cube-2.5.0-beta.jar:2.5.0-beta]
>
>         at
> org.apache.lens.server.rewrite.RewriteUtil$DriverRewriterRunnable.run(RewriteUtil.java:391)
> ~[classes/:na]
>
>         at
> org.apache.lens.server.query.QueryExecutionServiceImpl$RewriteEstimateRunnable.run(QueryExecutionServiceImpl.java:1416)
> [classes/:na]
>
>         at
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
> [na:1.8.0_40]
>
>         at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> [na:1.8.0_40]
>
>         at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> [na:1.8.0_40]
>
>         at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> [na:1.8.0_40]
>
>         at java.lang.Thread.run(Thread.java:745) [na:1.8.0_40]
>
> 15 Sep 2016 14:20:28 [96204879-9158-4ef4-82d7-3c7b47474ee9] [estimate-4]
> WARN  org.apache.lens.server.rewrite.RewriteUtil - Driver : jdbc/jdbc1
> Skipped for the query rewriting due to
>
> org.apache.lens.cube.error.NoCandidateDimAvailableException:
> NO_CANDIDATE_DIM_AVAILABLE[No candidate storages for any table]
>
>         at
> org.apache.lens.cube.parse.CubeQueryContext.pickCandidateDimsToQuery(CubeQueryContext.java:820)
> ~[lens-cube-2.5.0-beta.jar:2.5.0-beta]
>
>         at
> org.apache.lens.cube.parse.CubeQueryContext.toHQL(CubeQueryContext.java:886)
> ~[lens-cube-2.5.0-beta.jar:2.5.0-beta]
>
>         at
> org.apache.lens.server.rewrite.RewriteUtil$DriverRewriterRunnable.run(RewriteUtil.java:391)
> ~[classes/:na]
>
>         at
> org.apache.lens.server.query.QueryExecutionServiceImpl$RewriteEstimateRunnable.run(QueryExecutionServiceImpl.java:1416)
> [classes/:na]
>
>         at
> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
> [na:1.8.0_40]
>
>         at java.util.concurrent.FutureTask.run(FutureTask.java:266)
> [na:1.8.0_40]
>
>         at
> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
> [na:1.8.0_40]
>
>         at
> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
> [na:1.8.0_40]
>
>         at java.lang.Thread.run(Thread.java:745) [na:1.8.0_40]
>
> 15 Sep 2016 14:20:28 [96204879-9158-4ef4-82d7-3c7b47474ee9] [estimate-3]
> ERROR org.apache.lens.server.query.QueryExecutionServiceImpl - Estimate
> skipped since rewrite failed for driver jdbc/jdbc2 cause:  Driver
> :jdbc/jdbc2 Cause :NO_CANDIDATE_DIM_AVAILABLE[No candidate storages for any
> table]
>
> 15 Sep 2016 14:20:28 [96204879-9158-4ef4-82d7-3c7b47474ee9] [estimate-4]
> ERROR org.apache.lens.server.query.QueryExecutionServiceImpl - Estimate
> skipped since rewrite failed for driver jdbc/jdbc1 cause:  Driver
> :jdbc/jdbc1 Cause :NO_CANDIDATE_DIM_AVAILABLE[No candidate storages for any
> table]
>
>
>
> Regards
>
> Pawan Malwal
>
>
>

Mime
View raw message