Uploaded image for project: 'Apache Lens (Retired)'
  1. Apache Lens (Retired)
  2. LENS-1429

Queries failing intermittently with NO_REF_COL_AVAILABLE

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 2.7
    • cube
    • None

    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]
      

      Attachments

        1. LENS-1429.patch
          0.8 kB
          SushilMohanty

        Activity

          People

            sushilmohanty SushilMohanty
            sushilmohanty SushilMohanty
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment