[LENS-1429] Queries failing intermittently with NO_REF_COL_AVAILABLE

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.7
• Component/s: cube
• Assignee: SushilMohanty
• Reporter: SushilMohanty
• Created: 01/Jun/17 12:44
• Updated: 06/Feb/18 05:53
• Resolved: 06/Jun/17 10:06

Description

Have seen queries failing intermittently with below error.

16 May 2017 11:59:39 [5af8e7ad-b9d7-44db-abdf-d8a28bdb9f3c] [f38a238e-abcb-4168-a052-7114cee1c3a6 estimate-128] WARN  org.apache.lens.server.rewrite.RewriteUtil - Driver : hive/prod  Skipped for the query rewriting due to
org.apache.lens.server.api.error.LensException: NO_REF_COL_AVAILABLE[my_ref_col]
        at org.apache.lens.cube.parse.DenormalizationResolver$DenormalizationContext.pickColumnsForTable(DenormalizationResolver.java:227) ~[lens-cube-2.7.0-SNAPSHOT.jar:2.7.0-SNAPSHOT]
        at org.apache.lens.cube.parse.DenormalizationResolver$DenormalizationContext.rewriteDenormctx(DenormalizationResolver.java:150) ~[lens-cube-2.7.0-SNAPSHOT.jar:2.7.0-SNAPSHOT]
        at org.apache.lens.cube.parse.DimHQLContext.addDenormDims(DimHQLContext.java:119) ~[lens-cube-2.7.0-SNAPSHOT.jar:2.7.0-SNAPSHOT]
        at org.apache.lens.cube.parse.MultiCandidateQueryWriterContext.addDenormDims(MultiCandidateQueryWriterContext.java:56) ~[lens-cube-2.7.0-SNAPSHOT.jar:2.7.0-SNAPSHOT]
        at org.apache.lens.cube.parse.CubeQueryContext.getQueryWriter(CubeQueryContext.java:927) ~[lens-cube-2.7.0-SNAPSHOT.jar:2.7.0-SNAPSHOT]
        at org.apache.lens.cube.parse.CubeQueryContext.toHQL(CubeQueryContext.java:947) ~[lens-cube-2.7.0-SNAPSHOT.jar:2.7.0-SNAPSHOT]
        at org.apache.lens.server.rewrite.RewriteUtil$DriverRewriterRunnable.run(RewriteUtil.java:396) ~[classes/:na]
        at org.apache.lens.server.query.QueryExecutionServiceImpl$RewriteEstimateRunnable.run(QueryExecutionServiceImpl.java:1855) [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]