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 <[email protected]> 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 > > >
