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
